I'm currently working on a project to convert our Access Apps to store the table data in SQL Server.

Using SSMA to migrate the data results in the foreign keys and Look-ups work as expected in Access when completed. However, if I import & link directly from SQL Server back to Access, the foreign key look-ups do not work.

The only difference I can determine in the links is, the ones SSMA created do not specify a DSN and the ones I manually created do.

I'm hopefully someone might have run into this in the past and might have some insight.

We are migrating from Access 2013 to SQL Server 2012.

1 Answer 1


I finally determined the lookups have the be setup in Access, they won't automatically be created when attaching a sql server table as a link.

  • You can accept your answer so that this question can be closed. Nov 26, 2019 at 0:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.