DB locked, could not save....

[guineamation]

Hi All,
when trying to update the DB via an admin panel, i get this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not save; currently locked by user 'admin' on machine 'W2K1920'.

/admin/inc_machina_edit.asp, line 107
-------------------------------------------------

Set con = Server.CreateObject("ADODB.Connection")
con.open conn_STRING

line 107: con.execute (MySQL)

i have some RecordSets open using the same connection string, is it a problem? what else can cause the DB to be locked for editing?

 

[FesterSXS]

someone might have opened the access database directly. This creates a lockfile (yourdatabase.ldb) which prevents the database from being edited from elsewhere.

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[guineamation]

the database is located on a remote server of my hosting, cant open it directly and i dont imagine some one on the remote server opened it...

 

[Rhys666]

Yes your open recordsets could be locking tables/data and causing the error, or someone else could be accessing the dB via the app and locking data/tables.

Rhys
"There are some oddities in the perspective with which we see the world. The fact that we live at the bottom of a deep gravity well, on the surface of a gas-covered planet going around a nuclear fireball 90 million miles away and think this to be normal is obviously some indication of how skewed our perspective tends to be"
DOUGLAS AD

 

[guineamation]

if i set the locktype of the rest of the record sets to read only that should solve the problem? because now there is no lockType configured (default is read only)...

 

[Rhys666]

Is there any reason you need the recordsets open whilst you're updating?

Rhys
"There are some oddities in the perspective with which we see the world. The fact that we live at the bottom of a deep gravity well, on the surface of a gas-covered planet going around a nuclear fireball 90 million miles away and think this to be normal is obviously some indication of how skewed our perspective tends to be"
DOUGLAS AD

 

[guineamation]

thanks for the focusing, there was actually no reason for the recordsets to be open, i cleaned up the code a little but and now everything works ok....

Thanks Rhys666