Re: Could not update; currently locked error

Andriy wrote:
Hello,

I run a C++ test program that updates records in MS Access database
(mdb file) from different threads. I use ADO to access the database.
As far as I understand the underlying provider is MS Jet OLEDB. I get
the following error: Code = 80004005
Code meaning = Unspecified error
Source = Microsoft JET Database Engine
Description = Could not update; currently locked.

I do not understand why I get this error even when I insert records or
update different records. Is there any way to tell ADO/Jet not to
produce error but wait till records are unlocked?

Assuming the database is not marked Read-Only or resides on a cd, this
is most likely a permissions problem. In order for multi-user activity
to be supported, all users of the database file need to be able to
create, modify and delete a locking file (.ldb) in the folder containing
the database. Users need Modify permissions for that folder, not just
the database file.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • RE: Scecli and jet database event 1005 and 1202 repeating
    ... This issue occurs if the local Group Policy database file is corrupt. ... Microsoft CSS Online Newsgroup Support ... Open the %SystemRoot%\Security folder, create a new folder, and then ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange database growing rapidly
    ... But I am almost out of resources, the disk with the database installed is ... perform the similar process for Public Folder store. ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Speed of working on Access tables
    ... You'd probably get a better discussion in an Access-dedicated newsgroup, ... The database already exists, so I don't need to create the ... What methods can I use to do the work on the Access database that I have ... I have read that ODBC is faster than ADO, ...
    (microsoft.public.office.developer.automation)
  • Re: New to DB Development
    ... Psuedo means fake or pretend which is a good ... opposed to one large database. ... > then see if the other folder exists, ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Concurrency Violation in DataSet Update ADO.NET
    ... Now I am developing Cheque Writing ... 'UPDATE DATABASE ... "TBKKTC") ... I use password to protect my Access database from ...
    (microsoft.public.dotnet.general)