Is it OK if I delete an record, then rewrite in table

  • Thread starter Thread starter joyo
  • Start date Start date
J

joyo

I have a couple of tables. Here is their relationship
1---many many--1
Table1 --- Table2 ---Table3
| 1
|
| many
Table4

All data is from one form and all controls are unbound.
When the user makes some changes for one record, I will
delete this record in table1, and table2 and table4
correspondent records would be deleted by Access too. Then
I rewrite everything into the tables. Do you think it is
OK. Is there any problems for this.

Thanks

joyo
 
All data is from one form and all controls are unbound.
When the user makes some changes for one record, I will
delete this record in table1, and table2 and table4
correspondent records would be deleted by Access too. Then
I rewrite everything into the tables. Do you think it is
OK. Is there any problems for this.
Click to expand...

I'd say it's risky. If you're deleting an arbitrary number of records
and reentering them, there is a risk that they won't all get reentered
(the computer might crash in the middle of the operation); at best
you'll have a very slow process and a rapidly-bloating database.

Why!? It seems a very convoluted way to work...

John W. Vinson[MVP]
(no longer chatting for now)
 
I'd say it's risky. If you're deleting an arbitrary
number of records and reentering them, there is a risk
that they won't all get reentered (the computer might
crash in the middle of the operation)

Could the whole thing possible be wrapped in a transaction
to make it safer?
 
number of records and reentering them, there is a risk
that they won't all get reentered (the computer might
crash in the middle of the operation)

Could the whole thing possible be wrapped in a transaction
to make it safer?
Click to expand...

Sure. Just an added complication to a process that does not appear (to
me) to be necessary in the first place though!

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top