If creating an Access Database front end with SQL Server back end for, say, 20 people to use at one time, what is the best way to setup forms and tables to avoid records being lock due to more than one person trying to access at the same time? Is it good to have a table on the front end client side to hold form data which is submitted to the record table in batches? Thanks.