Hi,

I have an MS Access database that has a large number of tables and relationships. From VB, I need to be able to find out about the structure of the database in order that I can create a SQL script.

More specifically, I need to be able to determine the constraints on each table. My script will read:

'ALTER TABLE tablename DROP CONSTRAINT constraintname '

However, I am having difficulty on finding out each relationship name in MS Access. I have tried ADOX, but each table object holds only Index objects rather than Constraints. This is my problem - I need to know these constraint names.

I HAVE to create a SQL script, so copying the database with any other method is not feasable. Having found out the constraints and created the 'DROP CONSTRAINT' syntax, I will later recreate each constraint.

If anyone has any suggestions, they would be greatly appreciated.

Cheers,
TFA