ActiveX Component can't create object

[BrockLanders]

I have an Access 2003 database setup for about 6 users on a network. The tables are housed on the network server and the users database's (queries, form, etc.) are housed on their local machines. All users link to the tables on the network. Everything is working fine except one user is getting an error: Run-time Error '429' ActiveX component can't create object.

When a user opens their database I have some code run. It's very simple code that is just opening a query. However, when this user opens their db they get the above error at the line in bold below:

Function Notify()

Dim queryInst As String, queryPO As String
Dim RecSet As DAO.Recordset, DBase As Database

queryInst = "SELECT * FROM [Need Instruction Sheet] ORDER by [Program]"

[b]Set DBase = CurrentDb[/b]
Set RecSet = DBase.OpenRecordset(queryInst, dbOpenForwardOnly)

Any idea why this error is occuring for just one user? All users are running Windows XP.
Thanks in advance for any help

 

[PHV]

Have checked the references ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BrockLanders]

Yes, all the references are there I believe. I copied the same user database, which already had the references set onto each persons PC. Do I need to set references on each PC as well?
It seems to me like a login issue. I do not have any security in the database, but all users must login to the server since that's where the backend (tables) reside. Does this sound like a possibility?
Thanks