I have an Access database, which is split into front end and back end. The front end has all the form,queries,reports and back end has tables. 5,6 users work at the same time on that. there is one form on front end as "frmImport", that import data from excel sheet to subform (which is linked with table called temporary) and then when a button is click all the data goes to specific core/actual tables. Now the problem with this is that as the subform (which is linked with table) that store temporary data, when concurrent users are working like 2,3 user at the same time and they are importing data each user get the data for other user also which is a mess, as the database is split temporary table which is in the back end is same for all the users , is there any way to make temporary query which store the data , as query is in the front end so even if 2,3 user are working at a time that data won't mess with other user data. Any help how to solve this?