Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saltzmanjoelh
Starting Member
10 Posts |
 Posted - 2007-12-12 : 00:26:00
|
| I have SQL Server running on a network and ACCESS db looks at it for the data. I have a computer in a remote office and I want to update my ACCESS db to look at that remote server. What do I need for it? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-12 : 02:00:23
|
| Connect Access DB to SQL Server using File, Get External Data option in Access.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
saltzmanjoelh
Starting Member
10 Posts |
Posted - 2007-12-12 : 12:35:56
|
| I must not be explaining myself well enough....I want to link to table sources that are stored in SQL. To connect to the SQL table I need the ODBC setup. I cannot connect to the SQL Server via ODBC when I am not on the LAN. How do I connect via ODBC to my SQL Server when I am in a remote office? |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-12-12 : 12:48:03
|
| You'll have to set up an odbc connection to your SQL server and use it for Access. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 23:43:43
|
| >> How do I connect via ODBC to my SQL Server when I am in a remote office?Any network connection between two offices? |
|
|
|
|
|
|
Remote SQL Connect