Test for picture

  • Thread starter Thread starter Anthony Fontana
  • Start date Start date
A

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
 
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
Click to expand...

I take it this is an OLE Object field? What might be in the field OTHER than
pictures?
 
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.
 
Back
Top