ActiveX Controls and Visual Basic References

[Ed207_us]

I have developed quite a few ActiveX Controls in VB6 to automate some processes for my database that Access Vb can not quite handle. Getting these registered automatically does not seem to be a huge problem. I have found many resources that allow me to create automated scripts and batch files that will register my ActiveX controls on a new machine. I can include that in an installation script.

The one thing I CAN NOT find out is how to through code or otherwise, modify the Access VB code references. A default Access 2k database does not reference the DAO 3.6 object library ( only god knows why ). I have to reference those among many others.

I am currently in a situation in where I must create something automated to install this database (backend, frontend, vb activex control components) on a new machine and have it work without any additional "admin" assistance. I also cannot distribute a Access DB file. It needs to be created on the fly with some startup code that will set its references on this newly created Access DB.

I appreciate any help!

 

[fuzzygeek]

Re: Ref

The following example refers to the Reference object that represents the reference to the Microsoft Access type library:


Dim ref As Reference
Set ref = References!Access


Look up reference in the vba help (in a module). You can select references programatically. I have done it before so as to insure the current references are selected. You need to have the reference's name and path.