N/APosted on - 09/17/2011
I have created an access database for my HR department at work but I get error# in each field on the database. Once I [x] out of the database and then go back to it, everything seems to work fine. Someone told me this may be due to the large amount of data in my database. If this is the problem, then what should I do? I would like to be able to keep all data in one database for easy lookup. Please help if you can.
Thanks so much.
Too much data in access database?
The #Error pops up in MS Access due to several reasons. It could be that Access could not evaluate the expression of the control's value or when a name conflict occurs. There are steps to do to eliminate the #Error. If your expression contains a function, check that the number of arguments supplied to the function is true. Check for name duplication. If there are similar names, Access would not be able to evaluate and therefore display the #Error. this error also occurs when you have a reference with no data. you could put a formula that returns 0 in the reference so that it will have data in it. Also check if you are using the correct symbols and characters in writing formulas and names. If your value returns a larger size, it will also return this error message but you can always change the default size of the value.