Dear all,
after an unorthodox shut down of my computer (good old Windows error), I found out that my database file got damaged. Though I still have got access to the data, the file is useless. (The back-up was overwritten as well...)
Since the data aren't lost, I decided to make a new file, copying the entries. This worked well apart from following:
In the original database all entries in the tables were auto-numbered (= primary key), and those numbers were used to refer to other entries in other tables.
Now, in the new database I could only retain either the original numbering (but not as auto-numbered), or automatically renumber all entries (with catastrophical consequences for my database relations).
Is there a way to continue working the new database with the original data ánd to let the computer continue the number-giving?
I would be very grateful for your help :-)