Open another database from within current database

K

Kathy Webster

While in Access XP, can you program a command button to open another
database, and leave the current database open as well?
 
B

bob

sure..simplest way is to create a label and put the fully qualified path
into the hyperlink address.

alternatives exist to that - but that is pretty simple.

Bob
 
M

Mahesh Yawantikar

Hello Kathy,
Reg. your query , i think its not possible, atleast until now to do
that. Even in Access 2003 its the same problem, when you want to open another
database, and leave the current database open, it doesn't work. That what, i
know, atleast until now.
 
A

Anthos

Sure it can work.
But you need to create a new Instance of MS Access

Public Function newMSAccess(strPathtoAccess As String)
Dim objMSAccess As New Access.Application
With objMSAccess
.OpenAccessProject strPathtoAccess, False
End With
End Function
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Hyperlink to open new window within document 0
Page numbering with Merged Document and IF statements 1
How do I clear a form? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Using Access Database to build contracts with fields on pdf document 0
How to open multiple instances of Word 365? 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top