ODBC Error S1000: Could not update

[tkl]

I have the following problem running my CF-Application with an MSAccess database (Access 2000):

From time to time I get an error message

ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'xxx' on machine 'yyy'.

It seems there are several updates to the same database from pages in a frameset that get updated the same time.

What can do to prevent this locking issue? Neither MS nor Allaire have any helpfull hints.

Thomas

PS: I am surely not the only one experiencing this problem. Search for 'odbc s1000 "could not update"' on

http://www.altavista.com

and you get thousands of hits!

 

[giahan]

Thomas,

This happens when someone is openning the Access file. User XXX on the machine YYY is the "culprit"

Hope this helps

GH

 

[tkl]

GH,

Thanks for your reply.

The problem is that user XXX on the machine YYY is not some human user but the ColdFusion server!

Thomas

 

[giahan]

Then check if the access file permission. If the permission is set to a group or person, so you can't do anything unless your name on it. If the file is open, close it. While you're having the transaction, access file needs to be close (I mean the table you're working with). Is there anyone else access the database file that you're working? the file can be open but the table can't.

Hope this helps.


GH

 

[tkl]

GH,

Thanks, but I can't stress it enough: NO-ONE but ColdFusion is accessing the database.

The problem disappears if I go into ColdFusion Adminstrator and set 'Limit simultaneous requests' to 1 (one)*.

If I set 'Limit simultaneous requests' to 2 or more * the problem appears again.

*) I know I have to restart ColdFusion for this setting to take effect.

Thomas

 

[kristof]

Hi,

What might help is the following:

In the DSN settings on the CF Server you can see more advanced settings by clicking
CF Settings >>

There you'll see a checkbox with maintain database connection

This is by default active. You should deselect it.
If de-activated CF Server will release connection immediately after the session closes.
If not, it keeps it open for quite some time.

Bye, hope this helps

Kristof

 

[tkl]

Hi,

I finally managed to locate the problem:

I have set up a database for storing the client variables.

If I limit the connections to this database to 1 connection the problem disappears. If I set the limit to 2 connections or disable the limit the problem reappears.

If I store the client variables within the registry the problem disappears too.

All other settings (maintain database connection etc) are set to their default values.

Thank you all for your valuable hints.

Thomas