I'm encountering a crashing problem (database inconsistency) with a shared
Access 2002 database.  I've split a DB into a front-end (sales.mdb) and
back-end (sales_be.mdb) and there are approximately 5 users logged into the
DB at any given time.

The problem is that I have one user who has to continually update the BE to
push sales orders (every 15-20 minutes) and it at least 2-3 times a day, the
BE crashes and I have to rebuild it (after kicking everyone out).

Is there a way to allow this user (who's pushing sales orders) to LOCK all
tables for the 2-3 minutes that it takes to push orders?  Or, if this isn't
the best solution, can anyone help with this?  

Thanks in advance for your help.

Regards,

G