Quote Originally Posted by CreganTur
I hope I'm not butting in, but I wanted to point out that you could create an Access front-end specifically for your users to input their data. It would consist of linked tables connected to your backend data tables. You could build it so it only contains the forms and methods that are absoutely required for the User to do their job.

Through the built-in startup options you could keep the User from ever seeing the database window (As long as you disable the ability to shift-open a database) and display the Form you want them to see.

This would simplify a lot of the issues you're currently running into.

Just my two cents
Hi,

I'll certantly give this a whirl when i've gotten used to using Access, for the moment i'm happy to use Excel with ADO. but look out for me posting in the Access forum soon though as i'll have some interesting queries.....