Access to MSSQL Server Upsizing (Table Errors)

[Comn8u]

I just upsized my database from Access to MS SQL Server and it mostly ran smoothly. There were some tables, stated in the error report, that weren't upsized along with the database because the tables didn't have unique indexes.

Since it worked in Access, how would I go about getting the tables upsized to MSSQL Server? Also, would I have a problem adding indexes to the tables that already contains data?

 

[grnzbra]

Access records True as -1 while SQL Server records it as 1. That might be a problem. There may be other incompatibilities, but I can't think of them.

 

[RJFost]

While the auto-upgrade does a good job with 90% of your Access objects, the remaining 10% can be enough to make St. Peter kick babies (DISTINCTROW can be a real bitch, for example).

Microsoft has a slew of documentation on their website, whether you're transitioning from Access 97 -> SQL 7 or Access 2000 -> SQL 2000. I'd suggest starting there.