Changing databases.

I am trying to close one database and open another.

Why doesn't this work?

 Public Sub Vermilion()
 Application.CloseCurrentDatabase
 Application.NewCurrentDatabase "c:\acadiana\vermilion   parish directory.mdb"
 DoCmd.RunCommand acCmdOpenDatabase
 End Sub

The current dara base closes OK, but then nothing. BTW the path is correct.

Thanks.
instanetAsked:
Who is Participating?
 
FlorisMKConnect With a Mentor Commented:
CloseCurrentDatabase is an Access method.
So I guess this Sub lives inside the current database.
After you close that database, the code is unloaded and subsequent lines are not executed.

You can't switch databases from within a database.

You can, however, open two databases at the same time from code.
So if you don't need to actually use the _interface_ on the second database, just open the second one using the OpenDatabase method. That will open Vermilion.mdb invisibly, but available to VBA manipulation of the data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.