The database has been placed in a state by user on machine that prevents it from being opened or locked.

You are here:
< Back

The database has been placed in a state by user on machine that prevents it from being opened or locked.

When you had chosen to use Team TimeSheet with a Microsoft Access database, and getting this error report, it could be due to one of the following reasons:

1) One of the user might have had the Team TimeSheet database file (i.e., TeamTimeSheetSettings.mdb) opened in Microsoft Access application in exclusive/design mode, locking the file.

POSSIBLE FIX: Close/shutdown Microsoft Access application (that has the TeamTimeSheet database opened) should release the lock.

2) The Access database MDB file may have some form of corruption.

POSSIBLE FIX: Perform ‘compact and repair’ of that particular MDB file under Microsoft Access application.

3) The Team TimeSheet database is set to exclusive open mode.

POSSIBLE FIX: Make sure that Access is set to open in shared mode. This is the default setting, but you should check to be sure — if a user opens the database in exclusive mode, it will interfere with data availability.

Verify it from Microsoft Access > File > click Options > Client Settings > Advanced section,  select Shared under ‘Default open mode’ and ‘No Locks’ under ‘Default record locking’. click OK, and exit Access.