Pass through problems

[RemyS]

Hi All,

I'm new to working with SQL server, and have been having a bit of trouble creating my Pass through query in Access 97.

I've set up the database as an ODBC System DSN
and have successfully been able to open the tables.

However when I create a normal SELECT query to the table I have to manually enter the username and password each time the DB is opened.

So I'm thinking a Passthrough Query, which can store that info in the ODBC Connection String is the way to get around this.

I've set up the ODBC connection part (using the builder), and entered my SQL statement "SELECT * FROM Table_Name;"

but I get an ODBC Call failed Error; "Invalid object name 'Table_Name'. (#208)"


Can any one help?

Thanks in advance,
Remy Hundreds of ways to do things with VB, and learning new ways every day.

 

[AWithers]

Can you not set up the dsn /sql login with windows authentication, this gets round the need to login everytime

just a thought

Andy

 

[RemyS]

That would make life easier,

but the username for the SQL Database is a "dummy" single username which anyone can loggin as, and is therefore different to my NT username, which is what the Windows Authentication uses. Hundreds of ways to do things with VB, and learning new ways every day.