Problems with Access2000 upsizing wizard

When I run the Upsizing Wizard in Access 2000, I go through all the settings as I’m told via manual and have used a couple of different SQL logins, etc. At the end, it does go through some kind of process and gives me a report saying that it was notable to export the tables. What am I doing wrong? I have Access open on my machine and opened the database which resides on a server that I am mapped to via a shared drive. I have also tried this at the server itself. Same thing.