Reference issue

[Zygor]

I have a databse that creates other databases. I'm using CreateObject("Access.Application") to make the new database, then I bring in the necessary tables, modules forms... When finished, I e-mail them to the end users.

My problem is that I can't figure out how to set references. I need to use some in the newly created databases that aren't checked.

 

[PHV]

Have a look at the References collection of the Access.Application object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zygor]

That's just what the Dr ordered. Thanks!

 

[TheAceMan1]

How are ya Zygor . . .

Be aware: [blue]Reference locations are not static[/blue] and some may depend on where Access was installed. You'll have to at least nrun the gamut for all Access versions! . . .

See Ya! . . . . . .

 

[Zygor]

Hi Ace!

Here are the ones I'm using.
"C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
"C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\vbe6.dll"
"C:\Program Files\Microsoft Office\Office10\msacc.olb"
"C:\Lotus\Notes\domobj.tlb"
"C:\Lotus\Notes\notes32.tlb"
"C:\Program Files\Common Files\System\ado\msado25.tlb"

We use XP at my work.