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?

i wont mind u explaining better,but for now i will suggest u place d 2 applications in the trusted centre.

i have based this suggestion on the assumption that the vba complanit program is access,if not let me know,keep the seceurity level low.get back to me explaining further the codes used to add/alter tables,the location of the tables(mytable.mdb)