Access 97 upsize to SQL 2K

[Ron Hinds]

OK - someone here gave me a suggestion on using the (newer) upsizing wizard
to do this. I thought I had saved that post but now I can't seem to find it.
So if anyone knows: 1) Where can I find the version of the Wizard that works
with SQL 7; and 2) What is the modification I need to make to the code so it
works with SQL 2K. TIA!

 

[david epsom dot com dot au]

We use the Access 97 upsize wizard, which doesn't do nVarChar.
http://www.microsoft.com/downloads/...07-7c5f-46cb-9157-a1ec4e96083d&displaylang=en

If you use the later wizards, you will have to convert the
nVarChar to VarChar, because A97 doesn't do Unicode.

There may be a version of the (newer) wizard that you can
modify to not use nVarChar: I've never seen it.

If you use the A97 wizard, it crashes when SQL Server 2000
returns the version number. Just run it till it crashes, then
modify the code there so that the version number doesn't crash
the upsize wizard.

Or you can start from SQL Server DTS, and import the tables,
rather than exporting them from Access.

(david)

 

[Ron Hinds]

Thanks David!

We use the Access 97 upsize wizard, which doesn't do nVarChar.
http://www.microsoft.com/downloads/...07-7c5f-46cb-9157-a1ec4e96083d&displaylang=en

If you use the later wizards, you will have to convert the
nVarChar to VarChar, because A97 doesn't do Unicode.

There may be a version of the (newer) wizard that you can
modify to not use nVarChar: I've never seen it.

If you use the A97 wizard, it crashes when SQL Server 2000
returns the version number. Just run it till it crashes, then
modify the code there so that the version number doesn't crash
the upsize wizard.

Or you can start from SQL Server DTS, and import the tables,
rather than exporting them from Access.

(david)


so