Access Front-End

We have a system which uses an Access front end linked to a SQL 2000 database
If we were to move the SQL database onto a new server then would it just be
a case of editing the ODBC settings on each client to point to the new SQL
server?
Yes as long as the SQL Server end of it is correctly moved
(login, users, etc)
-Sue
On Thu, 21 Jul 2005 08:27:04 -0700, HSP
<HSP@.discussions.microsoft.com> wrote:

>We have a system which uses an Access front end linked to a SQL 2000 database
>If we were to move the SQL database onto a new server then would it just be
>a case of editing the ODBC settings on each client to point to the new SQL
>server?

Access Front-End

We have a system which uses an Access front end linked to a SQL 2000 databas
e
If we were to move the SQL database onto a new server then would it just be
a case of editing the ODBC settings on each client to point to the new SQL
server?Yes as long as the SQL Server end of it is correctly moved
(login, users, etc)
-Sue
On Thu, 21 Jul 2005 08:27:04 -0700, HSP
<HSP@.discussions.microsoft.com> wrote:

>We have a system which uses an Access front end linked to a SQL 2000 databa
se
>If we were to move the SQL database onto a new server then would it just be
>a case of editing the ODBC settings on each client to point to the new SQL
>server?