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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2.0 11
connect to Access 2.0 db and export all objects 1
access conversiom from 2.0 to 2003 0
Convert Access 2.0 to Access 2000 3
Converting MS Access 2002 to 2.0 5
Access 2.0 Conversion to Access 2003 1
Conversion of 2.0 database to 2002? 2003? 3
Sendkeys not working in Access 2007 10

Top