Access 97 Migration to SQL server problems

[Solomons]

I'm planning on migrating an Access 97 DB to SQL Server 2000 but the front end will remain as Access 97.
What I want to know is do I have to convert the queries in the RowSource property of the forms and reports to stored proc, or views or will they work as normal queries as they are right now?
These queries do have IIF in them which I know is not supported by SQL.

Thanx a lot in advance

 

[wemeier]

You should not have to convert the queries, although doing so will improve performance. If you link the SQL Server tables to your Access application using ODBC, you should still be able to use the IIF command in your queries.

 

[Solomons]

Thanks a lot