SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Access to SQL Server: Linking Tables


Access to SQL Server: Linking Tables

Author
Message
leeanne.pedersen
leeanne.pedersen
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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?

Thanks,
Lee Anne



Mile Higher Than Sea Level
Mile Higher Than Sea Level
Old Hand
Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)Old Hand (358 reputation)

Group: General Forum Members
Points: 358 Visits: 465
http://www.access-programmers.co.uk/forums/showthread.php?t=182076
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search