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
Parsing a recordset from an Oracle DB in Word with VBA 0
ADO Not Opening Recordset 2
>> ADO recordset moveprevious 8
Append externally sourced recordset to local access database 0
Problems saving XML file: Run-time error 2
Need help opening ADO recordset. 14
Passing ADO Recordset into a Sub procedure 1

Top