Check existence of field in Access Database

[chris921]

Hi - I've got a VB6 program which runs with a database back-end.

I would like to implement a module that checks for the existence of fields in the database, and if they're not there, create them using a simple SQL query.

The creation of the fields is easy, however I'm struggling on how to check whether they already exist or not?

If there's anyway that someone can tell me how to do this I'd be greatful!

Many thanks

Chris

 

[vbSun]

Open a recordset with the table.
Check the names of all fields in a loop.
If the field with the name that you supply exists, leave it as it is, else trigger the creation of field algo.

------------------------------------------
The faulty interface lies between the chair and the keyboard.