Password Required on Open of Linked Access mdb file

Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!
That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:

>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!