I have inherited a database that has worked fine until now. I have had to change the links to some tables as they have been moved to a new server. The links work fine but the old links had the 'sa' UID inbuilt whereas the now the user has to enter a password all the time.
Here are the properties from the table design view for both. How can I get the new link to have the same inbuilt parms please ?
Old - ODBC;Description=Winscribe-01;DRIVER=SQL Server;SERVER=Winscribe-01;UID=sa;APP=Microsoft® Access;WSID=8C19F0J;DATABASE=WinScribe;TABLE=dbo.j ob
New - ODBC;Description=winscribe-01;DRIVER=SQL Server;SERVER=LON-WINSCRIBE;APP=Microsoft® Access;WSID=8C19F0J;DATABASE=WinScribe;TABLE=dbo.j ob
my problem was the I forget to tick the save password
had to drop the table and relink them and tick the password
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.