Access links

Topic

New Reply

Question from my boss: “if a relationship is set up between two linked SQL tables in Access, does the link affect the native database or does it only exist in the Access ‘front end’?” Does this make any sense to anyone???

Reply | Quote

Replies

If the link is established in the front end database, it is stored in the front end database.
If you want to establish referential integrity to your database you should set up the link in the back end database and not in the front end database.

Bart Stam
Software designer

Reply | Quote