Hi

I'm writing a program in VB6 which will be able to connect to any Access database and search, add or remove data. As such I need to get all the data about the database during runtime.
So far I've got all the information I need except whether or not referential integrity is enforced on a join. Is there a way to find this out without trying to add data and catching the error returned if it fails?
I'm using ADO objects and methods.

Thanks in advance

Vampyr Bytes

Yes it is possible with ADOX. An example:

Dim cat as new adox.catalog     cat.activeconnection= connobject ' (or connection string) dim tblchild as adox.table     set tbl=cat.tables("childtablename") dim k as adox.key dim col as adox.column     for each k in tblchild.keys         debug.print k.updaterule         debug.print k.deleterule         ' to get fileds that form key         for each col in k.columns             debug.print col.name                 next col     next k

____________________________
If you find the answer helpful, please mark this topic as solved.

Thanks Goran