CODEWITHSUNDEEP
sqlsql-serverms-accessodbcreferential-integrity
Batman
Batman

Reputation: 6353

Access ODBC not importing referential integrity

I imported using ODBC tables into access from SQL server but the tables lose all PK and FK integrity. My PKs are no longer required when i got to design view in access?

Upvotes: 0

Views: 211

Answers (1)

J.Hudler
J.Hudler

Reputation: 1258

Importing your table schema + data won't fully transfer your database.

Remember that Indexes, FK Constraints, Stored Procedures and so on are independent objects such as Tables. These objects' definitions should be translated between the two databases when you are willing to do such migration.

Upvotes: 1

Related Questions