|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
September 23rd, 2003, 01:20 PM
|
|||
|
|||
|
This Can't be Good
Opened up one of our tables to find that a certain range of records are now out of order and some records have been deleted. But not an intentional or user delete. Across all the fields within some records we are seeing #Deleted - has anyone ever ran into this before. Did it really delete some of the records or has it just added records that say delete. We've got our backup so we are covered but want to prevent this from happening in the future. Any thoughts?
|
|
#2
September 23rd, 2003, 05:27 PM
|
|||
|
|||
|
i' ve seen "#Deleted" when between two tables connected with relationship, i deleted a record from one table and there was no related record with the other record...
the retationship settings were.. - enforce referential integrity - cascade update related files - cascade delete related files
__________________
I was born upon the sky where the wind flew free and there was nothing to stop the light of the sun...
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > This Can't be Good |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
