Im having trouble upzizing a MS Access DB to SQL Server 2005
One table in particular keeps failing to upsize.
The table is called "master" (if that has anything to do with my error?)
The table has 1987 rows so should be able to upsize???
Im not getting any error when I try and upsize it on its own. It just comes back and says
"table was skipped or export failed"
All the other tables upsize without error.
When I try and upsize them altoghether with the same relationship etc I get the following error on a few tables all connected to the master table
Server Error 1776: There are no primary or candidate keys in the referenced table 'Master' that match the referencing column list in the foreign key 'table1'.
Server Error 1750: Could not create constraint. See previous errors.
Anyone have any ideas??