Sometimes when a user tries to open a specific file, Access 2000 produces this message:
"The database has been placed in a state by user 'Admin' on machine '(whoever the user is)' that pevents it from being opened or locked."
The company I work for has the file located on the Printer public folder at \PRINTER\Public, and all users access the file by opening it from this location on their machines. There are a total of 15 users.
Does anyone know why this happens or, more importantly, how I can get this to NOT happen?
If it is helpful, I notice the user who is usually blocking access according to the error message is 'WOODY-PC', which is also a network folder.
Thanks in advance for the help in advance.