2 sql servers with Access Front-end

[Giovanni]

Hello,

I have an sql server 2000 on the network and one installed locally in
my computer. I use access as front-end.
I go through odbc to connect to the sql server on the network.
I was wondering if it is possible to setup the access file to link to
either server.
I need to do this because I would like to use the local server as test
environment. I know I could achieve that by creating 2 users on my XP
client and having odbc liking depending of the users.
Is any other way to do that without login and logoff everytime I want
to use a different database.
thanks,

Giovanni

[Simon Hayes]

"Giovanni" <jj****@hotmail.com> wrote in message
news:e9**************************@posting.google.c om...

Hello,

I have an sql server 2000 on the network and one installed locally in
my computer. I use access as front-end.
I go through odbc to connect to the sql server on the network.
I was wondering if it is possible to setup the access file to link to
either server.
I need to do this because I would like to use the local server as test
environment. I know I could achieve that by creating 2 users on my XP
client and having odbc liking depending of the users.
Is any other way to do that without login and logoff everytime I want
to use a different database.
thanks,

Giovanni

I guess you could create multiple DSNs, then choose the one you want when
you run your application, but I have no idea how you would do that - if you
post in an Access newsgroup, you might get a more detailed answer.

Simon