Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Cannot open database ". It may not be a database that your applica


Best Answer zacharycarter , 27 May 2015 - 12:25 PM

The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Rep... Go to the full post »


  • Please log in to reply

#1
saulbernard

saulbernard

    New Member

  • Member
  • Pip
  • 1 posts

Sure this is a very common problem people have.

I'm using Access 2003 with front-end forms, 5 people log into the database most of the time and access the same table from the front-end forms. Now and again a record becomes corrupt and just shows "#error" or "#Delete" in all the fields and it can't be deleted. I first thought this could of been just a network error but it's happening to often. I then changed the layout of the table as it had a "memo" field which I have now taken out and put in it's own table and this table now doesnt' corrupt.

 

So I can only think it's down to the multi-users hammering the same table at the same time. Is there anything I can do to stop this, if it's to change the design of how everything works or anything else I can do to the database.

 

Thanks


  • 0

Advertisements


#2
zacharycarter

zacharycarter

    New Member

  • Member
  • Pip
  • 1 posts
✓  Best Answer

The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:

 

1. Do not open Access database must closed

2. Sufficient storage space available - minimum double in size of your Access database on that Disk.

3. Close the .mdb file related to .ldb file before you delete the .ldb file.

4. Then Run the Compact and Repair tool

 

See if this helps:

 

http://itknowledgeex...-pc-to-network/

http://www.filerepai...s-2007-database

https://www.repairto...cessrepair.htmlAccess Repair Toolbox


  • 0

#3
azarl

azarl

    GeekU Admin

  • Administrator
  • 25,176 posts
So I can only think it's down to the multi-users hammering the same table at the same time. Is there anything I can do to stop this, if it's to change the design of how everything works or anything else I can do to the database.

 

Almost certainly. You need to lock records during edit

 

http://www.databased...rd-locking.html


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP