trevena
asked on
CurrentDB function causing Active X Error
Hi,
I've out a switchboard on one of my apps using the switchboard wizard thing. Inside of the switchboard code, Access put in a function like Set Mydb = currendb(). (a function call I often use myself).
When you run the program on my clients machine you get the error "Can't create Active X component" (or something like that) when the Set Mydb=curentdb() line is called.
If you look under Tools->References (when you are in any module), Access reports back that it can't find the Microsoft DAO 3.5 (I think) object library. So, if you attempt to add the object library back again using the file in c:\program files\micrsoft shared\common files\dao folder, it still moans at you.
I copied the c:\...\dao folder across from another computer that worked and relinked, but it still didn't work
Any ideas?
Malcolm
I've out a switchboard on one of my apps using the switchboard wizard thing. Inside of the switchboard code, Access put in a function like Set Mydb = currendb(). (a function call I often use myself).
When you run the program on my clients machine you get the error "Can't create Active X component" (or something like that) when the Set Mydb=curentdb() line is called.
If you look under Tools->References (when you are in any module), Access reports back that it can't find the Microsoft DAO 3.5 (I think) object library. So, if you attempt to add the object library back again using the file in c:\program files\micrsoft shared\common files\dao folder, it still moans at you.
I copied the c:\...\dao folder across from another computer that worked and relinked, but it still didn't work
Any ideas?
Malcolm
ASKER
Hmmm...
That's usually a good idea to fix bizzare bugs, but this is a computer specific problem. Not a database specific problem. ie all databases on this machine are getting similar problems.
Malcolm
That's usually a good idea to fix bizzare bugs, but this is a computer specific problem. Not a database specific problem. ie all databases on this machine are getting similar problems.
Malcolm
Did you try to reinstall Access?
ASKER
Yup.
Several times.
Still didn't work.
Several times.
Still didn't work.
Has Access (or Office) 2000 been installed on this computer recently?
ASKER
Access 97 by the way.
They did have a "data corruption" on the machine recently. Not excatly sure what they mean by that.
It has been reinstalled several times by me recently.
They did have a "data corruption" on the machine recently. Not excatly sure what they mean by that.
It has been reinstalled several times by me recently.
Have you referenced other ActiveX controls into the database. If so, you should refresh the refs. Uncheck and then reinsert them.
Also if this is an option for you, use this great opportunity to do a complete fresh-up of your computer. Go all the way from a format c: to installing the necessary programs. It may prove to be faster than trying to point the problem and you will end up with a lot healthier machine.
Also if this is an option for you, use this great opportunity to do a complete fresh-up of your computer. Go all the way from a format c: to installing the necessary programs. It may prove to be faster than trying to point the problem and you will end up with a lot healthier machine.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
You da man...
You da man...
First try to compact and repair you database and relink references
or create a new one and copy all your objects from old DB to this new DB.
Regards,
Dedushka