Tom Collins has some tips to make an Access to SQL Server migration more successful:
-Access has a size limit of 2 GB
-Access has a concurrent users limit of 255 users
-Require increased capacity
The SQL Server Migration Assistant for Access (SSMA) is a very useful tool offered by Microsoft .
The main objective of these notes is to supplement the Microsoft documentation and to assist in Access to SQL Server journey.
Read on for those notes.