A baffeling error which is elusive , ODBC Drivers error '80004005'

[Guest_imported]

--------------------------------------------------------------------------------
I was building this job list for my company and I was having some problems... I figured them out finally and it was "working like a treat" on my machine.

I uploaded and tested and received this 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 'SOL'.

?

Now the process I am attempting to do is update multiple records and rows using a loop. Could the cursor type have anything to do with this?

Thanks in advance.

 

[Tarwn]

Make sure you are not currently editing the database in another window. What has happened is that a connection with admon rights currently has a lock on the table you are attempting to update. In other words, a connection is open with read/write privelages and has locked the table until it finishes making whatever changes it is going to make. This error can occur if you have a vb program running with a lock or if you have the manager opened to that particular table. While I have not seen this error before with access, these would be my assumptions. One other possibility is that the access file is set to read only (happens occasionally when moving to another machine) and the driver can only interpret that as locked. Check the file permissions on the access file, make sure nothing else is accessing the file, and then try again.
-Tarwn

 

[codestorm]

Sounds like a problem related to which .mdw (security users/groups) file you've got Access using.
codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>

 

[Guest_imported]

Hi Guys my ISP still does not know the answer and either do I??? I have begun the digresion to crazy land!

Please if you think you can help me (I am not an expert coder... but I work hard at what I do code), I could really benefit from some experience and wisdom.

Thanks in advance.

 

[codestorm]

Step 1: (in the world according to ben)
On the machine you developed the database on,
open windows explorer and go to c:\program files\microsoft office\office, look for and run MS Access Workgroup Administrator. You should be using something like c:\program files\common files\system\system.mdw.
Check if this is the case.
NOTE some of these paths may differ slightly if you are using something older than MS Office 2000. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
You're not a complete programmer unless you know how to guess.
I hope I never consider myself an 'expert'.
<insert witticism here>