By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

More Data Type Mismatches - It Makes No Sense

P: n/a
I have had this database up for several months and suddenly I began
getting "Data type mismatch in criteria expression" Errors all over
the place. I can open a query and get this error, then say OK, try
again and it opens fine. All of my reports are failing and I'm
getting frustrated. I have seen several issues addressing this, but
no clear solution. Occasionally I will also get an error when opening
reports that states the expression is too long, but I can't identifiy
which expression it is refering too. I have systemitaclly removed
subreports looking for a solution, but I cannot identify it.
Considering the random nature of these issues I considered, and having
recently experienced problems with Access Wizards. I did a complete
uninstall then reinstall into a new dir without any luck.

Part of me thinks it is just some corrupt data, but I can get the same
errors with the same randomness. Leading me to think corrupt db or
access issues. Several other access databases are working fine; and
many share the same data.

I'm really getting frustrated.
Any help would be really appreciated.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.