SendKeys Macro to Comapct Database in Conversion 2.0 to Access 200

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Gildea - 09 Dec 2004 10:33 GMT

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

Reply to this Message

Joan Wild - 09 Dec 2004 20:28 GMT

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.

> Hi All,
>
[quoted text clipped - 11 lines]
>
> Thanks for any help

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message