Opening another mdb file from a command button?

P

Peter Lawton

Is it possible to open another mdb file (i.e. close the current database and
open another) using a command button?

solution much appreciated

peter
 
R

Rick Brandt

Peter said:
Is it possible to open another mdb file (i.e. close the current
database and open another) using a command button?

solution much appreciated

peter
Click to expand...

Use shell() or FollowHyperlink to open the new file then DoCmd.Quit to close the
old one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open form in another database 1
command buttons "sometimes" don't work in Access 2007 1
Create a file 2
shell to run another mdb 4
Access Access Report Works on One Machine but not Another 3
close mdb from calling mdb 4
Opening a recordset 1
form load in accdb is slower than in mdb 1

Top