Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

Access to SQL Server: Linking Tables Expand / Collapse
Posted Thursday, February 18, 2010 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 8, 2015 4:49 PM
Points: 2, Visits: 197
I have an Access database that previously had linked tables to Oracle. With our Oracle retirement, these tables have to be relinked to the same tables that have been migrated to SQL Server 2008. A file DSN with SQL Server login and password is provided to users for this purpose (same login and password as Oracle), and works.... once. When they close and reopen Access and try to open a table, they get an ODBC error because they don't have access via Trusted Connection. The sql login and password information evaporates.

If I uncheck Trusted Connection and type in the sql login and password, it works until the next time Access is opened.

How do I get the login information to stick?

Lee Anne

Post #868125
Posted Thursday, February 18, 2010 10:59 AM


Group: General Forum Members
Last Login: Monday, November 2, 2015 9:50 AM
Points: 162, Visits: 465
Welcome to the world of Access clients that use SQL Server back-ends.

While I did not transfer my Access 2003 (run time) application from Oracle to SQL.
I did recentlly update it from SQL 2005 to SQL 2008

This is one of a few posts.
The ODBC did require some tweaks since there is a client update from 2005 to 2008 SQL.
Also, during my conversion, it appeard (but I can't prove it) that MS pushed out a change that added some compatibility.

Bottom line - most ODBC solutions for Access are on the site above.
This, however is the best site for SQL Server.
Post #868293
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse