Run-time error '3085': Undefined function 'Date' in Expression

[CCHDGeek]

I created a database with a separate front-end that is installed on each computer and linked to a back-end server. After installing the file on several computers, I realized I was getting this error: Run-time error '3085': Undefined function 'Date' in Expression. I did some research and found out that it's an issue with my references. So, I was able to fix it. But my concern is if I make changes to the front-end and need to update everyone's computer, will this happen with each new install? Is there a way to ensure the references are located in the same place on each computer using the database or have I just dont something wrong? Any help would be great.

Thank you,
CC

[FishVal]

Hi, there.

Access has References collection of Reference class objects. You'll find where sufficient methods and properties to detect and remove/repair broken reference.

The mechanism of reparing depends on what a broken reference is referencing. Sure, if this is an Access database, DLL/executable or ActiveX control you should include them in installation package. If this is type library of other application (like Office applications) there is almost nothing to do but to install a required application or warn a user and delete the broken reference to make at least others working.

Regards,
Fish

[CCHDGeek]

Well, I found tutorials to help with this error, and what I did to fix the problem was log into the database on the individual computers, uncheck a select reference and then reinstall it, and it seems to work.