If I've been told correctly, then when I create a union query within Access
between data held in Access and SQL7 I need to have the field sizes the
same, but this causes a problem as the field sizes within SQL7 will change
automatically making my queries useless in a short space of time.
Is there a way of getting the field size from the SQL field automatically
and link this into the Access union query.
Any help greatly appreciated