I can not get the Upsizing Wizard to work.
XPPro
SQLServer 2k Developer
Access 2003
Norton Firewall

I can get the Wizard to run on my laptop, same OS and SQL. Access 2002, no firewall.

But on the Desktop Machine no matter what I do, when I run the Upsizing Wizard it always tells me the it can't find the server or access denied. I've tried both kinds of authentication to no avail.
I can go into EM and work with the DBs. I can link them to Access via ODBC and it works.

I have tried turning off the Firewall but that doesn't help either.

Any suggestions would be appreciated.

Thanks

Run the wizrd from the laptop. The tables are the only item you want to upsize anyway. The queries do not get upsized well at all.



Sal