Table relationships

G

Guest

I'm maintaining a database (I did not design it) that has three MDB files.
One MDB is a front end, one is a back end and one functions as both back end
and front end. The purpose of this set up is security. One front end is in a
folder with different access permissions to the other front end. The back
ends have separate passwords. My problem is how to define the table
relationships since related tables are in different MDB files. Any ideas on
how to sort out this mess? The users are technically ignorant but are
convinced they need this weird setup.
 
J

Jeff Boyce

You will find that you cannot enforce referential integrity between .mdb
files. You CAN establish relationships AND enforce RI within each, but you
can only, if I recall, relate one table to another (nothing fancy) when
you're working with both "local" and "linked" tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing Relationships 3
Front end/Back end table relationships 4
Relationships, back end 28
where to keep the table relationships in a split database 2
Where to define Relationships - FE or BE? 7
Table Relationships 3
ending a connection between the front and back ends of a split database 4
Relationships: Front end or back end 1

Top