>>I've been having a problem with data base corruption when I build referential integrity into it using the data environment. Anyone else having this issue? It doesn't matter if I access the dbc on my laptop or another drive. I selected one table which had a relationship and selected "referential integrity", then seleced "cascade" for deletes and saved, and immediately got the .dbc corruption message....
>
>I had such a problem.
>What I did:
>1. Open database as table exclusive
>2. SELECT * from database into cursor crsTest NOFILTER
>3. ZAP database
>4. INSERT INTO DATABASE;
> SELECT * from crsTest
>
>Be sure you have a very good backup first.
I'll give that a try. I thought it might have had to do with my resource file, so I deleted it and tried again. It still corrupted. I also validated the database, packed the dbc and still got the same results. I'll give your suggestion a shot.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright