I had a strange thing happen in my split database.
Some of my subforms records were not in order. The parent form was fine but the subform would show the last record first.
Both forms had tables for record sources. There was no sorting on the forms.
I tried everything..... a couple hours actually of work, trying to fix it.
A finally brought the tables back in the to database to work on it as a non-split database.
Once I compacted it, everything was fine.
I went back to the split database and compacted, but it still had the problem.
I tried looking a many things and compacted the database many times as I was working on it.
A few minutes ago, everyone left so no one was in the split database, just me.
I compacted again and....the problem went away!
Are there some things that 'Compact & Repair Database' does not do when the Back End is being used by others in a split database?
Some of my subforms records were not in order. The parent form was fine but the subform would show the last record first.
Both forms had tables for record sources. There was no sorting on the forms.
I tried everything..... a couple hours actually of work, trying to fix it.
A finally brought the tables back in the to database to work on it as a non-split database.
Once I compacted it, everything was fine.
I went back to the split database and compacted, but it still had the problem.
I tried looking a many things and compacted the database many times as I was working on it.
A few minutes ago, everyone left so no one was in the split database, just me.
I compacted again and....the problem went away!
Are there some things that 'Compact & Repair Database' does not do when the Back End is being used by others in a split database?