jaryszek - Wednesday, December 13, 2017 6:57 AMHi Guys,I moved Access back-end (split database with FE and BE in Access) into MS SQL Server database using Sql server migration assistant.
In ms access i have now linked table:
Problem is that my tables do not have relationships in MS Access FE after migration.
Question is how to create these relationships in MS SQL Server?
Or maybe these relationships are already in MS SQL Server migrated?Please help,
Jacek
The tables exist in SQL Server so that is where you would look for the relationships. You'll need to check the SQL Server instances to see f they are there.
If needed, you can find information on creating relationships for SQL Server in the following documentation:
Create Foreign Key Relationships
Sue