Revolving around the core of technology
| Document ID: | 755 |
|---|---|
| Subject: | Referential integrity constraints in MS Access |
| Creation date: | 7/29/09 11:40 AM |
| Last modified on: | 12/12/18 10:52 AM |
Referential integrity constraints, also known as foreign key relationships, are supported natively by Microsoft Access. However, this information is not exposed by the ODBC driver. Therefore, any client (including WinSQL) cannot determine the relationships among Access tables.
As an alternative, you can use the local relationship feature in WinSQL to create relationships among tables. Local relationships are local to WinSQL and does not have any effect on the database.
Posted by moha on 12/15/15 7:54 AM
Do you have a helpful tip related to this document that you'd like to share with other users?