Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
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

  • Community Leader
  • 25,310 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