Linking Access with SQL Tables???

[MICHELE]

I was wondering if anyone knew where I could get some help with linking SQL tables with Access. We have a program in SQL that I know very little about but there are is a lot of information in those tables that I could use in my Access db. Is there a good book or website with this information?

 

[IgorB]

In addition I preffer to set database owner password for every local machine(user), then there is no conflict when you generate reports in Access based on SQL Server.
Also I used sql pass through query type to link table or view.
Link table or linked view could be attached manually or even programmatically.

Igor.

 

[MICHELE]

Thank you! I will try these suggestions. It sounds like I can make it work.