Access to SQL Server

[Syd]

What the best known way of converting Access 97
applications to SQL Server? I've heard that the upsizing
wizard is not the best method. Is this true? If it is or
is not, what is the the recommended best way with the
least head aches of doing the this SQL Server
upgrade/conversion?

Thanks,.....

 

[david epsom dot com dot au]

What the best known way of converting Access 97

applications to SQL Server? I've heard that the upsizing
wizard is not the best method. Is this true? If it is or

The Access 97 upsizing wizard can't connect to SQL
Server 2000.

The (patched) Access 2000 upsizing wizard tries to
convert text to UniCode, which A97 doesn't understand.

One solution is to use DTS from the Server. If you are
a SQL Sever guy, this method is probably best.

The other solution is to find an unsecured sample copy
of the A97 wizards, and modify the A97 wizard so that
it doesn't crash when the server reports it's version
number. If you are an Access/VBA guy, this method is
probably best.

If you are just an ordinary guy... It's probably best
to convert your Apps to A2K+ before doing the SQL
Server conversion.

If you haven't done this before, you should at least
look at the upsizing tool from SSW:
http://www.ssw.com.au/ssw/UpsizingPRO/

(david)