Search code examples
sql-serverodbcms-access-2013linked-tables

Linked Access table to ODBC Database doesn't show all columns

I am creating a database in Access 2013.

I need to create a few tables that are linked to a SQL Server that other Access queries will use to get data. No information will be returned to the SQL Server, the tables are for information only.

I tried using a pass-through query to SQL Server, which worked except that I couldn't refresh it, I had to go back to 'SQL View' and click 'Run'. I did some research and found that pass-through queries are not updateable. If someone could prove that wrong I would be glad!!

I then tried to create a linked table to SQL Server, however it only showed 22 columns (all of which happen to be totally useless to me) out of 267 columns (don't worry, I only need about 3 or 4 of those columns).

Is there a way to do this?

Solution

  • Sorry, I don't exactly know why I was getting errors, but I am no longer having problems with this.