Advanced Beginner
Windows 11 
Access 2021
Have you migrated access tables to sql server while leaving the front end on access? I think I have done it once some time ago but am having trouble. I get a connection error message in SSMA that it can't connect to sql server. I may have a firewall issue. Any idea on how to resolve this? Thanks.
VIP
Windows 10 Office 365
Can you connect to the SQL server using the windows ODBC creation utility?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
VIP
Windows 10 Access 2016
Maybe these tips can help you:
https://www.mssqltips.com/sqlservert...server-errors/
Advanced Beginner
Windows 11 Access 2021
Thank you. I tried to use that but I am still having the error. Any other idea what I could try? Thanks.
VIP
Windows 10 Access 2016
Which of the steps (1 -> 10) in the SQL tips failed?
VIP
Windows 10 Office 365
What is the exact error message, and at what point is it generated?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Advanced Beginner
Windows 11 Access 2021
Thank you for your help. I had tried the steps but was getting a different error message. I noticed the error message was about the Trust Certificate and when I then clicked the option to Trust the certificate it worked. Now that it seems to have migrated, I am trying to link the tables from access.
Access To SQL Server Migration
Posting Permissions
Reply With Quote