I think the longest thread that I have ever seen, in an Access forum, was on this subject; I finally stopped following it when it approached 400 posts and was still far from a solution!
There are times when off-the-shelf software, for a given task, just makes more sense than rolling-your-own, both money wise and time wise; and I would think that this is one of those!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007