When I opened one of my databases this morning, started working, soon I received the annoying: "3734 ("The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked")"
Since I work from my local drive, it is telling me that I have the database open... DDDUUUAA!!!!
The solution in my case was to close the database, and in the database open dialog click the drop down list contained within the Access 2007 database open button, and select to open it in exclusive mode.
Since I run with FE temp databases, is there a command line way to open access DB's in exclusive mode? Batch LOC I use to open DB's currently along the standard as follows:
I would not think there would be an issue with always running the FE DB's in exclusive mode, would there?
Since I work from my local drive, it is telling me that I have the database open... DDDUUUAA!!!!
The solution in my case was to close the database, and in the database open dialog click the drop down list contained within the Access 2007 database open button, and select to open it in exclusive mode.
Since I run with FE temp databases, is there a command line way to open access DB's in exclusive mode? Batch LOC I use to open DB's currently along the standard as follows:
Code:
:STARTDB
REM And run it!
START "Fandango Database" "%UserProfile%\Local Settings\Application Data\ClientCompanyName\Fandango\Fandango_FE.accdb"
