I am using the upsize wizard from Access 2000 database to SQL Server 2000. When I try upsizing the DB from my client the report I get back just says "The table was skipped, or export failed." I am running under Windows 2000 Professional OS, Office 2000 Premium. I can import from the client’s DB from a SQL DTS but want to use the Access upsizing tool.
I even installed all the items from the article http://support.microsoft.com/kb/272384#kb1
except the files ACWZ_Admin.msp and MDT2_Admin.msp which give errors when applying the update patch that the program is not installed or incorrect version.
If I use a template DB created from Access like expenses it all upsizes OK.