If you are moving your tables to SQL, then you can use the upsizing wizard.
OR
If you want to do this manually, use the DTS in SQL to grab the tables from your Access back end. The DTS will rename them something like "dbo_tblYourOldTableName" where it had been "tblYourOldTableName". You can rename them in SQL, or rename them in Access later, back to your old table names.
Then, create an ODBC to the new SQL back end.
Then go to your existing Access front end, delete the tables that were pointing to Access tables, and go to Insert>Tables>Link Tables>ODBC Data Source to link the front end to the SQL dbms.
After you have linked the SQL tables, rename them to the old table names you were using with Access if you didn't do this in SQL. This should work.
A problem may arise in some forms where you can't update the tables properly, so you may have to re-create them.
Anyway, this is a kludge in case you can't get the wizard to work. I am sure some of the other posters can give you more elegant solutions.
mmcdonal
|
