ODBC - Call Failed when using Upsizing Wizard

[smsmail]

Hello

I uncorrectly exported an access table using Access Upsizing Wizard to the System Database/Master database in SQLServer 2008 Express. I deleted the table.

Now when try to use the Upsizing Wizard I am getting error "ODBC - Call Failed".

Because of incorrectly exporting a table, what could I have affected? Where do I start troubleshooting?

Thanks in advance for your assistance!

 

[smedvid]

I've seen some strange things using the Upsizing Wizard...

Make sure you refresh SQL Server Express and perhaps close everything; and start from scratch. Even try to rename the tables perhaps.

Worst case, you can always enter DDL Commands in SQL Server Express to create the table, assuming that the table structure is not too massive.

htwh...


Steve Medvid
IT Consultant & Web Master