Error: communicating with the OLE server or ActiveX Control

[soccerkingpilot]

I've been building a database with lots of automation for a while now and it's been working fine this whole time. Today, I was working on some of the features and it was still fine. Then, I closed it and went to lunch...when I came back, now none of my macros work. They all produce this error.

I've looked at previous answers but I'm fairly limited...I don't have any admin access to my computer to try a repair or changing the non-unicode language.

It would be time-prohibitive to recreate this database...any help is greatly appreciated!

 

[spikepl]

This error can be caused by obscure syntactical causes - the first thing to do is to compile (Code window ->debug -> compile) and see if that yields any pointers.

 

[soccerkingpilot]

Thanks spikepl,
In my frustration, I tried a few different things and ended up fixing the problem by discovering that the issue was only affecting one form. I made a copy of the form, deleted the original, and renamed the copy to the original's name. All is working well now. It's still disconcerting that issues like this can creep up so easily :/

 

[spikepl]

WHen developing intensively, take backups. Each time I embark on a major set of changes I take a backup.

 

[soccerkingpilot]

WHen developing intensively, take backups. Each time I embark on a major set of changes I take a backup.

Luckily I had been but it didn't come to that