MS-Access problem changing servers

I think you might need to change the table information.

The easiest way is to go to you tables and delete them all. Then add them all back using the new ODBC information.

It should not mess anything up, I think? You might want to create a copy of your database to test this first.

Jasper

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joanne Yargeau
Sent: Wednesday, October 29, 2008 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MS-Access problem changing servers


We are on Vantage 5.1 and currently on Windows 2000 server. We want to
go to server 2003. We have changed the port in the control panel for
the ODBC drivers. When we try and run an existing access program using
ODBC drivers, we still get the old port, but if we try and create a new
access program with ODBC drivers we get the new port. Where else do we
have to change this to have existing access programs correctly run on
the new server? Thanks in advance for any help.



[Non-text portions of this message have been removed]
We are on Vantage 5.1 and currently on Windows 2000 server. We want to
go to server 2003. We have changed the port in the control panel for
the ODBC drivers. When we try and run an existing access program using
ODBC drivers, we still get the old port, but if we try and create a new
access program with ODBC drivers we get the new port. Where else do we
have to change this to have existing access programs correctly run on
the new server? Thanks in advance for any help.