Sample Header Ad - 728x90

Access Data stored in SQL Server

0 votes
1 answer
146 views
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.*
Asked by Bryan Smith (137 rep)
Jun 11, 2015, 03:24 PM
Last activity: Nov 25, 2019, 10:03 PM