I am a complete novice when it comes to server issues but I have a project I need some assistance with. My question is: Can I safely use a temporary table on the front end of the project which will be appended to a permanent table on the back end after which the records in the temporary table will be purged of the records with a front end delete query. The algorithm will look like this: IF I want to set up an appointment with a client I create the record in the temporary table tempappt, entering the data with a form whose data source is the table tempappt. Once the user completes the record he will click a button to save it at which time the code will initiate to run a query to append the table tempappt (on the front end) to the table appt (the permanent table) on the back end. After the append query runs a delete query (on the front end) will run which will delete the single record in the table tempappt. My concern is that it may get balled up if I have multiple users.
Thanks for all the help, you guys/gals are great.
Ron Cheshier