[AccessD] can't select data in control when AllowEdit false

Asger Blond ab-mi at post3.tele.dk
Fri Sep 10 09:09:59 CDT 2010


Right, that's why I recommended this for a single user db, supposing that the db in this case is stored on the local box.
Just made a quick test with a 2 mio recordset stored locally and I didn't notice any difference as to opening time for a Snapshot versus a Dynaset.
Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman
Sendt: 10. september 2010 15:47
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] can't select data in control when AllowEdit false


<<Now that is a solution to think about!>>

  Probably not; snapshots are a major performance hit. With a snapshot, your
asking JET to make a complete copy locally of everything that is in the
recordset.  If your pulling that over the wire, that will take some time.

  Only place this would work well is if the recordsets were very small
(dozen or so records at best).

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, September 10, 2010 8:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] can't select data in control when AllowEdit false

Asger,

Now that is a solution to think about!

I will have to take a look at whether my code can do that to the form as the
form opens. My PLSS 
reads information about what groups are allowed to perform the various
activities in a form.  While 
it seems unlikely to occur in real life, the objective is to easily and
intuitively allow specific 
groups to have the authority to add, delete and edit records.

In theory a group could be allowed to delete or add, but not allowed to
edit.  A snapshot would 
prevent the edit but would also prevent the add or delete (I think).

John W. Colby
www.ColbyConsulting.com

On 9/10/2010 8:27 AM, Asger Blond wrote:
> John,
> If this is not a multiuser db you could set the forms Recordset Type to
Snapshot, which will effectively prevent edits but leave all controls
selectable.
> Asge
>
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af jwcolby
> Sendt: 10. september 2010 13:42
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] can't select data in control when AllowEdit false
>
> Yes, that is a workaround, and I have used that workaround.
>
> Now you have a form with 200 controls on it...
>
> In the specific case I just ran into, the form itself is bound, but I have
a list box that I
> populate programmatically that is not bound to any data field.  I want to
not allow the user to edit
> the data in the form, but select one or more items in the list in order to
push a button to cause
> something to happen.  Setting the form.AllowEdit false locks my list, even
though the list is not
> even bound to data.
>
> Silly in my humble opinion.
>
> I am writing a Presentation Level Security System.  It is not uncommon to
want to prevent the user
> from editing the data in the form and yet perform activities on the form.
But with the Access
> system, if I just set the AllowEdits false it pretty much locks down the
form.  NOT my intention!
>
> So now I have to decide whether the user will be wanting to perform some
activity on the form and
> NOT set the AllowEdits property but instead lock down just the controls
that can modify the data.
>
> Pretty darned silly in my humble opinion.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 9/10/2010 7:06 AM, Stuart McLachlan wrote:
>> Set the form to allow edits but set individual controls to Enabled = Yes
and Locked = Yes?
>>
>> On 10 Sep 2010 at 6:37, jwcolby wrote:
>>
>>> I had forgotten this.
>>>
>>> Is there a way around it?  It is not uncommon to not allow the user to
>>> edit the form's underlying record and yet need to click a button or
>>> select an item from a list.
>>>
>>> --
>>> John W. Colby
>>> www.ColbyConsulting.com
>>> --
>>> 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


-- 
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