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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access queries point to new 2000 SQL server

Status
Not open for further replies.
DrewConn

DrewConn

Programmer
Jan 8, 2002
167
0
0
US
I have ported over several DB's from a SQL 7.0 machine onto SQL 2000 server. The users have seveal Access DB's that have been pointing to the data on the 7.0 server.

How can I point the existing queries in Access to point to the same data that now resides on the 2000 server without having to recreate the queries all over again.

Thanks in advance.
 
Sort by date Sort by votes
When you create your links to the SQL 2000 tables, rename the to what they were under SQL 7
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
202
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
166
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
274
Chris Miller
Chris Miller
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
182
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top