Opening Various Databases using Switch Board 2

[khwaja]

I am usually reliant on the pre existing functionality of Access 97 which works fine most of the time. Occasionally, I have to customise these to my needs and that is where I tend to seek help from this august gathering of users. Keep up the good work.

Is it possible to open various databases using a switch board style menu in a database? Switch board created by Access does not offer any help except to open objects within the database it exists. But I would love to see users opening various different databse based on a menu presented to them.

Regards

 

[khwaja]

I need some help with this from brilliant minds we have out there?

Cheers

 

[danvlas]

You can use Shell (with the appropriate changes):

Shell "C:\Program Files\Microsoft Office\Office\Msaccess.exe C:\Path\File.mdb"


Regards,

Dan

 

[WildHare]

Khwaja - this process does have some drawbacks, but given the appropriate security measures, and tightly controlled user access 'n' things like that, it CAN work.

Create a MASTER database. LINK all the tables from the OTHER databases you need into it.

Import all the FORMS, REPORTS, QUERIES, MACROS, MODULES and so forth you need. Hopefully there will be no name duplications.

Give users <THIS> database file.

I know it sounds a bit klunky, but it works, within reason, and you don't need to worry about having to open 47 instances of Access, which can put a severe strain on the Elmer's glue holding everything together...

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[RiverGuy]

So VBA does let you use Shell? I never knew that. However, if you have VB6, I would think about making an interface screen with a standalone .exe. That way, you would not have to duplicate the same switchboard in 3 databases or leave 1 open all the time to get the switchboard.