The Compacted Access 2007 Database can't be opened. Please help

K

Kevin

I run the code as following:
===========
S1 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=info.accdb;Jet
OLEDB:Engine Type=5"
S2 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=tmp.accdb;Jet
OLEDB:Engine Type=5"
xJRO.CompactDatabase S1, S2
==========
It runed OK, and I got the database tmp.accdb. But I try to open the
database in Access 2007, it shows a dialog "you don't have the necessary
permissions to use the "E:\test\tmp.accdb" object. Have your system
administrator or the person who created the obejct establish the appropriate
permissions for you."
What's happened? I can open the database info.accdb, but I can't open the
compacted database tmp.accdb.
There are not database password or user group permissions on the database
info.accdb.
If it is Access 2003 database, everything is OK.
 

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

Top