Freitag, 11. Januar 2013 01:23I'm trying to set referential integrity in my back-end relationships but it wont let me. I ran a join between the tables and it found one mismatched row which has blanks in the join column. How do I set this column to null via datasheet editing? I tried hitting delete and that did not work, I guess it left an empty string in there.
Freitag, 11. Januar 2013 01:42
Why not use an Update query to correct it?
SET MyField = Null
WHERE MyField = ""
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele (no e-mails, please!)
Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)
- Als Antwort markiert AllTheGoodNamesWereTaken Montag, 14. Januar 2013 15:56
Freitag, 11. Januar 2013 01:46Backup your database then use an update query.
- Bearbeitet KARL DEWEY Freitag, 11. Januar 2013 01:47
Montag, 14. Januar 2013 15:57I used your solution but it would be really nice if there was a way to do it via datasheet editing.
Montag, 14. Januar 2013 17:20
I used your solution but it would be really nice if there was a way to do it via datasheet editing.
Since an empty string is not physically displayable there is nothing to highlight. Hence Delete won't work.