Set db = CurrentDb Not Working for One User

[DataChick]

I have an MS Access database front end that is being used by over 50 users. I have one user who receives an error when attempting to run the "Set db = CurrentDb" code.

He receives the error "Cannot Create Object" and when you click Debug it highlights "Set db = CurrentDB" in the VBA Code.

He has the same version of MS Access as everyone else. I even double checked to make sure he didn't change the references somehow and they are all the same. I cannot figure out what is different about this one users PC that causes him to be unable to use this code.

Any thoughts or suggestions are greatly appreciated.

Thank you in advance for your help.

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein

 

[TheAceMan1]

How are ya DataChick . . .

Is the variable [blue]db[/blue] initialized with a dim statement:
Dim db As DAO.Database

What version access?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]