Easy problem...help anyone?

Question

Help from anyone appreciated... I create a new Access DB using ADOX.CatalogClass, and then add tables to that DB via a Command object and "CREATE TABLE"... After creating several different tables, I want to define the relatsionships between the tables. What is the best way to do this and how? How do you load an entire DB of empty tables into a DataSet object? I thought the best way would be to bring the newly created empty DB into the application locally via a DataSet, then monkey around with the DataSet relatsions and then update the DB I am clueless at this point Scott

Adam Erstelle · Answer

I'm not sure if you can apply DataSet relations back to the database (it may be possible but I have no idea). What you may want to try is adding your constraints via the SQL Command: ALTER TABLE.