Search results

I am looking to see if the part number is contained in the PartNo field of multiple tables. I am trying to do this using vb from the front end database, hence the need to make a "connection" with the backend. I cant search the linked tables in the front end as there are other very large tables I...

I have a split Access 2003 database with all tables in the back end. Being a relative newcomer to vb I want to search each back end table for a particular value in a field and then list all tables in which the value is contained. (It is actually a "Where Used" search for a part in various parts...