Running other Access Databases with forms 2

[JaySang]

Whats the easiest or best way to launch other MS Access database on a form inside of your main database ?

I have a main central database and I want to link to other existing databases

any suggestions ?

Thanks Everyone!

 

[psemianonymous]

Open the database with the ShellExecute command--all you have to do is pass in the database path and filename and it will open the second database for you in a new window.


If you use Access/JET security, ShellExecute to the shortcut to the database, if that makes any sense to you.

http://www.mvps.org/access/api/api0018.htm

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[cmmrfrds]

I have used this method to launch an Access Project.

Public pubAppAccess As Access.Application
Public pubFilePath As String
Public pubStartWindow As String, pubObj As Object

' Open Access project.
pubFilePath = "Crojects\remotepubs.adp"
Set pubAppAccess = New Access.Application
pubAppAccess.OpenAccessProject pubFilePath

pubAppAccess.Application.RefreshDatabaseWindow
pubAppAccess.Application.Visible = True
DoCmd.Close

 

[JaySang]

is there anyway you can lauch another app without the complete path like :
pubFilePath = "Crojects\remotepubs.adp"

I wan't the filename to be dynamic just incase the file moves anywhere. Are there any wildcards that will allow it to just start in the current directory ?? so i can just list the file name

Thanks In Advance

 

[psemianonymous]

?left(currentdb.name, len(currentdb.Name)-len(dir(currentdb.Name)))

will return the current directory of the database opened. You can work the dynamic part from that starting point.

 

[JaySang]

I'm confused what this is - ?left(currentdb.name, len(currentdb.Name)-len(dir(currentdb.Name)))

can i put that as my path - pubFilePath = "?left(currentdb.name, len(currentdb.Name)-len(dir(currentdb.Name)))\remotepubs.adp"

like that or do i put that in a varibale and put that in my path

can anyone please clarify

thanks

 

[psemianonymous]

sorry, I tested that in my immediate window (CTRL-G) and it worked, so i just pasted it from there. Take out the question-mark and you're good.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm