ADO RecordSet Save generates "Access Denied" error (80070005)

J

JoeB

I have an Access DB with some code that has been (and still is) running fine
for a long time. I have recently set up a few Windows 7 x64 machines, and
this bombs on those machines only. (other machines are Vista 32-bit).

The code is using an ADODB RecordSet to create a new record (AddNew), sets
the various columns to appropriate values, and then does a Save. I get the
Access Denied error on the Save command, but when I examine the table, the
record has been created successfully.

Any ideas on what is different between the two environments that might be
causing this?

Any techniques I can use to further debug?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy ADO Recordset 2
>> ADO recordset moveprevious 8
Need help opening ADO recordset. 14
ADO Recordset 1
Passing ADO Recordset into a Sub procedure 1
Passing an Updateable ADO Recordset To VBA Subroutine 5
Display ADO recordset 5
ADO OpenRecordset Error 80004005 6

Top