Using the Upsize Wizard

[Don]

Hello, I'm converting an Access 97 database to SQL Server 2000. When I take
run it though the Upsize Wizard I get a overflow message. Researching it on
Microsoft site, they seem to tell you not to use the wizard and use the DTS
package from SQL Server. Is this correct? I thought you should use the
upsize wizard because it keeps info like indexes, etc...

Thanks

Don

 

[david epsom dot com dot au]

The Access 97 wizard crashes with an overflow message
on some trivial bit of code that you can fix in moments
if you have the MDB version of the wizard (note: mdb
versions are typically given the extension .mde just to
keep them consistent with the mde version).

First check to see if you have a source version of
the wizard (I don't remember if that was the standard
distribution). If not, search the MS site to see if
you can find one.

The A2K wizard can also be used: you have to change
all the nVChar fields back to VChar if you are going
to link from A97.

Also, I can't remember which wizard enabled cascading
updates/deletes.

Also, I've always wondered what would happen if you
enabled a version 7 instance of SQL Server....

Also note that Access 2K/Jet 4 enables you to update
identity fields in SQL 2000 as you would in an MDB.
That is rather more difficult when using A97.

(david)

 

[lh]

thank you!

The Access 97 wizard crashes with an overflow message
on some trivial bit of code that you can fix in moments
if you have the MDB version of the wizard (note: mdb
versions are typically given the extension .mde just to
keep them consistent with the mde version).

First check to see if you have a source version of
the wizard (I don't remember if that was the standard
distribution). If not, search the MS site to see if
you can find one.

The A2K wizard can also be used: you have to change
all the nVChar fields back to VChar if you are going
to link from A97.

Also, I can't remember which wizard enabled cascading
updates/deletes.

Also, I've always wondered what would happen if you
enabled a version 7 instance of SQL Server....

Also note that Access 2K/Jet 4 enables you to update
identity fields in SQL 2000 as you would in an MDB.
That is rather more difficult when using A97.

(david)


it

 

[¹Ú¹®¼ö]

thank you!