Password question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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



--
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 W10 password prob. 2
Setting up query parameter to UNION query by VBA 2
Multiple make table queries in one? 3
DameWare MRC Enter Network Password 1
Insert Record into Oracle Table 1
Query error, too few parameters 0
SQL Server Login requesting password when query is run. 4
Not a valid password error 2

Back
Top