Upsizing Access to SQL Server 7.0

[scottr]

This is more of a general question. I want to port an Access DB over to SQL server. Has anyone every done this before and if so could you recommend some upsizing tools and enlighten me about any problems that you might have encountered. Im aware that all the DAO code will have to be changed to reflect ADO(fun fun).

Thanks

Scott

[JHausmann]

Use the wizard that ships with SQL server to do the work. It's fast and, relatively, painless.

With regard to ADO, you could always code directly to ODBC... :)

[scottr]

Wouldnt the code work better if it was ADO?

[JHausmann]

Depends. ADO is, essentially, using ODBC.