Microsoft Jet stopping opening process

[Guest]

I have a huge mailing list database that I created on one computer with only
one user. It is now a year later and time to send out more mailings and I
get an error:
"Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same
time."

I am the only user that "attempted to change" the data and it won't get any
farther than that message.

Frustration Relief?

 

[G. Vaught]

During the year did you upgrade operating systems to something like Windows
2000 Pro or Windows XP Professional? If either, did you implement NTFS? If
so, it is possible the folder where the database resides does not have the
proper permissions.

 

[Guest]

We did nothing different with the computer such as upgrating OS or
re-formatting. I checked permissions and it should work, it just
doesn't...grrr.

Thanks for the advice though.
D

 

[Fred Boer]

Dear dthetech:

You may be dealing with some sort of corruption. These links might help:

Q182867 ACC: Jet Database Engine 3.x Error Messages Due to Corruption
http://support.microsoft.com/kb/q182867/

Q306829 ACC97: How to Troubleshoot Corruption in an Access Database
http://support.microsoft.com/kb/q306829/

Q279334 ACC97: How to Repair a Damaged Jet 3.5 Database
http://support.microsoft.com/kb/q279334/

Q303519 ACC: How to Minimize Database Corruption When Using Jet 3.x
http://support.microsoft.com/kb/q303519/

And.. a quote from a post by the redoubtable Mr. John Vinson (MVP):

This often happens when an old "database lock" is left over from
(e.g.) a previous crash. Get out of the database altogether and look
for a file with the same filename as the .mdb file but with a .ldb
extension (I think it will always be in the same subdirectory). Delete
it.

If this doesn't solve the problem, create a new, empty database and
use File... Get External Data... Import to import everything from this
database. Check the new database, if it's ok delete the old one and
rename the new one. This will give you a clean set of systems tables
and should resolve the problem.

John W. Vinson[MVP]

End quote....

HTH

Fred Boer