Automation problem when I changed from 2003 to 2007

[williamlove]

I use VBA Automation to add and modify rows in a table in an Access 2003 (MyData.mdb) database file. The VBA compliant program that writes to the database is called RSView.

When I used Access 2003 I could have an instance of Access open and be working on the database and without it interfering at all with RSView appending or modifying records.

After installing Access 2007, I cannot work on the database without interfering with the automation. The RSView VBA routine throws this exception:

“Error -2147467259: The database has been placed in a state by user 'Admin' on machine 'D2VW9DH1' that prevents it from being opened or locked."

I reduced macro security so that they can run without prompting, and I went into the trust center and made the folders used by RSView trusted locations. The problem is still present. I do not need any security or restrictions at all, none are needed, and I’d like to get rid of this problem. Can you help?

 

[vgarzon]

HI,

I'm Having the same trouble except that I'm working with access 2007 since the beginning of my project. I get the same Error.

Did you managed to solve that problem? If so, please tell me how you did.

Thanks in advance.