Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems in upsizing to SQL Server 2000 fro Access 2000

Status
Not open for further replies.

Kindi

Programmer
Jan 31, 2001
54
GB
I have an access 2000 database and wish to upsize it to SQL Server 2000, this is fine however one of the tables will not export and the upsize report does not indicate what the problems is. The table in question has about 135 fields, could this be the problem? or that the table uses about 20 lookups fields to access some tables, is this a restriction in SQL Server. Could someone please give me some advice?

Thanks
Kindi
 
I have the same problem. The table has only 7 fields and 2 lookups.
In my case (I think) the problem is the Replication ID (since this is the only table that has one). If the field is Long integer there is no problem with upsizing.
I would appreciate some help too.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top