Originally Posted by
sdel_nevo
...when i made the changes above i still got the error messages, when i created a new blank form and copied my code into it everything worked...
Doing this is the first line of defense when corruption of the database itself is suspected, which would tend to suggest that your db was, in fact, corrupted!
Allen Browne has an excellent article on the prevention of corruption, during development and after distribution, that you probably need to look at:
http://allenbrowne.com/ser-25.html
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007