Compact & Repair using SendKeys 4

[EVE734]

Hi - I wanted to set up a command button that would perform a "compact and repair" upon click. I found an old thread - thread 181-73087 - that had a simple suggestion.

The "compact" macro (sendkeys %TDC) seems to work great, but the "repair" macro (using sendkeys %TDR) doesn't seem to work. The original thread was pertaining to Access97 and I assume that is the problem as I am in Access2000.

With Access 2000, do the sendkeys %TDC perform both the compact and repair?

Can anyone help?
Thanks,
Evelyn

 

[PHV]

May you look the contents of "H:\Cpp\Evelyn\Screening\Archive\Live data 6_7_be.[!]ldb[/!]"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ed2020]

I'm afraid I'm stumped with this one now. I have tested the code on a database I have and it works fine.

Hmmmm...

Perhaps try creating a copy of the database on your hard drive and testing it there - that way you can be *sure* there is nobody else in it?

Ed Metcalfe.

Please do not feed the trolls.....

 

[EVE734]

Ed - Well, I attempted to put a copy of the dbase on the hard drive and it actually will not let me do that either. Obviously there is some setting on the file that is giving me problems - I'm sure I'll get to the bottom of it, and then I'm sure the code will work beautifully.

Once I get this all sorted out, I'll confirm.
Sorry for all the trouble - THANK YOU!


PH - Thanks to you as well. All the help is greatly appreciated.

 

[combo]

It is possible to directly compact A2000 database with code, see thread705-961686

combo