Hi!

Is it necessary to modify SQL code when changing to SQL Server from Access? I'm not using stored procedures but sql is in program code.

Thanks

Almost certainly. Access doesn't use quite the same SQL dialect, and allows all sorts of strange functions. The best bet is to take all the hard-coded SQL and run it against the SQLServer database via query analyser. Much easier to spot the errors there than in the ADO connection that I assume you are using.

There are two secrets to success in this world:
1. Never tell everything you know