How do i get rid of a SQL Server login-prompt.

I've got an access 2k2 front-end with a SQL Server express 2005 table
holding all the data.
I've got SQL Server authentication on.
Everytime i open the front-end i have to use my SQL Server
username/login I previously set-up.
I have been told to take out the prompt but cant seem to track down the
solution to this.
Security is not an issue.If you must use SQL server login then use the save password function when
you create the linked tables in Access.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" <p.macrae@.gmail.com> wrote:
> I've got an access 2k2 front-end with a SQL Server express 2005 table
> holding all the data.
> I've got SQL Server authentication on.
> Everytime i open the front-end i have to use my SQL Server
> username/login I previously set-up.
> I have been told to take out the prompt but cant seem to track down the
> solution to this.
> Security is not an issue.
>|||damn that was easy thanks
Dave Patrick wrote:[vbcol=seagreen]
> If you must use SQL server login then use the save password function when
> you create the linked tables in Access.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "p" <p.macrae@.gmail.com> wrote:|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"p" wrote:
> damn that was easy thanks