Hey guys,
I get to stay at work till I resolve this so any help would be great
So I have my database all ready to be upgraded to SQL server 2005, everything for the most part works just fine.
After I upgrade with the Microsoft SQL Server Migration Assistant 2005 for Access tool, my Many-To-Many tables will not allow me to do and edits.
I believe this is to do with my Cascading settings on the SQL server but I am quite new to the server and I am unsure of how to set it up.
I have included the following errors I get when trying to add in new rows of data into the Join tables.
I have a feeling this is a simple fix >.<
I get to stay at work till I resolve this so any help would be great
So I have my database all ready to be upgraded to SQL server 2005, everything for the most part works just fine.
After I upgrade with the Microsoft SQL Server Migration Assistant 2005 for Access tool, my Many-To-Many tables will not allow me to do and edits.
I believe this is to do with my Cascading settings on the SQL server but I am quite new to the server and I am unsure of how to set it up.
I have included the following errors I get when trying to add in new rows of data into the Join tables.
I have a feeling this is a simple fix >.<
