Using a MS Access 2007 database which has data and relationships between the tables. I uploaded all the tables to SQL db. I then created the ODBC connection to update the db. But I cannot restore the "Enforce Referential Integrity".. Do I need to recreate all the tables without data, create the relationships (with ref integ) then add all the data back in. I sure hope there is another way to creat the "Enforce Referential Integrity"..
Pls, any suggestions??