If you're linking through ODBC, have a look at access (DAO) help for the
.Connect property of the .TableDef object.  That prop is supposed to allow
you to concatenate UID and PWD parameters (tho I just tried it a minute ago
w/A2K & a linked ORACLE table & couldn't get it to work in the 60 seconds I
tried).  You might also be able to bake your credentials right into the ODBC
data source.  Of course either of these solutions potentially pose security
concerns...

Hope that helps.

-Roy

-----Original Message-----
From: bmartens@k... [mailto:bmartens@k...]
Sent: Friday, May 25, 2001 2:49 PM
To: professional vb
Subject: [pro_vb] username/password problem with query


Howdy folks,

Don't know if anyone can help on this one, but here we go.  I am using VB 
w/Access 97 as a database.  Access has a table that is linked to a table 
from a third party software vendor.  I doubt if anyone has any experience 
with this product, but the name is Fourth Shift and the database it is 
based on is called Titanium.  Anyway, if I run a query against the Access 
db (which is linked to the table Item_ReferenceData) I will receive a 
dialog asking for the Fourth Shift username/password so I can access the 
table.  My question is can anyone think of a way where I can avoid this 
dialog coming up to the end user.  How do I pass a parameter or something 
when I run the query so the authentication needed on the Fourth Shift 
table is invisible to the user?

Thanks in advance!
Bri