Switchboards

[allison]

I have two locations of a company with slightly different names. They
want to work from the same database (which is fine). However, I was
wondering if I can have two different main switchboards. One for one
location and the other for the other location. that will open the same
database.

 

[MBSNewbie]

Allison,
This is very easy and encouraged, not only for different locations, but
for different departments.
Is your database Complete or a Front-End/Back End?
If it's complete, you can first split it using the built in Access Utility
Tools> Database Utilities > Split Database

It will help to make your database more accessible.
You will store the backend(Data & Queries) in a centralized location and you
can use the front end(Forms) to link to the records.
If you add new tables or queries, you only need to do that once in the back
end, but Forms will need to be added to all of the front ends, I normally
Import them from one to the next and make the personalized changes.

It's pretty easy, make a copy of your database and play around with it, you
will see how great it works!

Let me know if you have any questions!
TK

 

[allison]

Thank you for the quick reply. I do have a question. Please be patient
with me. This is the first database I have ever tried to create and I
am very new at it. So I have this database split and I see the front
end and the back end. I don't have it completely finished yet, so it is
not up and running. Do I have to split again to have the separate
switchboards or can I run them just from the front?

 

[MBSNewbie]

You definitely wouldn't need to split the Front End Again.
(Although you may choose to have multiple copies with slight differences
based on the company)

The more I think about it is that I would Create a Company Table where it
would hold the Valid Company for a given User.
Then Use that information to Filter your Query's and opulate your Titles to
your forms.

I hope this helps.... There are a lot of ways to approach it, just thinking
of the best way to set it up so that you don't have to make multiple changes
down the line.