| Author |
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.
| |
| Dave Patrick 2006-12-12, 12:12 am |
| 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:[color=darkred
]
> 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:
| |
| Dave Patrick 2006-12-12, 12:12 am |
| 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
|
|
|
|