The reason they're not upsizable is because those features are either
not supported in SQL Server, or they're done differently. All action
queries and some SELECT queries are best re-written as stored
procedures or for some SELECT queries, UDF's (SQL 2000) only. A good
book on T-SQL helps -- I like Ken Henderson's "Guru's Guide to
Transact-SQL". Also, start* out on the SQL Server newsgroups
and grab the SQL FAQ -- http://www.veryComputer.com/
The learning curve is quite steep--Jet and SQL Server are *not*
FWIW, the upwiz does a lousy job upsizing. you're better off learning
about SQL Server, doing the schema manually, and then loading the
Microsoft Access Developer's Guide to SQL Server
On Fri, 16 Mar 2001 11:09:49 -0000, "Tareq Abdeen"
>I read in the upsizing instructions that Crosstab, Action with parameters
>queries, nested queries, DDL, Union and queries that reference values from
>forms, are not upsizeable.
> What are the work around for each one of those queries??
>Thanks a ton ...