corrupt data?

[unit213]

I have a form where a user enters some basic information which populates the table below.
Periodically, a record appears to become corrupted. I'm unable to delete that particular row of data for some reason. Any idea what might be causing this?

See below for an example:

Thanks!

 

[SydneyGeek]

Try importing everything into a new, blank database, then compact & repair.

If you haven't split the database, do it. That way you separate data from logic; if something goes wrong it is mostly with the forms / reports. You can use a backup of the front end database and not lost your data.

Denis

 

[unit213]

Try importing everything into a new, blank database, then compact & repair.

The database has been compacted and repaired.

If you haven't split the database, do it. That way you separate data from logic; if something goes wrong it is mostly with the forms / reports. You can use a backup of the front end database and not lost your data.

I understand the concept of splitting the database, but I haven't done that before. What does that entail?

Thanks for the help Denis. It's greatly appreciated.

- Dan

 

[unit213]

I missed the part about importing everything into a new database. I'll do that also.

 

[boblarson]

Check this out:

Split Database

 

[unit213]

Check this out:

Split Database

Thanks Bob! I'll check it out. It looks pretty straight forward.