Export / Enable reference in external database

[memaxt]

Hi there,

I have a database that is shared across the country, I regulary issue service packs thats updates their database. which contains Updates & New forms / tables etc...

anywho

when they open up the service pack database it automactilly exports its contents to their database to update it but its not adding the relevant references to new forms.

is there a away I can make the database add the follwoing reference via vba 'Microsft ActiveX Data Objects 2.1'

 

[Galaxiom]

Add the entry to the References Collection using VBA.

https://msdn.microsoft.com/en-us/library/office/aa223135(v=office.11).aspx

 

[memaxt]

Hi Galaxiom,

I used the following code that worked:

Dim ref As Reference
Dim intRef As Integer
Dim ErrorMsg As String

intRef = 1
Set ref = References.AddFromFile("C:\Program Files\Common Files\System\ado\msado21.tlb")

Exit Sub

Many thanks for your help!