Password question

B

Ben

Hi all,

I have an Access 2002 database. I created a number of queries in it to
query against the database server. However, everytime the code calls the
query, it prompts me to enter the password. My code looks like:

Set rs = db.OpenRecordset("myquery")

Is there a way to embed the password in there so that it doesn't prompt me
or other user for the password? Thanks.

Ben



--
 
S

Smartin

Ben said:
Hi all,

I have an Access 2002 database. I created a number of queries in it to
query against the database server. However, everytime the code calls the
query, it prompts me to enter the password. My code looks like:

Set rs = db.OpenRecordset("myquery")

Is there a way to embed the password in there so that it doesn't prompt me
or other user for the password? Thanks.

Ben
Click to expand...

Try Googling for "remove DSN". I use one such routine at work... I think
I downloaded the code from www.mvps.org but I can't remember for sure.
 
Top