Opening a MDB via VB

[b_karv]

Opening a MDB within a MDB via VB

Hi All,

How would you open another Access mdb via another mdb that is already open using vb or macro.

I am at the moment doing the following:

Application.OpenAccessProject "C:\UpdateAccess.mdb"

Also tried:

Application.OpenAccessProject "C:\UpdateAccess.mdb"

But I keep getting the runtime error message of:

Runtime error 7867
You have already have the database open


Thanks heaps in adavance

Kind regards

Karv

 

[supercharge]

I'm sorry but open for what, I'm wondering?

Tried hyperlink?

 

[TanisAgain]

You could try the shell command.

Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office\Office\msaccess.exe PathNameToDB.mdb"
Call Shell(stAppName, 1)

 

[b_karv]

Thanks for that.

The reason why I like to do this is that I am making my db auto-update. What happens is that when the db is loaded if an update is nessecary it opens up another db. This db then copies all the latest files across and the re-opens the db.

However I ended up using bat file instead.


Thanks for the help

Cheers

Karv