password protected database

[KAKAC]

I am accessing 3 data in a database to which I have access. I have created access database to pull data from this database and I have to key same password three times. How can I minimize this password request to only one time.

I appreciate any help.

 

[Andrew Fergus]

Hi
I'm not sure if this will help but you could have a read of this MS article.
HTH, Andrew.