Jet Database Engine error on non-shared database

[Llobid]

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

 

[RuralGuy]

Forms and SubForms are "in fact" 2 different users of the same db as far as Access and Jet are concerned. Do you have "Name AutoCorrect" turned off. Do you "compact on Close"?

 

[Llobid]

Anything in the database is set with the defaults. I do not have the database "compact on Close". I also do not have any subforms...just 1st level forms.

 

[RuralGuy]

Hi,

You should turn off "Name AutoCorrect". You should check the "Compact on Close" feature. Have you put any VBA code in your project yet? VBA code can look like more than one user.