Form as a switchboard

[Accessme2]

Hi everyone,

I created a database that all it has a Manu that direct the user to their database. So when they click on a button it opens that specific database, then he/she needs to close that application to go to a different application. So all this open and closing application would affect the performance of their computers?. Is any way that once I opened the database with this menu I can go to other application without open access again? I do not want to create a monster database with all the databases that we use in the company?
I do have all programs and tables separated.
I am using Access 2000 pro.

Any suggestions would be appreciated.

Thanks

 

[stormin_norm]

Can you supply some more details-
The users typically open how many of these databases (menu choices) in a given day? Do you they jump between the databases often or do they sit in the same database most of the day?

Could the databases be joined together in one application vs. seperate databases?
Why is there seperate databases?
What is the function of each database (i.e. accounting / hr /??)?

Do you ever pass data between the databases?

 

[Accessme2]

There will be some user that will open only one application and sit on it all day long but there will be some that will jump from 4 all day long i guess it will depend what they do that day. But yes the menu could open acct, Plant, Office aplication, Inventory etc. I just thought I would create a menu so everyone would have and been able to open any application. I haven't put it on yet so it this is a bad idea please let me know.

 

[stormin_norm]

There will be some user that will open only one application and sit on it all day long but there will be some that will jump from 4 all day long i guess it will depend what they do that day. But yes the menu could open acct, Plant, Office aplication, Inventory etc. I just thought I would create a menu so everyone would have and been able to open any application. I haven't put it on yet so it this is a bad idea please let me know.

I guess the easiest is make four shortcuts on their desktop. That would save you coding.

Check out this MS Knowledgebase article
And this MS article if you use passwords