|
|
Knowledge Base
Document information| Document ID: | 755 |
|---|
| Subject: | Referential integrity constraints in MS Access |
|---|
| Creation date: | 7/29/09 11:40 AM |
|---|
| Last modified on: | 7/29/09 11:40 AM |
|---|
Details
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 as 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 affect on the database.
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.
|
