Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-14 : 19:09:04
|
Garrett writes "Hello,
I'm updating a number of tables in a local (Access) database with the results of a form but I keep getting an error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'XXXXX'.
The SQL that I'm executing is sound and works .... and so I dont understand that the problem could be.
Must I explicitly "commit" or something if I'm updating a table, then another, then updating the first table again ??
Your help O' SQL guru would be much appreciated." |
|
|
|
|
|
Database locking with ADO