JonnysDBnotworking
New member
- Local time
- Today, 07:23
- Joined
- Aug 14, 2020
- Messages
- 2
Hi All,
I have a split database which has worked fine for a while now however I needed to do a compact and repair on the BE around 20 days ago and didn't notice anything different at the time. I've now noticed there are some issues with Autonumbers and when comparing a working back end DB backup (21 days ago) with the current one there are primary keys missing and on one of the fields the "Indexed" has reverted to "No" from "Yes (No Duplicates)".
Is there any recommend way to append the last 20 days of data from the current database into the working backup, I've been looking at posts about appending queries but not having much luck.
Many thanks
I have a split database which has worked fine for a while now however I needed to do a compact and repair on the BE around 20 days ago and didn't notice anything different at the time. I've now noticed there are some issues with Autonumbers and when comparing a working back end DB backup (21 days ago) with the current one there are primary keys missing and on one of the fields the "Indexed" has reverted to "No" from "Yes (No Duplicates)".
Is there any recommend way to append the last 20 days of data from the current database into the working backup, I've been looking at posts about appending queries but not having much luck.
Many thanks