Upsizing Wizard in Access 2003
I can not get the Upsizing Wizard to work.
SQLServer 2k Developer
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.