Error - Undefined function

[scottb]

Hi everyone,
In one of my databases I just started receiving the following error: Undefined function 'TimeLapse' in expression. I can close the msg box however I cannot access (actually aren't there anymore) any of my objects from within the VBA environment. I am running this database from a dropbox folder and it is the only database that is experiencing any issues.

I can't find much information about this. Has anyone seen this and know how to resolve it?
Thank you.
-Scott

[HansV]

What happens if you copy the database to a local folder?

[scottb]

I tried that and still receive the error.

[HansV]

What happens if you select Database Tools > Compact and Repair Database?

[scottb]

Tried that too. Same problem.

[HansV]

One more: in the Visual Basic Editor, select Tools > References...
If one or more of the selected references starts with 'MISSING:', clear their check boxes, then click OK.

[scottb]

Thanks Hans. None are missing. ......getting a sinking feeling about this :-(

[HansV]

It looks like the database has become corrupted.
Create a new database, and try to import all database object from the problem database into the new one.
What is the result?

[scottb]

It's hosed. Most of the forms and reports would not import "object not found" and "no records found in index". No objects available in vb environment. I have a backup that is working from a couple days ago. Thank you for your help...Never saw this one before. Have a great day Hans.

[HansV]

Glad you had a backup - that would have been my last suggestion...

[Wendell]

My two cents on your situation: I am of the opinon that running an Access database from DropBox (or GoogleDocs or OneDrive) is fraught with peril. The way Access works, it pulls objects from the "cloud" and then does things, and then puts them back - perhaps in altered form. Any interruption of your Internet connection - or even a hang on your PC is likely to leave the database in an unknown or corrupt state. Best practice is to split a database into a front-end/back-end configuration, but I'm not sure how you would do that with DropBox. Perhaps someone else has experience in trying to do that.

[scottb]

Thanks Wendell. Appreciate the input. - Scott