OPEN 2nd DATABASE

B

Brian

I would like to use code to do the following:

From an open Access 97 database, use code to open a
password-protected second database in run-time mode, and
then close the first Access 97 database. I need to end up
with the first database closed and the second database
open and in focus. Is there code that will do this?

I know how to use code in a shell function to open the
second database in run-time mode. I also know how to do
code with OpenDatabase that opens the second password-
protected database with code, but not in run-time mode.

I need to do them both, but can't get anything to work.
Thanks for any help.
 
A

Adam

Try the FollowHyperlink method to open the new database, and then
Application.Quit to close the original one. It works in Access 2000, but I'm
not sure about Access 97.

HTH
Adam
 

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

Opencurrentdatabase (without open a new database) 0
Run-Time Error '2950': 3
Being nosey 2
Access 2007 - Cannot open current database 1
Open Access database from within Access database 3
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Check if database is readonly? 2
open a password protected database with vba code using ecxel as fr 1

Top