We have a database application that was created in MS Access. We are wanting to upgrade to using MS SQL Server. We have imported the data from the Access mdb file into a new SQL table, created the ODBC SQL objects to link to, Linked the Access Application to the SQL tables, and pointed the queries, forms, and reports to the SQL tables. BUT the data in the SQL tables are not being displayed in the Access queries, forms, or reports. I have checked the macros and VBA code, but have found no readily visible problems. Any suggestions? Anything I could have forgotten to check for links?
