data entry doesn't work

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

Guest

I have a form based on a query. It was working beautifully and allowing data
entry with no problem. There was a problem and I repaired the database and
now neither the form or the query will allow data entry. No changes were
made to either the form or the query, and all properties are set to Yes for
data entry. What's wrong?
 
Does the query join 2 or more tables? If so you need a relationship set up in
the Relationship Window with Referiential Integrity turned on between the
tables in the query. Chances are that the repair removed this relationship or
you now have data which would not allow RI to be turned on.

It's also possible that the repair didn't fix everything and you still have
a corruption problem. Tony Toews has an excellent web page on database
corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp
 
I believe the second is true. I do have data which does not allow RI to be
turned on. I read through some of the links you provided, but didn't see
anything specifically regarding that. I also tried to repair and compact and
now that query in question shows nothing (the backed up one has results from
the query). I have yet to export to a new database as suggested in one of
those links, but before I go on, is there another way to change the
relationship issue to show the RI?

Thanks.
 
Back
Top