opening another mdb from within a access db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a command that will open another access database from within access
database. what I'm hoping to do is have a button that opens a different
database.

thanks.

access newbi
 
Try using FollowHyperlink

Dim MyDb as String
MyDb = "c:\DbName.Mdb"
Application.FollowHyperlink MyDb
 
Or you have to deal with few lines of ADOX code that to manage your external
database.
AS far as I know this is your only option if the external database has
security features implemented on it (ie, requires password and userID to log
in).
Once you have logged into the external database you can do almoste
everything on it without having to opening it (if you use hyperlink it will
open your external databse as a second instance of Access and you hgave to
work on it from INSIDE it)
Using ADOX you can work on the external databse without onening it and fully
from your first database.

Hope this is clear, and maybe someoneesle can be more precise.
 
I added a hyperlink on a form by going to Insert, then Hyperlink. I
formatted the resulting label to look like a button with a raised special
effect and changed the caption to the name of the database rather than the
full path.
 
Back
Top