Use vba to introduce table relationship in be

[JohnPapa]

I've had no problem to import "tables" in the remote backend via vba and the corresponding "link" in the front-end.

I have never added a relationship between 2 tables in the backend. I guess there may be potential problems with existing records not matching etc.

Is adding relationships between tables in the be via vba advisable? What command should be used?

Thanks,
John

 

[DJkarl]

I would say it is not advisable, though I'm sure it is possible. I think this type of activity is akin to creating the tables in the first place, it is more of a one time setup, if you are needing to create/delete/re-create table relationships then perhaps the database design needs to be re-worked a little.

 

[gemma-the-husky]

it can be done - but you do not need a relationship to exist in order to run a database. all (not quite all but for this purpose all) the relationship generally does is enforce relational integrity, and this may or may not be critical.

note if the data breaks relational integrity, you would not be able to add such a relationship anyway.