I have a database that I am migrating from 2002 to 2010 Access. The Access project uses a sql database.
From the database window I try to use the transfertext buttons from the menus to export a table to a file. I actually have code in visual basic to do the same thing and neither works. When I do the transfer text I get an error that says:
[Microsoft][ODBC SQL Server][DBNETLIB]ConnectionOpen(Connect())
SQL Server Error 17
[Microsoft][ODBC SQL Server][DBNETLIB]SQL Server does not exist or access denied
The project opens fine with the connection I have provided and I can see all of the tables and queries in the database window but cannot export any of the tables.