Data in Table does not display in Form of split database

[Guest]

Hi
I have a database (Office2003) that I have split manually on a Win2003
server for use by XP (SP2) users on a network. The front- and back-end
portions are stored in a shared location with Modify rights to users. A
shortcut to the front-end is the only portion that the users actually see.

Until recently the database was working fine meaning, students could see
data in one form, add a record in another and then view the data they entered
in a third form. These 3 forms are accessible using a another form with
command buttons.

Now, I can still see the table data in the back-end database, however, I
cannot view it in the form in the front-end database. I can add a record and
I can view initial sample records no problem, it is the records that the
students have added, that I cannot view afterwards. (although the data is
definitely in the table of the back-end).

I have tried the following:
--re-split the database from the original empty db and then imported the
data from the back-end
--detect and repair of ms access

I do not receive any error message - simply, when the form opens to view the
records the students have added, I see one blank record.

Any suggestions as to what I should do next?

Laurie

 

[Douglas J Steele]

Have you possibly set the form's DataEntry property to True? Doing so means
that the form opens showing only a blank record.

 

[Guest]

Ok, when I change this property, I can see the records that have been added,
but I can no longer add a new record when I click "Add a Record" on the
switchboard.
I will try making a copy of the form - where one can add/edit records and
the other is just for viewing... ???

 

[Douglas J Steele]

Forms have properties for AllowAdditions, AllowDeletions and AllowEdits that
you can toggle.

 

[Guest]

I think I have it sorted out now. I just don't understand how it got messed
up in the first place. An error message might have helped me to troubleshoot
this one a little quicker.

Thanks for your help.

Laurie