Problems with MSysModules2

[LonnieJohnson]

I have a weird situaltion. All of a sudden my users cannot get into a database after one person opens a copy of it. They are getting the following message:


The database engine couldn't lock table 'MSysModules2' because it's already in use by another person or process.

Now the funny thing is that the database they are opening is a front end mdb that each of them have a copy of. No two people are opening the same database. This is happening over a network. Each user has their own home directory with a copy of this database. The back is SQL Server 2000.

Can anyone help!!!!

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[Hap007]

Dear LonnieJohnson,

That is weird.

Couple of thoughts:
1) Get a copy of the program, compact and recompile
2) Makesure that your users are all running the same version of access.
3) Makesure everyone is indeed opening their own copy, sometimes things change.
4) When all else fails, create a new, dumb access db that is linked to the SQL backend, and see if you get the same error when multiple people open that. By doing this test, you will identify the problem as being related to your one original Access app, or to the network and Access setup as a whole.

Good Luck,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers