Hi,
I have used SSMA to migrate my tables to a SQL Server. All table relations were also migrated correctly.
However, after migrating there followinmg tables in Access Fron End:
- Linked tables to SQL Server
- Local tables called "SSMA...$Local"
I have tried to understand what the local tables do. I have not find any reason to have them. I removed them but I got questions that some tables where connected to other tables through relations. All my relations were already migrated to SQL Server so I forced to delete the local tables. It seems to work as it should. Anyone know what the local tables do? Do I need them?
\Joakim