Writing to multiple tables

[AJordan]

I was thinking of ways to ensure back up of data, and I wondered if there is away to write data to more than one table at the same time. If not what is the best way to accomplsih something like this? Basically if the network crashed could data written to a local table be used as a potential mitigator.

So 5 computers on a network, network crashes, the tables on the 5 local machines can be appended to one another if the data was needed urgently.

 

[ajetrumpet]

i dont have a lot of experience with networks, but why do you want to ? shouldnt the data be stored on a server somewhere ? shouldnt that data be backed up once in a while off of the server anyway ?

just a guess, but I dont think the need to consolidate local tables should ever be present, but like i said, myy experience is limited .

 

[llkhoutx]

You can do that but will probably have trouble with primary key duplication. Generate primary keys manually with an identifier such as "computer name."