Creating Different Front-End databases

[reburg67]

I split my database (using 2007) and then made a copy of my front end as I
need to have different switchboards with different options for two different
types of users...but when I make changes to one, it makes changes to the
other. How can I make two different front end databases that use the same
back end?

 

[tedmi]

Sounds like your switchboard forms are in the back end instead of the front.
Reminds me of a near-disaster caused by a user of a split db. Wanting a tool
for experimenting against dummy data, she copied the front end then emptied
out the tables - without realizing that the tables were not in the copy, but
in the back end. Thankfully, the backup was only a couple of days old, and
input documents were still available.

 

[reburg67]

Thanks. I did notice that my switchboard table was in the BE and I changed
that and set up new switchboards in each FE database and removed the linked
table. It has been quite a while since I have been working in Access and
can't always remember how to do things.

Thanks!