Upsizing Access Database Question 1

[meldrape]

Greetings,

I have upsized a sizeable database from Access 2000 to SQL 7.0. Question: The relationships did not upsize properly. When viewed in relationships in Access, the boxes that were checked before such as Enforce Referential Integrity, Cascade Update Related Fields, and Cascade Delete Related Fields are grayed out and not checked. I believe this is affecting the outcome of my reports. The data isn't being presented properly.

I'm totally lost and don't know how to get the relationships back the way they were. Any thoughts would be greatly appreciated. Thanks.

 

[prashantdhas]

hello,
Even i have faced this problem and came to conclusion that when you upsize the access db you need to manually give all the primary keys and set the relation, if i am not wrong.
reply

 

[meldrape]

Yes, I have also come to that conclusion. The way I ended up getting around my current problem was not upsizing the table in question, but leaving it as a local table. It's a small table and the database is backed up nightly, so it's the only workaround that fixes the report errors.

Thanks for your reply.