By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,665 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

sql password with access query

P: n/a
Greetings,
I have an application in which I update a sql database from access
append query via linked tables. I use an ODBC connection with sql
authentication. I would like to hard code the sa password so the users
would not have to enter it each time the query runs.

Any help would be appreciated
Dec 8 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can put the password in the connection string:

Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=myPa ssword;

This connection string was copied directly from
http://www.connectionstrings.com, a great resource for obtaining the
correct syntax of connection strings used with a whole bunch of
different database formats.

Dec 8 '05 #2

P: n/a
Br
Matt wrote:
Greetings,
I have an application in which I update a sql database from access
append query via linked tables. I use an ODBC connection with sql
authentication. I would like to hard code the sa password so the users
would not have to enter it each time the query runs.

Any help would be appreciated


<sarcasm>Your SQL administrator must really love you</sarcasm> :)

Why hard code the SA user/password? Why not take a few seconds to create
a new user with more limited permissions and use that?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Dec 8 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.