thutmoseone
IS-IT--Management
I'm having problems creating a reference to actole.dll and act.exe in Access 2000 VBA, VB6 or Excel 2000 VBA. I get the "can't create reference to specified file" error from the references menu. Therefore when I use the createobject("actole.database"
or getobject("","actole.database" statements then reference values of database fields within the object I get a "object variable or with value not set" error because the reference was not established. Funny thing is when I have Act open to a database the createobject or getobject statements work fine and I can retrieve database field values with no problem. I need VB or VBA to open the database or application object without requiring Act to already be open. I used the actreg utility to successfully register the Act components then I copied act.exe and actole.dll among other files to the windows system folder and successfully used the register command from the Win2000 command prompt but no help. I can't make a reference to the object I'm I missing something. All comments welcome. Thanks.
or getobject("","actole.database" statements then reference values of database fields within the object I get a "object variable or with value not set" error because the reference was not established. Funny thing is when I have Act open to a database the createobject or getobject statements work fine and I can retrieve database field values with no problem. I need VB or VBA to open the database or application object without requiring Act to already be open. I used the actreg utility to successfully register the Act components then I copied act.exe and actole.dll among other files to the windows system folder and successfully used the register command from the Win2000 command prompt but no help. I can't make a reference to the object I'm I missing something. All comments welcome. Thanks.