I am new to VB and am looking for a way to merge(sql) eight access tables together to search various data records. If anyone knows of a sample program that illustrates this problem, I would be interested. My problems are as follows:

1. Some of the tables have the field name "UNION"(I am using access to link to dbf tables and it would be difficult to change the field names and UNION is a SQL reserved word).

2. Should I link the tables or should I search each table one at a time. Some of the tables have a few dissimilar fields.