Linking to SQL Server 2000 back end

[Jill50]

I am trying to convert the back end of an existing Access 2000 split application to SQL Server 2000. Is there any other way to link to the tables other than ODBC?
Thanks in advance for any help!

 

[cmmrfrds]

Access has an upsizing wizard which does a good job of converting the app to sql server. Use the option to make a project and it will create a direct OLE-DB connection.

 

[Jill50]

Thanks. I tried that, but there was so much that did not upsize correctly (like queries based on an input value on a form)that it looked like it would take a lot of work to get the app working properly again.

 

[cmmrfrds]

I didn't run into that problem since I never liked referring to a Form directly in a query. I always use a function to return variables in a query or if the sql is specific to a Form then code the sql directly in the row source of the Form. This made it easy to upsize. I upsized 2 application and both went relatively easy and where done in about a day. I was very pleased at how well the upsizing wizard worked.

You are not going to gain ALL the benefits of using an sql server database without using an Access Project (adp). The project uses an OLE-DB connection to sql server.