I have an app that works perfectly on a stand-alone computer, interacting with an MS Access database containing two tables.
However, I have been tasked with incorporating this app into an agency-wide SQL Server database. The existing data has been copied into its "new home", but the table names chosen by the DBA produce errors(not recognized) when I write and execute a query.
Any ideas on how to proceed?