July 31, 2008 at 8:17 am
Hi, I'm in need of help.
I have a database that I can successfully connect to (Server 2k5 Express) using SQL Authentication Mode. The problem I'm having is that every time a query executes, it is prompting for a password. Is there a way around this? Ideally I'd like to have it prompt for a password once at startup, store it for the life of the program.
Some background, DB created in Access, backend was upsized to SQL Server 2005. Front end is running in Access runtime mode.
thanks in advance
August 1, 2008 at 3:33 pm
I believe Access has the ability to cache the password. However, this would mean anyone with the ability to start up the Access front end would be able to execute the query. Do you have the option of configuring it so it uses Windows authentication and having your credentials with the proper access to the back-end SQL Server?
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply