Create relationship by VBA Code

[a]

Create relationship by VBA Code

I have 2 access data base

I want to control the second data base from code ( I want to create
relation in another data base)

Table1 (PlayerID) Autonumber Primaykey

table2 PlayerId foreign key

 

[Allen Browne]

OpenDatabase on the back end file, and CreateRelation

Here's an example:
http://allenbrowne.com/func-DAO.html#CreateRelationDAO
You need to use OpenDatabase instead of Currentdb.