Corruption Flag

[bootybox via AccessMonster.com]

What is the Microsoft Access corruption flag?
How can I find it?
How can I find the value of it, "set or not set" with VBA
(An external database, of course)

Any info appreciated.....
Thanks
DS

 

[Arvin Meyer [MVP]]

I've only seen it in memo fields. In my experience, it marks the field with
# as the first character, but that is also an allowable character. As a
matter of fact, if you search for it, you will only find the allowable
characters, not the flag. The last time I've seen it was 7 years ago in an
Access 2.0 database.

I haven't had to look for corrupt records since then, but I'd find them by
dividing the records in half and running a query on each half. The broken
side always returned an error. Then divide the broken side in half,
etcetera, etcetera.

 

[missinglinq via AccessMonster.com]

I think this article from Micro$oft's Knowledge Base goes into what you're
asking about:

http://support.microsoft.com/kb/209137/

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com