ODBC error on very large linked table in Access
Posted on 2012-04-11
I think I know the answer to this but need confirmation. Access is used as a front end for a large database on a server. All the tables are linked and reports are run against the data. One table opens with #Name? in all fields and ODBC error message. However, the ODBC connection is the same as the other tables which show up with no problem. I believe it is because the table is so large that Access can't open it. We have made several smaller Access databases that link only to this one table and created local tables with only one year's worth of data in each one. The total of all the years data is several gigs. Is this why we can get the data through queries and reports but not see the data in the table? We can see the field headings in the table, however.