Compact and Repair Vista Issue

[Ashley Thomer]

Does anyone know a fix around loosing your data when doing a compact and
repair in Microsoft Access on Vista? We have a quoting software, when they
select yes to optimize the database (compact and repair) it wipes their
entire database clean along with the backup copy on the desktop. Please
help...big problem!

Thanks
Ashley

 

[Allen Browne]

Ashley, can you provide any more details of this problem?

What version of Access?

Does this happen always? Occasionally? One in a blue moon?

Is the database split? If so, is it the front end or back end that
disappears?

Does it make any difference if you create a shortcut to msaccess.exe, and in
the properties of the shortcut check the Run As Administrator box? Details:
http://allenbrowne.com/bug-17.html#RunAsAdmin

 

[Tony Toews [MVP]]

Does anyone know a fix around loosing your data when doing a compact and
repair in Microsoft Access on Vista? We have a quoting software, when they
select yes to optimize the database (compact and repair) it wipes their
entire database clean along with the backup copy on the desktop. Please
help...big problem!

This sounds like you are programmatically doing the compact. What is
the line of code?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Ashley Thomer]

Access isn't even installed on the machine that is running the optimization.
It just uses the compact and repair tool.

This happens always, I created a fresh database and it did it to that one
also.

No database is not split.

I have it set to run as an administrator and in XP compatible mode.

I am just fit to be tied with this problem.

Ashley

 

[Allen Browne]

Okay, I'm not clear what you mean about the repair tool.

Is this JETCOMP.EXE?