Help needed: Database and Reference Error

[BenSteckler]

Help Please,

I have an access database that is housed on a novel network. There are multiple users that have used this database for more then a year with no problems. But starting Thursday an error started occuring when this code was used:


Me.TimeIs = Time()


They would recieve this error.


Compile Error:
Database or Reference can not be found.


It would then highlight the Time function and stop the code.

The problem is that, it is not everyone. It started with one person, now 8 people have a problem. But more then half still have complete usablilty.

We have re-imaged the machine, but the problem still occurs.

Any ideas?
Thanks
BDS

 

[Autoeng]

Have you checked your references to see if any are marked as "Missing". I have had this happen to me on some machines but others are ok. I unselect all references, compile and save (if it will let you), then reselect all references. Usually clears up the problem.

During a week or so while I was adding new things to my db everytime I would load the new version for download I would get the error. Then it stopped and I really hadn't done anything other than what is described above. There is a known bug in Access for this problem.

Autoeng

 

[BenSteckler]

Hi,

I thought access automatically complied the code when you saved the module? Is that incorrect?

I will try what you said about the references. But I thought the Time function was a standard Windows command?

Thansk for the help. I will response when I have attempted the correction.

BDS

 

[WayneRyan]

Ben,

The Time(), Len() etc. functions are always the first to go.
Access and its references cause a lot of problems.

Go to the machines that function properly, note down the
refs (and their priority) and replicate that on the bad machines.

You might want to do a search on this forum, this is a common
problem with Access. I think I posted a routine that will
programatically set them.

Wayne

 

[WayneRyan]

Ben,

http://www.access-programmers.co.uk...threadid=41181&highlight=References+AND+Wayne

Wayne