Linking via ODBC?

[chuckles1066]

Someone remind me (I used to know this stuff years ago) - if I link to a database via Access via ODBC........the relationships I create in Access don't affect the relationships in the real-world database, do they?

(I suspect the real-world database relationships aren't entirely right seeing as some of the data extracts are suspect - I'm looking to establish whether they are or not).

TIA.

 

[boblarson]

Referential Integrity in Access can ONLY be applied to Tables that exist in Access and are not linked. If you have a backend with just Access tables then you would set the relationships and referential integrity checkbox in the backend. It would have no effect setting it in the frontend.

 

[chuckles1066]

Thanks Bob, much appreciated.