Ms access 2000 db in a state that prevents it from being opened or locked
Hi everyone,
I am testing a routine in ms access 2000 that will post to a database table
information on a form. There is a line of instruction that opens the
connection like that:
dim cnn as adodb.connection
set cnn = new adodb.connection
cnn.open currentproject.connection
The routine hung on the last line of instruction shown above and displays
the message:
"The database has been placed in a state by user 'Admin' on
machine 'server01' that prevents it from being opened or
locked"
I have no clue what that refers to. I checked both the folder and the ms
access file to see if the readonly property is checked, but it is not. Please
help!!
[726 byte] By [
mpoincare] at [2007-11-19 10:43:40]
# 1 Re: Ms access 2000 db in a state that prevents it from being opened or locked
do you have write access to the folder where the database resides (i.e. network securitynot just the readonly attribute)? Access creates an LDB file when a user enters the database, and if you don't have write access to the folder it cannot create it, which will (from memory) cause this error.
Zeb at 2007-11-9 13:41:46 >
# 2 Re: Ms access 2000 db in a state that prevents it from being opened or locked
"The database has been placed in a state by user 'Admin' on
machine 'server01' that prevents it from being opened or
locked" this can happen if ur program doesn't close the Connection after it not needed anymore so it reach the maximum Connection limit (maybe)
check ur code whether u had line that close the Connection Object otherwise it will burden ur Network Bandwith
goodluck
