MS Access Reading from ODBC Connection

[fadilrexhepi]

Hi,

I am in need of consultation for MS Access reading data from ODBC connection. I have SQL Server that has all the data for the project financials etc.
I need a database that will read only certain data from the tables, for example, I don't need to import all 500,000 lines from SQL through ODBC connection, I just want to bring certain data for a list of projects whichever are opened and load only that data in MS Access so the group then can add additional details for that project in a shared MS Access.

Please advise if this is possible to do

Right now, all I can do is connect to that database through ODBC and brings all the data which I don't need all as it increases the size of the database, but just a criteria to specify which data to bring, if that's possible to do

Best regards,
Fadil

 

[richsql]

It sounds like you are using linked tables to your SQL Server db , why not use a pass-through query filtering your queries as necessary ?