reference connection string in SQL statement?

[jrhaze]

I'm trying to use a SQL string to set the recordsource of a report. I am using an Access front end and a SQL Server backend.

I don't have any linked tables, so I need to reference the connection string right in the SQL string somehow . . . is this possible?

If not how can I set the recordsource of a report when I don't have any linked tables? Other than using query objects . . .

Thanks in advance . . .

[pclement]

You will need to specify the (ODBC) connection in your SQL statement. Below is an example:

SELECT * FROM [Orders] IN '' [ODBC;Driver={SQL Server};Server=(local);Database=Northwind;Trusted_Connection=yes]

The above connection string uses integrated security. The link below has other examples:

http://www.carlprothman.net/Default....erForSQLServer