Object variables are always closed when a procedure closes. If you want to open Access and keep it open try using The SHELL command.
Something like.
Shell("C:\Program Files\Microsoft Office\OFFICE11\msAccess.EXE", 1)
|
Results 1 to 3 of 3
Thread: Excel shutting down access?Threaded View
|
Click Here to Expand Forum to Full Width |