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

SQL join query to databases on networked computer?

Status
Not open for further replies.
terrygtx

terrygtx

Programmer
Apr 12, 2008
7
US
Is is possible to use an SQL statement to reference tables in databases residing on other computers?

I am hoping to avoid linking tables - but it may not be possible.

TIA,

t
 
Sort by date Sort by votes
It is possible to use In:

SELECT * From tblTable IN '\\ComputerX\Docs\TT.mdb'
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
385
strongm
strongm
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
4K
Norman Sherlock
Norman Sherlock
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
330
Moss100
Moss100
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
371
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top