Frans_Truyens
asked on
Connect MS Access ADP to MS SQL Server 2005 with Citrix
I have a MS Access ADP, and have connected it to a MS SQL Server 2005 database.
Every time the user restarts MS Access he needs to reconnect to MS SQL Server.
Can this connection process not be automated? So that every time the connection info is stored?
Every time the user restarts MS Access he needs to reconnect to MS SQL Server.
Can this connection process not be automated? So that every time the connection info is stored?
What kind of autentification are you using? Windows or integrated?
Here are examples of connection strings:
http://www.connectionstrings.com/sql-server-2005
Here are examples of connection strings:
http://www.connectionstrings.com/sql-server-2005
ASKER
We are using SQL Server logins. We are using the sa account with a password. We aren't using connectionstrings at all.
Connection string is used, but it is hidden in connection master. You can see all parameters in All Tab.
Description of parameters is here:
http://www.connectionstrings.com/Articles/Show/all-sql-server-connection-string-keywords
Description of parameters is here:
http://www.connectionstrings.com/Articles/Show/all-sql-server-connection-string-keywords
ASKER
The connection string is OK. But I always have to re-save it. Then it works. But every time I have to click on that option again.
Hi,
in an ADP you have server properties where you enter the connection information to the SQL server. In this dialog you will find a checkbox for "allow saving password", if you check this and click "OK" the connection information will be saved permanently (you will again get a warning that the password is not encrypted and so on but only once).
But you should NEVER EVER use the "sa" account to be saved in a frontend! This is the absolute highest security level which can perform ANY operation on the SQL Server so this one should ONLY be used for administration purposes on SQL Server directly. If you want to get all needed rights to the frontend, create a new SQL Server user and give him the right "dbo" for database owner, that's more than enough for developing the frontend. If you deploy your database later to the users, change it again to a user which only has read or read and write rights on the database (depending on what the frontend should be able to do on the database).
Cheers,
Christian
in an ADP you have server properties where you enter the connection information to the SQL server. In this dialog you will find a checkbox for "allow saving password", if you check this and click "OK" the connection information will be saved permanently (you will again get a warning that the password is not encrypted and so on but only once).
But you should NEVER EVER use the "sa" account to be saved in a frontend! This is the absolute highest security level which can perform ANY operation on the SQL Server so this one should ONLY be used for administration purposes on SQL Server directly. If you want to get all needed rights to the frontend, create a new SQL Server user and give him the right "dbo" for database owner, that's more than enough for developing the frontend. If you deploy your database later to the users, change it again to a user which only has read or read and write rights on the database (depending on what the frontend should be able to do on the database).
Cheers,
Christian
ASKER
That is the problem. It does not save the password. Everytime you restart the ADP via Citrix, you have to save the password again. It is more a CITRIX problem than a MS Access problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
ErrorMessage.docx