I am new to SQL server but relatively experience in MS Access. I have a back end ms access database with 137Mbytes of data and was to transfer this to SQL server. I am finding it difficult to do so. The latest error is saying a network related or instance-specific error has occurred while establishing a connection to SQL server. Server is not found or not accessible etc. The connections which i am trying to make are on the same computer.
You have provided very little detail but here are Microsoft's migration notes:
Migrate an Access database to SQL Server - Microsoft Support
1 Like