Autonumber Field Causes Form To Close

  • Thread starter Thread starter Toby Young
  • Start date Start date
T

Toby Young

I have a MS Access DB on my computer which allows other
users to access database over a network. I do not
experience this problem on my computer, but on other's
computers, when they go to add a new record to a form,
access quits unexpectedly and prompts the user to back-up
the database. They do not get the same problem if the
data is added directly to the underlying table or if they
use datashhet view to enter the new record.

I removed the autonumber field from the form and now the
database does not crash. I have 2 subforms on this form
that use the autonumber field to link between the tables.

The problem is on the form only. Is there something I can
do to fix this problem? I have already switched to a
frontend/backend set-up over the network to try to
prevent corruption per a suggestion from the newsgroup.

Any help would be greatly appreciated.
 
Try to make sure that the Master and Child Link Fields, in
the properties of the the subform are correctly done. Also
make sure you have created the one-to-many relationship in
the between the underlining tables are.

Hope that helps!
 
Back
Top