Column value search in Access database

[Dolly Kumari]

Hi,

I want to write a Program in vb which will accept any Access database (.mdb file) and search a particular column value in all tables present in the database and will give the result as table name and column name to which column value belongs to.
Could any body suggest if we have any access query to get the same or how to approach for this.

Regards,

Dolly

[nico5038]

Hi Dolly,

For this you'll need to process all tables from the tabledef collection and dynamically create queries to issue for each field within each table a

select <fieldname1> from <tblA> where <fieldname1> = <yourvalue>

For the WHERE you'll need to check the datatype (not sure or your value is string, number or date) to embed the value in the appropriate separation character.

Nic;o)