Accessing an Access DB from an Access DB.

[wricoasolutions]

Is it possible to access "Database B" (an Access Database) from a switchboard in "Database B" (A separate Access Database)? And, if so, how?

This is the third question I have asked on this forum and with each of the previous question the answers have been very helpful. Just want to say thanks in advance to everyone that is a part of this. Good job all.

Bill

 

[ghudson]

What part of db B do you want to access?

You can link the tables from db B to db A.

File / Get External Data / Link Tables

 

[wricoasolutions]

I am using Access 2000 and need to open a separate complete database. I am trying to pass control from the database that the switchboard is in to a separate database.

I may be approaching this wrong. What I may need is a shell to control which database is being used. I have 6 different Access DBs and would like to allow staff to access any of the information in any of the DBs from a menu. Not sure if switchboard can do this or not and if not is there some other method that will accomplish the same thing.

Again, thank for the help.

Bill

 

[ghudson]

Search the forum for it sounds like you need to use the AppActivate method. I have posted code on how to use it in a few threads floating around here somewhere.

 

[wricoasolutions]

Searched and Found

I have done a search and found some code (yours and others) and it has been helpful, problem is I am not a VB programmer so not sure why the code that I tried does not work. Will check the VB manual and see what I can find.

Thanks for the help, the search worked great.

Bill