Table relationships

M

mscertified

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

Combining three files when middle file has sections with endnotes 2
Missing Relationships 3
Front end/Back end table relationships 4
Linking Multiple Front-end Database Files 3
ending a connection between the front and back ends of a split database 4
Where to define Relationships - FE or BE? 7
Linked Table Relationship Not Visible in Front End 1
Relationships, back end 14

Top