Run Time Error

[Brian Roberts]

I have created a multi-user database and one of the users is getting, upon activation, a Run Time Error'429' message stating "Active X component can't create object." When I press debug, Set dbs = Current Db() is highlighted in the Private Sub Fill Options() Procedure. I checked the Tools-References option and discovered that Missing: Microsoft DAO 3.51 Library message on the list with a check mark beside it. I tried unclicking the missing references using the Tools Menu but, then I get a Compile Error Message. Any suggestions to remedy this problem?

 

[Rich@ITTC]

Hi Brian

You are 75% there to fix the problem. After unchecking the MISSING reference (Microsoft DAO 3.51 Library) scroll down the list to find a similar reference that you do have installed - Microsoft DAO 3.6 or Microsoft DAO 3.0). Put a tick alongside this one and then close the refernces section go to Debug - Compile and Save all Modules and Bob's your Uncle!

HTH

Rich Gorvin

 

[MarionD]

Hi there,
just my sixpence worth - if you're using Acess 2000 you must set the priority of the Reference to DAO 3... higher than the reference to the Active X objects.

Marion

 

[Brian Roberts]

I looked at the Tools/Reference list in the Switchboard Form Module and couldn't find any Microsoft DAO Library. I found that I did not have any problem with opening other databases on the same PC but, not that particular database. Any suggestions?