SendKeys Macro to Comapct Database in Conversion 2.0 to Access 200

D

David Gildea

Hi All,

I am trying to convert an Access 2.0 database to an Access 2003 database
however I am having trouble converting a SendKey macro that in Access 2.0
compacts the database. I dont full understand how it is doing this.
the macro is:

SendKeys "c:\statement\database.mdb~c:\statement\temp.mdb~"
DoMenuItems 4, 0, 2

I am not too sure what this is trying to do, but it ends uo comapcting the
database in Access 2.0.

Thanks for any help
 
J

Joan Wild

I'm not sure about those menu items in version 2, however you could do away
with the macro entirely. In 2003 there is an option (Tools, Options) to
compact the database on close.
 
Top