Creating Different Front-End databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

reburg67 - 21 Apr 2008 16:20 GMT

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?

Reply to this Message

tedmi - 21 Apr 2008 17:23 GMT

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.

Signature

TedMi

Reply to this Message

reburg67 - 21 Apr 2008 17:57 GMT

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!

> 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.

Reply to this Message