I'm trying to get a front end (access) and backend (SQL Server) working. The issue I'm having is that after using SQL Server 2017 Import and Export data tool and then going back and using Access import and link tool to link the tables, I keep getting Access error stating that the access database engine cannot find the input table or query 'tblname'
I have a lot of code in the access front end that I need to continue to use.
So, the question is what am I missing; or what do I need to do to get the front end working and back end communicating?
thanks,
Jeff