Test for picture

[Anthony Fontana]

How do I test a field in a table to see if it contains a picture. I tried a
query and module but, using the is not null test hung the query (didn't think
it was the right way anyway.

I need to test a table that contains pictures to take the pictures out of
the database and store on the server hard drive for better storage.

Thanks

 

[John W. Vinson]

How do I test a field in a table to see if it contains a picture. I tried a
query and module but, using the is not null test hung the query (didn't think
it was the right way anyway.

I need to test a table that contains pictures to take the pictures out of
the database and store on the server hard drive for better storage.

Thanks

I take it this is an OLE Object field? What might be in the field OTHER than
pictures?

 

[Anthony Fontana]

Yes. It is an OLE object field and it does only contain pictures. Only a
subset of the clients have pictures stored. Using the IS NOT NULL criteria
in a query on the full table (2500 records about) hangs. Just running with
another criteria added Last Name = A* returns OK in the query.