how to find the source of a sql pass through query

[OwenOC]

Hi there

I am after getting an access 2003 database to look after and it contains SQL pass through query's. The database is a front end to a MS SQL server database with a connection string that is contained in a module.

I believe the SQL pass through queries are connecting to the same database as the rest of the application and somehow is using the connection string in the module. However I cannot find how that is configured on the SQL pass through queries.

Most documentation on the net seems to point at using ODBC to connect slq pass through queries to outside databases but I don't think this is the case. There are not Odbc sources set up for the database I am look at.

thanks

 

[pbaldy]

In the properties of the query you should see a connection string.

 

[OwenOC]

In the properties of the query you should see a connection string.

Hi pbaldy

I looked there before I posed and rechecked again and no it is not there. This is access 2003 btw.

thanks

 

[pbaldy]

I don't have a VM handy with 2003 on it. You're not seeing the property, or it's there but there's nothing in it? Sometimes you don't get the right property window when looking at queries. In 2007 the property is called "ODBC Connect Str". It was the same or similar before.

 

[OwenOC]

I don't have a VM handy with 2003 on it. You're not seeing the property, or it's there but there's nothing in it? Sometimes you don't get the right property window when looking at queries. In 2007 the property is called "ODBC Connect Str". It was the same or similar before.

Hi pbaldy

I see the properties but is does not mention ODBC

the items on the properties are

type
description
created
modified
owner
attributes

nothing about how the query connects to a database.

I though it might be dynamically changed by code but it is not.
The query can be ran from the query design window and runs perfect. I can see the sql in it call the sql server database select * from dbo.tablename

 

[pbaldy]

You're not seeing the right properties window. Hang on, I'll find a VM with an older version on it.

 

[pbaldy]

Okay, in 2000 if you open the query in design view and then click on the properties icon in the toolbar, you should get the right window. You should be seeing the attached.

 

[OwenOC]

Okay, in 2000 if you open the query in design view and then click on the properties icon in the toolbar, you should get the right window. You should be seeing the attached.

Hi pbaldy

I was right clicking on the query before I opened it using design view and looking at the properties. I can see in you gif that you are going design view and then right clicking and viewing properties.

thanks a million for that I am on the right track now. First post on this forum and I got great help thanks a million pbaldy, you the man.

 

[pbaldy]

Happy to help and welcome to the site by the way!