Compact Access2000 on Vista clears db

[Per Ola]

Hi,
When running Compact and Repair on a Access 2000 database in Vista the
database is cleared, completly!

When issuing the command Access creates a dummy db.mdb file and compact the
database into this, then renaming it to the original name.
On Vista all folders are by default set to readonly, and this flag is reset
to readonly if you try to remove it.

Anyone know how this can be handled?
I use the compact and repair function both from Access itself and from a VB6
program.

Regards
Per Ola

 

[Arvin Meyer [MVP]]

I'd first check your permissions. Because of Vista UAC, there are restricted
permissions. You might try running as an administrator, or even turning off
UAC.

 

[Di Cook]

Hi Per Ola

I had this problem as well as program wouldn't export txt files to folder etc, got around it by giving the "Users" group full permission for the folder where program is saved. To do this go to the respective folder and click on Properties. Click on the "Security" tab. We want to change the permissions for this folder - to do this click on the Edit Button. Click on the "Continue" button when prompted. In the Groups or User Names Box click on the Users option then in the "Permissions" box (at bottom of dialog) click against "Full Control" item in the Allow box - a tick should appear in the Allow and Modify boxes. Click Apply and OK, then another OK to exit.

Don't forget to check whether you used sendkeys - they don't work in Vista either.

Regards
Di