‘The value you entered isn

Topic

New Reply

I have an Access 97 database that has been running flawlessly on an end-users machine for 2 years. This morning they called me tell me that whenever they enter a new record and enter a date they receive the message “The value you entered isn

Reply | Quote

Replies

Check for any missing references.
If you don’t know where to go and check this, go into any code and select Tools/References.
HTH
Pat

Reply | Quote

Yep, I tried that and everything looks OK in my db. No broken references. That still would not explain the weird behavior in a newly created mdb file on the end users machine though right?

Reply | Quote

Just a long shot here. How is the date format set up on the users machine in Windows? Any upgrades recently that could have changed it?

I assume you compacted the database (if you can do that in 97??)

Reply | Quote

Thier short date style is mm/dd/yy in the windows regional settings. I had them try changing the short date settings to 4 digit year and it made no difference. The only other software they said they recently installed was “Pro System FX” and “Laser Librarian”, both are tax software packages. I’m looking into if either of these programs use MS Jet and/or the DAO libraries and if perhaps an older dll was installed somewhere. I suppose I could have them uninstall Access and reinstall… but what a pain. Oh, and yes the database is compacted : )

Reply | Quote