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.
