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.

User comments

Posted by john on 12/17/12 8:26 AM

I have chunk files that never dissappear, just keep multiplying. Why do these continue to remain?

Posted by Jason on 10/17/12 12:00 PM

Hi -- Is it possible for this cache to be stored in an alternate location in Wndows systems? These files filled up space on a test system's C: drive and caused some critical processes to stop due to lack of space. However, there are larger volumes on that machine which could handle these large files. Would installing the Syncrify client to the alternate drive fix it / workaround?

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.

Your name:
Your email:	Hide my email address
Verification code:	Enter the verification code you see above more submitting your tip
Tip:	Please limit tips to 1000 characters