[AccessD] May need an Unbound form

John W. Colby jwcolby at colbyconsulting.com
Thu Mar 31 06:19:30 CST 2005


In fact I am attempting to do an unbound form.  I am going to go with a
brand new form instead of converting a bound form to unbound.  It was rather
late last night when I was doing this.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, March 31, 2005 2:26 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] May need an Unbound form


Hi John:

It looks like your 

AllowEdits False
AllowDeletes False
AllowAdds False
EditMode True

...settings are biting you? Maybe:

AllowEdits True
AllowDeletes False
AllowAdds True
EditMode True

...would work.

Barring that it is unbound forms for you.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Wednesday, March 30, 2005 10:26 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] May need an Unbound form

OK Guys,

WinXP, OfficeXP, all service packs applied for Windows as well as office.

I have a situation where a group of 2 to 6 or so people open a form of
people info, with contact subform, making phone calls all night.  These
people call therapists trying to fill employment contracts.  They may make
changes to the person info (address changes etc. but mostly they just enter
new contact records which consist of a simple date and employee (prefilled),
call status (left message, not interested etc,) and a memo field.  All night
long just mostly entering records in this contact subform.

The problem is that they are having HUGE locking issues.  I got rid of all
indexes, but they were still getting locks.  An employee will start an edit
(select a status, then fill in the memo etc.) but they may hold the record
in the edit state for a minute or two.  If any other employee tries to start
a new edit they get a lock, WITHOUT the lock symbol in the record selector.
It is reproducible, it always happens and it SUCKS.  These people are not
editing each others records, they are always building NEW records, but they
are getting these locks and it just killed their productivity.

I made a change such that as soon as they enter any data (after update of
any control), the record is saved.  That causes the new records to save
immediately as well as the edits during the course of business to save ASAP.
This helps but they are still seeing the locks occasionally, however now
they are seeing the lock symbol in the record selector.

I checked all the usual suspects, SPs, edit modes, compact / repair etc.  I
am just not finding the problem.  As far as I know this shouldn't be
happening, but it is.  Has anyone seen this behavior?  Solutions?

This leads me to consider (for the first time in my career) using an unbound
form for collecting the new data record so that the save just does a single
write of the entire record, one time, as the contact record is finished and
ready to store.  Needless to say this is not my forte and I the form is not
allowing new data to be entered.  The form itself is unbound, all the
controls are unbound, the modes are:

AllowEdits False
AllowDeletes False
AllowAdds False
EditMode True

This should allow all the controls to accept data but no control can accept
data.

I tried AllowEdits true and Editmode false, no help.  The form is not
locked, the controls are not locked. The form was opened originally from a
form which was passing in a filter if that means anything.  I was going to
grab the existing record data and then unbind the form but I am now just
looking at a plain Jane new data entry form.

Any suggestions gratefully accepted.

Thanks,

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list