Opening another access DB

[NathanSavidge]

Hi,

I am trying to use one access database, to do version control etc on a users database before opening it.

If all is ok, i use

dim objAccess as access.application
Set objAccess = CreateObject("Access.Application")
objAccess.Visible = True
objAccess.OpenCurrentDatabase strUserPath & strUserFile

This works fine, however when i close the version control database, the users database also closes. Is there a way to do what i need to do, but keep the users database open when the version control database closes.

Thanks.

Nathan.

 

[vbaInet]

This:

dim objAccess as Object
Set objAccess = CreateObject("Access.Application")

or this:

dim objAccess as access.application
Set objAccess = new access.application

Former preferrable.