[AccessD] A97 to SQL2000

Griffiths, Richard R.Griffiths at bury.gov.uk
Fri Sep 16 06:33:45 CDT 2005


Hi Group

I have been given the task of moving A97 tables to SQL2000.  The app was
written by a user and so has little vba code (recordset processing etc).

Is it as simple as importing data to SQL and setting up an ODBC DSN then
reattaching the tables. I have tested on one or two tables and this
appears to work okay.

Are there known problems with this approach?

Richard



More information about the AccessD mailing list