Software

Ask something
Discussion Locked

Problems with Access2000 upsizing wizard

0 helpful
3 replies

by dana803

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by ptaylor

Two questions:

1. Are you getting any kind of a specific error on the report or is it just listing "Not able to export the tables".
2. In the wizard process you should receive a prompt box asking to upgrade the export table attributes. Are you upsizing the indexes, validation rules, defaults, and table relationships, with the radio button set to "Use Triggers"?

by dana803

No specific errors, and only trying to upsize indexes and defaults. I ended up using the SQL import wizard.

This discussion is closed to new replies.