Date is not Recognized

[a_20120]

Hi all,
I have used Date and Time in a Database, it works on my PC well, but I use that DB on another PC, an error occurs (Compile Error)...Any faced such problem plz help me...

 

[RuralGuy]

Access Reference Problems

 

[a_20120]

thanx for quick replying, but what should I do to solve the problem...?
I should mention that the PC just doen not recognize my DB Date and Time, but when I create DB with Date and Time on that PC, it works well

 

[RuralGuy]

Chack for MISSING references as that link suggests.

 

[a_20120]

Hi Sir,
I did not find anything helpful there for my problem...when I create New DB the Date and time Works well

 

[Rich]

If a DB you created on another machine does not work and a db created on the second machine does then your db has a missing reference. Follow the link to fix the problem

 

[oldozziesubby]

Access has a problem with dates. Most of the time it references the American format. So you have to convert your dates to the American way... (Load of bollocks to my way of thinking.) The other option you have on a different PC is to change the time/date settings from the control panel.
HTH

 

[boblarson]

Also, one of the missing references that deal with date/time (as well as mid, left, and right functions) won't necessarily show up as MISSING in the references. It has to do with MSCOMCTL32.ocx. What I will usually do, if I have that problem, is just go browse to that file from the references, as if I was adding a new one (there's a browse button) and go to C:\Windows\System32 and find it and then click ok. That will usually fix the problem (doesn't always, but most of the time it does).