Strange error message

[Guest]

Hi,

I've built a multi user DB with backend & frontend. The frontend is to be
located on the C drive of the user's computer. I've built in an auto-update
feature so that if I need to make changes to an object I can update the
frontend without having to reinstall the db. This works fine.

I have written my own function to return a time in minutes:

Public Function fTimeInMinutes(dtTime As Date) As Long
fTimeInMinutes = (DatePart("h", dtTime) * 60) + DatePart("n", dtTime)
End Function

After an update occurs, for some reason the database is saying this function
is not declared (when clearly it is). If I exit the database and reload it,
it works fine.

Does anyone have any ideas about what could possibly be causing this?

Thanks

 

[Guest]

A bit more info...

The function is called within an SQL statement which is run from code to
update a table.

The exact message is:

Undefined function 'fTimeInMinutes' in expression