James has attended:
Access Intermediate course
Access Advanced course
Connection String Q for Anthony
How to connect Access database to third party databases hosted on our SQL servers direct using ODBC link
RE: Connection String Q for Anthony
Hi James, thanks for your query. You need to create a pass-through query and there's a useful walkthrough here:
http://www.about-access-databases.com/pass-through-query.html
Hope this helps,
Anthony