Record Nav Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was having a record nav problem when going to a record based on a selection
in a combo. From an earlier post I found my problem was corrupted indexes.

I did the repair process for fixing the corrupted tables in code. This
solved my problem imediately.

Once I recreated my relationships however (with referential integrity) the
problem arose again. Can I create my relationships without corrupting the
tables?

TIA,
TimJ
 
Perhaps there is some data which is orphaned and won't conform to
referential integrity. Run a query using the Unmatched Query Wizard and copy
that data to a new empty table, then delete it from the original table. Then
do another Repair & Compact

Another possibility is that you either didn't fix all the corruption or you
have re-corrupted the data.

Data corruption is almost always caused by data write interruption. That can
be caused by:

1. Users turning off a machine without closing down properly.
2. Flakey video card or drivers
3. Bad NIC card
4. Bad sectors or failing hard drive.

Try and find the cause before it corrupts irreparably.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top