Append tables in a multi user environment
Posted on 2014-04-15
Main table with 7 linked tables.
I want to copy the main record wth all related data from the 7 sub tables to the same tables. (There will be a new main record ID and corresponding new id for the linking tables) I can get the procedure to work, my question is how will it respond in a multi user environment. If someone else is editing a record that is being copied what will happen? or does access just copy what is there regardless and append all info to all tables.
It is unlikely that someone will be editing that data but it is possible.