Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Login Problem from Access

Status
Not open for further replies.
rap43

rap43

Programmer
Apr 21, 2003
13
US
We switched SQL servers and now instead of Fileserver1 that I have to log into (via ODBC connection to SQL tables in SQL Server 6.5), I have to log on to Fileserver2.

The trouble is that when I attempt to access a SQL server table within Access it times out (I hate waiting) then I'm given the option to change the logon prompt to point to Fileserer2 with the correct username and password. It tries to automatically use Fileserver1 as the Server Name. I want it to use Fileserver 2 automatically.

How do I tell Access this?
 
Sort by date Sort by votes
Never mind, I just figured it out!

All I had to do was go to the linked table manager and define my links again.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
234
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
151
Xavierparkash
Xavierparkash
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
276
TomSalvato
TomSalvato
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
280
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top