hope you can help.

I need to get my access db backend to sql2000. I have tried the upsizing
wizard but the get message "overflow" and cannot get any further.

I also use queries that reference two date ranges from forms such as
BETWEEN forms!form1!text1 AND forms!form1!text2. How can i achieve
this in an sql view?

Thanks in advance

I've always has trouble with the upsizing wizard - you might be better
off creating the tables in MS SQL and then linking to them and then
copying the data from Access to MS SQL - as far as the queries go -
you'll need to modify them to make them paramater based....

"Mark Worrell" <maworrell (AT) ananzi (DOT) co.za> wrote