Open Database from another database

[musclecarlover07]

I want to open a db from another db.
I have compile many different variations:

Application.OpenAccessProject "Folder\Folder1\Folder2\Record Management.accdb"

I have done Application.Follow Hyperlink none of this works. If I put OpenAccesProject then it says the file is already open but its not. I can only think it would say that is because the tables are linked.
If I take the Record Management.accdb off it goes to the folder.

For certain reasons I have changed the name of the actual path to just folders. THe file name is the same.

 

[boblarson]

Are you wanting to control something within the other database or just open it? If it is just opening it you can use

Application.FollowHyperlink \\Server\Share\Folder\Folder\Record Management.accdb

 

[musclecarlover07]

I want to beable to get in it to edit records. Majority of the things we do we don't edit. But if we do need to edit it then thats what the record management is used for. It so people don't actually delete something while they work. Most people wont go into it but it would be easier just to click the button.

 

[musclecarlover07]

Like I said it will go to the folder if I leave the record management.accdb off. but when I add that it says its open or if i use the other method it says it cant find the location

 

[musclecarlover07]

Disregard. I misplelled somehthing.

 

[boblarson]

Like I said it will go to the folder if I leave the record management.accdb off. but when I add that it says its open or if i use the other method it says it cant find the location

You can then try this instead:

Dim accApp As Access.Application
 
Set accApp = New Access Application
 
With accApp
    .Visible = True
    .OpenCurrentDatabase("Folder\Folder1\Folder2\Record Management.accdb")
    .UserControl = True
End With