Executing an Access database

[jassie]

In an Access 2000 database that I plan to convert to Access 2013, I am trying to determine if the users enter any information into the access database using the access database.
I click on a form and the screen has a button that says 'run macro' so I click on it. I then get the error message, 'File sharing lock count exceeded. Increase MaxLocksPerFile registry entry'.
I click on the other form that exists in the database and it says, "The record source 'Module2' specified on this form or report does not exist'.


I run one of the macros and it says a certain file does not exist.
Thus can you tell me what else I could look at to see what the users are actually accessing? If there is nothing else that the users can click on, then it looks like the vb application that use the Access database actually 'drive' (run) the updates to the access database correct?

[ranman256]

Sometimes these are false errors due to another error.
(sometimes ALL code will get deleted from the db)
Click on MODULES, can you see them? Is Module2 actually there? Any of them?

[jassie]

Modules1 and Module11 do exist. When I click on either module, I get the error message, "'File sharing lock count exceeded. Increase MaxLocksPerFile registry entry'."

[ranman256]

Its a weird error if this exists only on your PC.
If it is on the network, then I can see this error, but if its only you. something is corrupt.
I too have gotten this error on my stand alone pc. the data got hosed, but I kept working on it.

You could try what I did,
repair the db
create a new db.
import ALL items from the old db, to the new one.
I got rid of that false error.

[CJ_London]

if you are opening a 2000 db in 2013 I don't think they are compatible - you need to upgrade to accdb

see this link

https://technet.microsoft.com/en-us/.../cc178954.aspx


also see these links

http://www.bristol.ac.uk/it-services...pgrade-issues/
https://support.office.com/en-sg/art...4-db0cf7c11acd

[ItsMe]

I am confused about what the OP has tried and what is not working. I would like to add that 2013 can link to mdb files. If there was an attempt to open an mdb file directly from a computer running Access 2013 I recommend marking that point in time and removing the data from that file. Start over and use an MDB file as the backend or place the data in an accdb file if everyone is running 2007 and newer.