I've used Rick Fisher's Find & Replace
Add-In for many years. Some of you may
be familiar with it. Last year, I asked Rick
how to limit the searches performed by
his tool to local tables only. He replied
saying to type this in the table spec
field in his application's main window:
=|(%tbl%.attributes and 1073741824) = 0|
It works perfectly. Has saved me immense
amounts of time by restricting attached
tables from the scope of the search.
I'm wondering if anyone, looking at the
criteria Rick supplied me with, can tell
me how it works? That is, is there some
underlying Access principal at work here
in the specification? What is the meaning,
for instance, of the 1073741824 value?