Access 2003-Backup & Exit Database macro

[Orson9750]

I am using Access 2003. I am having trouble searching the internet for help on creating a backup and exit macro. Can someone help me?

Thanks

 

[ajetrumpet]

you might want to try this code:

dbengine.compactdatabase "current db full path", _
   "full path of the new db"

application.quit

 

[Orson9750]

Thanks much for your quick reply. I will let you know how it works for me. Again thanks