MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening an Access Database.


Posted by Mark on January 16, 2002 5:04 PM

G'day,
Can anyone assist me with the correct syntax for opening a MDB file, "AppApplication" only opens Access, not the file in question.

Now, I don't need to import/export any data as the table in the DB is already linked to the worksheet, I just need a macro to open the DB so I can then print reports that have been setup.

Any assistance is appreciated.

TIA

Mark.


Posted by Tom Urtis on January 16, 2002 5:18 PM

See if this helps - - 13207.html

Posted by Mark on January 22, 2002 1:40 PM

Thanks Tom, works well, but.

Have got the DB opening & operating well, but now the opposite is the problem, I can't seem to close Access unless I use the Task Manager.

Any theories on what may be causing Excel to stop Access from closing.