cheezebeetle
MIS
Ok here is the deal. I have created a db with much data within it in Access 2000. Have used upsizing wizard in the past to move design and data into SQL 7. No prob.
Well, now have a need to do the same, but am in a SQL 2000 environment. I can't get the upsizing wizard to work. So, ok, I do the upsizing to 7, then make a backup in 7. Then move the file to the machine with 2000 installed (totally different location) and try to restore. That doesn't work either.
I checked the MS site for info on any incompatibility issues, but found none. So what gives? Any ideas?
Also, the SQL 2000 server will be eventually doing a datapush to a SQL 7 server that drives a website. Think this might cause problems as well??
HELP on this one!?
Thanks
Well, now have a need to do the same, but am in a SQL 2000 environment. I can't get the upsizing wizard to work. So, ok, I do the upsizing to 7, then make a backup in 7. Then move the file to the machine with 2000 installed (totally different location) and try to restore. That doesn't work either.
I checked the MS site for info on any incompatibility issues, but found none. So what gives? Any ideas?
Also, the SQL 2000 server will be eventually doing a datapush to a SQL 7 server that drives a website. Think this might cause problems as well??
HELP on this one!?
Thanks