Datasheet subforms

[Guest]

Got a recurring problem with a form that contains 2 datasheet style subforms.
Can't pinpoint it but every so often it will not allow you to enter a new
record in the subform, locks the record and it can only be rectified by
reinstalling the database. This seems to coincide with converting over to
Access 2003. Does anyone know of any issues in 2003 that might explain
this????

 

[Guest]

it can only be rectified by reinstalling the database.
I do not understand your term "reinstalling the database." Just how do you
do this?

Are your Master/Child links correct and are you using a cascade update in
your relationship?

 

[Guest]

Karl,

By 'reinstalling the database' I mean that I have split the database and
need to restore to the master front-end .mdb file.

Yes the Master/Child links are correct and the relationship is using cascade
update.

I might add that this doesn't happen very often, and seems to only lock the
current record - the user can close the form and open a different record and
everything works fine???

It sounds like I might need to provide a lot more detail but was just hoping
that someone might know of some known issue.

 

[Guest]

Yes the Master/Child links are correct and the relationship is using
cascade update.
The Master/Child links I was talking about are those in the form/subform.
It sounds like you are talking about between tables.

 

[Guest]

No, I was talking about the form/subform links. The main form has table 'A'
as a recordsource which has an auto-number field which is also the primary
key. The subform has a recordsource of a separate table 'B' with the same
field as in table 'A' (but obviously not auto-number). There is a one-to-many
relationship (A to B). The master/child links use this field, and it works
fine for the vast majority of records, but for some reason (and I've yet to
determine any pattern that leads to this error) it occassionally 'corrupts'
for want of a better word.