check to see if field exists in table prior to linking
Posted on 2016-09-12
Access 2013 Desktop database using VBA
I have a front end and linked back end database.
I have logic for the user to selectively change the linked backend database to another accdb file.
When the user indicates to link to a new backend database,
I want to first check to see if a particular field exists in the new database - if not, add it to the new database,
then proceed with the linking.
how do I determine the presence of a field in a database I haven't linked to yet?