By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Managing table Links from MDB To SQL 2000

P: n/a
Access 2000 (mdb / mde) Frt End to SQL 2000 Backend

I have an Access app that is linked to SQL 2000 using the DSN-Less
method.
I have 3 sql servers (3 different locations) that contain the exact
same database (achieved through replication) When the user moves to a
different office, they need to connect to the sql server located in
that office for speed issues. I am trying to create a user interface
to allow the user to connect to different sql servers as they move
between offices. Keep in mind that it has to be "end user friendly for
those who do not think that "computers are our friends".

I would like to store the sql server connection info in a local table
and basiclly allow the user to select which server they would like to
connect to from a form with a combo or listbox.
I need for it to perform as follows during startup.

1 - ck for connection to the sql server, if found then refresh the
links.(this would be the last server it was connected to)

2 - If the sql server is not found, then display msg "server not
found", display a form to allow the user to select (via a combo or
listbox) from 3 different sql servers.

3 - then establish the links to ALL tables within the specified
database.

All of this with basiclly a single click.

Now that's not asking too much, is it?

As Always Any and ALL help is truely appreciated!
Dale

Aug 31 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.