Data not editable since upgrade from Access 2 to XP

  • Thread starter Thread starter GVaught
  • Start date Start date
G

GVaught

When you are dealing with a main form /sub form the two forms are related
through a common field. The primary key of tbl1 (main form) should also be
in tbl2 as the foreign key. It is possible that you need to reset this
master/child relationship back into the two forms. Open the main form and
open form properties, then click on the little square in the upper left the
properties box should change to show you how the two forms are related. If
the keys are incorrect, then this is your problem. Associate the primary key
of the main table (tbl1) with the same key name in tbl2.

If you have not matching key in tbl2, then you need to create one to get the
relationship back on track. Also check the relationships in the relationship
window and make sure all tables are related correctly. If you are not
familiar with relationships, then you need to read up on these topics:
normalization, referential integrity, and database relationships.
 
I just had to convert a former employers database (That I learned MS
Access while being paid to write) from Access 2 to XP (Via 97 to help
with code conversion)

On one form the data is now not editable but it was in Access 2. The
form has a subform for notes. I can edit/delete/add to this subform but
cannot edit the main form data at all. It did work in Access 2.

The datasource for the form is based on a query with 2 tables joined.

tbl1 - Record always there - Always added first to tbl1 via
another form.
tbl2 - 1 to 1 relationship to tbl1 via JobNo field
Datasource relationship - Always show records in tbl1 and
those related in tbl2
I cannot edit date to be stored in tbl2 (whether the record
already exists in tbl2 or needs to be created)
I can edit the data in the table directly so it is not
a table issue
I can edit data in the subform so the form is not readonly

The only conceivable option is tht rules regarding queries as form
datasources has changed.

My question is has something, a rule of some sort, changed in regard to
queries as datasources for forms where there are two tables joined ni
the datasource?


Gavin
 
Back
Top