Locking error on export
Updated 2009-11-11 | Filed under OnWeb | PDF
Problem
In the export phase of synchronizing, I get an error:
SQLHY000: The database has been placed in a state by an unknown user
that prevents it from being opened or locked.
Solution
This occurs because you have modified an object (usually a toolbar) which required Access to grab an exclusive lock on the database. OnWeb presently requires shared-locking in order to correctly export your application.
To resolve this, please:
1) In Access, check Tools | Options | Advanced and ensure that the 'Default open mode' is set to 'Shared'.
2) Close and reopen your database, holding down the 'shift' key on your keyboard while opening it.
3) Synchronize.
Related Articles
- Locking error on import (0.561355193729)
- "No current record" error during export (0.449766376277)
- OnWeb displays only a blank screen and no forms or other windows (0.432860742324)
- EQL Access Geosync - User Guide (0.423785231895)
Unrelated Articles
- Database Comparisons (0.110047331416)
- How EQL OnWeb Works Part 1 (0.116029294047)
- Supported Access Versions (0.118877001139)
- Support for databases other than Access (0.159547994364)