Re: Need Help with adding multiple records to 1 table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Leaving an unsaved record exposes the database to corruption, period, no
matter how many folks are connected.

When you open a record, depending on how you "lock" it, the database can
lock the entire table, the data page on which the record is recorded (other
records could be affected), or the single record, or perhaps none at all.

To avoid holding a record open, you could consider using an unbound form and
letting the folks do their data entry throughout the day/shift. When
they're done, clicking <Save> would create a new record (you'd need to write
the code that pushes the data in the form to the record/table).

Good luck!

Jeff Boyce
<Access MVP>

"jkendrick75" <jkendrick75@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:013AE0EE-3523-49D4-B108-24EB6BB2AD0F@xxxxxxxxxxxxxxxx
> > I don't understand "sheets" -- are you referring to a spreadsheet, or to
> > sheets of paper?
> Sheets of Paper.
>
> > If users "start" a record (and save their initial info), then an
alternative
> > to holding that record open all shift would be to make it easy to
find/bring
> > up that record for final data entry at the end of the shift.
>
> I am planning on setting this part up. but initially they want to be able
> to enter in certain data throughout the shift. as there is usually only 1
to
> 2 people entering data at a time, data corruption should not be much of a
> problem. Does leaving the form open lock the table the form is attached
to?
> or does it only lock the records that are started? if the latter, then
> leaving the form open should not be a problem.
>
> I am also looking at doing a DAO recordset setup, but am having problems
> with setting up the arrays to save the data. any ideas on this part would
be
> great also.
>

.

Relevant Pages

  • Re: Leaving lock gates open
    ... : a) everyone leaving them open: least work ... The world in which I do my boating has all too many gates that have leaky top or bottom gates and BW resources that are stretched far too thinly to put any sort of priority on doing anything about it. ... I gave an example of a lock I encountered last week where the pound above would have been completely drained in 15 to 30 minutes had the top gates been left open. ...
    (uk.rec.waterways)
  • Re: Not sharing locks
    ... 65ton steel barge. ... layby, leaving me little space astern of him on the remaining layby. ... At the second lock when he did the same, I pointed out that it would ...
    (uk.rec.waterways)
  • Re: GL: Stupid writing
    ... then the whole struggle between and Jon and Sandy would not have ... But maybe I missed something else that explains why the police had gone ... was saying was not that there should not have been a lock on the door. ... would there be a lock that prevented someone from leaving? ...
    (rec.arts.tv.soaps.cbs)
  • Re: Catching a bite
    ... Satya wrote: ... Mike Andrews wrote: ... Or does it lock on, leaving the lights for the fixit guy? ...
    (alt.sysadmin.recovery)
  • Re: There Is No Control
    ... disenfranchise them, round them up, lock them up, whatever. ... The folks I meet at work and play, those folks I will debate with, ... I will support tolerance, ...
    (rec.equestrian)