Hi ImAGine,

I have a quit function within the Access Macro, but it is still running
in the background sucking system resources. Is there something that I'm missing?
Should Excel close Access instead of Access closing itself?
If so, how would Excel know that the Access Macro's have completed running?

You should close access yourself from Excel:

AppAccess.Quit
Set AppAcces=Nothing

Since you set an object reference to access (AppAccess), you can use access code from within Excel to open the database.
That way, the code of the autoexec will execute before the next macro command in Excel will be done.

Something like this (untested):

(Set a reference to the Microsoft Access library using tools, references)

Dim AccessApp As Access.Application
AccessApp.OpenCurrentDatabase "YourFIle"
DoEvents
AccessApp.Quit

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com