Convert User DSN to System DSN

Hi all,
I stupidly setup a database as a userDSN but now want to make it a system
dsn so that I can access it from another machine. I have an access db that
uses msde linked tables for the back end, which is installed locally on 1
machine in the network. I want to be able to add new features to the access
database from another machine and then copy over the improved version to the
other machine. What should I do?
You cannot access a DSN from another machine unless you are using a remote
sofware program, such as Terminal Server, to connect to the machine that
houses the DSN.
Either way, there is no way to make a user DSN a system DSN. You will need
to recreate it using the ODBC Admin applet.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||So how do people connect to a sql server running on another machine? I have
3 machines and 1 server, the server is running SQL Server and I want the 3
machines to have the same access database with linked tables.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:tNMbkd8fEHA.3340@.cpmsftngxa06.phx.gbl...
> You cannot access a DSN from another machine unless you are using a remote
> sofware program, such as Terminal Server, to connect to the machine that
> houses the DSN.
> Either way, there is no way to make a user DSN a system DSN. You will need
> to recreate it using the ODBC Admin applet.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||You create a user DSN on your OWN machine which gives the address (ip number
for example) of the machine running SQL server, to connect to a remote SQL
server.
"Yair Sageev" <geekyheeb-news@.yahoo.com> wrote in message
news:%239P$W%238fEHA.632@.TK2MSFTNGP12.phx.gbl...
> So how do people connect to a sql server running on another machine? I
have[vbcol=seagreen]
> 3 machines and 1 server, the server is running SQL Server and I want the 3
> machines to have the same access database with linked tables.
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:tNMbkd8fEHA.3340@.cpmsftngxa06.phx.gbl...
remote[vbcol=seagreen]
need[vbcol=seagreen]
rights.
>

Convert User DSN to System DSN

Hi all,
I stupidly setup a database as a userDSN but now want to make it a system
dsn so that I can access it from another machine. I have an access db that
uses msde linked tables for the back end, which is installed locally on 1
machine in the network. I want to be able to add new features to the access
database from another machine and then copy over the improved version to the
other machine. What should I do?You cannot access a DSN from another machine unless you are using a remote
sofware program, such as Terminal Server, to connect to the machine that
houses the DSN.
Either way, there is no way to make a user DSN a system DSN. You will need
to recreate it using the ODBC Admin applet.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||So how do people connect to a sql server running on another machine? I have
3 machines and 1 server, the server is running SQL Server and I want the 3
machines to have the same access database with linked tables.
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:tNMbkd8fEHA.3340@.cpmsftngxa06.phx.gbl...
> You cannot access a DSN from another machine unless you are using a remote
> sofware program, such as Terminal Server, to connect to the machine that
> houses the DSN.
> Either way, there is no way to make a user DSN a system DSN. You will need
> to recreate it using the ODBC Admin applet.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||You create a user DSN on your OWN machine which gives the address (ip number
for example) of the machine running SQL server, to connect to a remote SQL
server.
"Yair Sageev" <geekyheeb-news@.yahoo.com> wrote in message
news:%239P$W%238fEHA.632@.TK2MSFTNGP12.phx.gbl...
> So how do people connect to a sql server running on another machine? I
have
> 3 machines and 1 server, the server is running SQL Server and I want the 3
> machines to have the same access database with linked tables.
>
> "Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
> news:tNMbkd8fEHA.3340@.cpmsftngxa06.phx.gbl...
remote[vbcol=seagreen]
need[vbcol=seagreen]
rights.[vbcol=seagreen]
>