I have a process which creates 45 tables into which I append data temporarily. I use that data to produce a document for a specific event. Then for the next event, the existing data gets deleted, and I append the new data, and produce a document. If more than one user is using the database, it is possible that the second user could override the data needed by the first user, before the first user has produced the document they want.
My question is when I delete from and append the data to the 45 tables can I identify them to the user who has opened the database so that they act as if they were local? Thanks for any help.