A
Allen Browne
In case someone is searching for reasons why combos/list boxes may not show
any records, here's a strange one.
After repairing the back end and re-creating some relationships, some of the
combos in the front end were not populating. The solution ended up being to
run a compact/repair on the front end.
That's not something I think to do very often, particularly in an MDE with
no temp tables. I am guesing that the compact/repair changes the cached
information Access holds about linked tables, and that this in turn affects
the queries based on the linked tables.
If that guess is correct, then a compact/repair of the front end might be
important after any changes to the back end. Anyone have experiences that
confirm or negate that guess?
(Observed in Access 2003, 2000 file format, JET 4 SP8.)
any records, here's a strange one.
After repairing the back end and re-creating some relationships, some of the
combos in the front end were not populating. The solution ended up being to
run a compact/repair on the front end.
That's not something I think to do very often, particularly in an MDE with
no temp tables. I am guesing that the compact/repair changes the cached
information Access holds about linked tables, and that this in turn affects
the queries based on the linked tables.
If that guess is correct, then a compact/repair of the front end might be
important after any changes to the back end. Anyone have experiences that
confirm or negate that guess?
(Observed in Access 2003, 2000 file format, JET 4 SP8.)