connection string q anthony

Forum home » Delegate support and help forum » Microsoft Access Training and help » Connection String Q for Anthony

Connection String Q for Anthony

resolvedResolved · Medium Priority · Version 2007

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

Fri 3 Feb 2012: Automatically marked as resolved.


 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.05 secs.