I've inherited a system that was designed by someone with no
understanding of database design. From the logical design point of
view, there is no logical design. The physical design is a nightmare.
e.g. there are no relationships between tables and foreign keys appear
to have been sprinkled at random like confetti. As an example, the
Employer - Employee - Contract - Expense hierarchy has EmployerID in
the Expense table. That's the background.
Someone has deleted a Contract record. I need to re-create it with the
same ContractID, an Autonumber field. I can open the table in design
view, change the Autonumber to a Long, go to datasheet view and add
the new record. Then if I open the table in design view, do a save as
with another name, change the key field in the new table back to an
Autonumber, I can run an append query to copy all the records from the
old table to the new one while keeping the Autonumber field values. A
bit of table re-naming, and we've got the old record restored.
I've tested it and it seems to work OK.
Are there any problems with this?
Regards,
Richard.
--
Regards.
Richard.