Error on form open

[CCIDBMNG]

I have a database setup to track daily tasks. When you open the database a login form automatically opens with a drop down box of names and a textbox for passwords. When one of my users opens the database he gets the error "Method 'Recordset' of object '_form_sfrmLogin' failed. Error -2147024770 (8007007e)." You hit ok then he gets an error when he tries to click on the drop down box the error occurs on the code the combo box wizzard sets up. Does anyone have any idea what causes this. I have 10 users using the same database and he is the only one that this happens to. I have checked to make sure all the references are there and they are. Any help would be much appreciated.

Thanks,

Tina

 

[CCIDBMNG]

I've found the problem and fix just in case anyone else has this problem. When office was installed on the user's computer it did not place the DAO dll in the correct place. If you download COM Explorer from www.4developers.com you can view any problems with any of the DLLs on your computer. If a DLL is not where it should be COM Explorer tells you where it should be so just do a search on your computer for the missing DLL and paste it into the correct location.