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...
> > 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.
> >
>
>