VBA Project Reference; How to in Access

[pedie]

Hi, I am thinking there is a way to do this.
I have i want to reference vba project that is located in db2, so click on > tools > reference > i browse for the file > and located db2 and selected it and then tested like.

[/FONT]
[FONT=Courier New]sub test[/FONT]
[FONT=Courier New] run "db2codetest1"[/FONT]
[FONT=Courier New]end sub[/FONT]
[FONT=Courier New]

it seems to work...however i set a password for vba project in db2 and then now when i try to run the same code it states err; "*Code not found...*"

Please advice.

Thanks in advance.

 

[xenou]

Not sure, but possibly you want to reset the reference (after setting the password - which you presumably must supply when you create the link).

 

[pedie]

Hi Xen, thanks for replying....
I have tried that and still wont allow me to run this code located in another db...

Thanks again.

 

[HiTechCoach]

I assume you are using a VBA passw3eord to protect you code. I never use VBA password to protect the code.. Besides they re easy to crack and only cause headaches.

When you deploy your library database just compile it into a mde/accde. This way the the VBA code is protect5ed.

Have you read about creating an Access add-in?

See:
Microsoft Access Add-in (Library Database) Tips, Hints and Gotchas

if you want to create an add-in for wide spread use outside your control then you should consider creating the MDE as an add-in with the USysRegInfo table. Otherwise just setting a reference works fine as Access 2000 and newer look in the same folder as the calling MDE for reference MDE.