Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Check if Database has full Read/Write access?
Wed, Apr 16 2008 12:45 AMPermanent Link

Dave
I have noticed that DBISAM picks up that a Database has Read Only access.

If a folder with the database files only has read access can DBISAM advise the
user or using a method in DBISAM can we check if a table only has Read Access
caused by folder sharing restrictions?

Just trying to let the user know before the try to add data?

Thanks
Wed, Apr 16 2008 8:44 AMPermanent Link

Rolf Frei

eicom GmbH

You can check the ReadOnly Property of TDBSIAMQuery/TDBISAMTable or you can
handle the DBSIAM error 11010 (Access deniend).

But any connected controls to such a readonly Query/Table will not be
editable at all. So you must not much do about that. DBISAM makes such
Datasets automaticly ReadOnly if the file ist readonly, but it doesn't
respect the ACL's as far I know. So if the file has not set the Readonly
flag, but has an ACL with Readonly, you must handle the 11010 error, as this
situtaion does not make any TDBSIAMDataset readonly.

Regards
Rolf


"Dave" <david@itfx.com.au> schrieb im Newsbeitrag
news:A83670F0-5F8D-4F55-86A9-3CEE148067F8@news.elevatesoft.com...
>I have noticed that DBISAM picks up that a Database has Read Only access.
>
> If a folder with the database files only has read access can DBISAM advise
> the
> user or using a method in DBISAM can we check if a table only has Read
> Access
> caused by folder sharing restrictions?
>
> Just trying to let the user know before the try to add data?
>
> Thanks
>

Thu, Apr 17 2008 3:41 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rolf,

<< But any connected controls to such a readonly Query/Table will not be
editable at all. So you must not much do about that. DBISAM makes such
Datasets automaticly ReadOnly if the file ist readonly, but it doesn't
respect the ACL's as far I know. So if the file has not set the Readonly
flag, but has an ACL with Readonly, you must handle the 11010 error, as this
situtaion does not make any TDBSIAMDataset readonly. >>

DBISAM 4 should handle the ACLs automatically - if it can't open a table
read-write given the current user, then it reverts back to read-only.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Apr 22 2008 10:09 AMPermanent Link

Rolf Frei

eicom GmbH

Ah, thank you for the clarification.

Rgerds
Rolf

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schrieb im
Newsbeitrag
news:BAA0B24D-406A-4FB4-BE97-2117984CB981@news.elevatesoft.com...
> Rolf,
>
> << But any connected controls to such a readonly Query/Table will not be
> editable at all. So you must not much do about that. DBISAM makes such
> Datasets automaticly ReadOnly if the file ist readonly, but it doesn't
> respect the ACL's as far I know. So if the file has not set the Readonly
> flag, but has an ACL with Readonly, you must handle the 11010 error, as
> this situtaion does not make any TDBSIAMDataset readonly. >>
>
> DBISAM 4 should handle the ACLs automatically - if it can't open a table
> read-write given the current user, then it reverts back to read-only.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Image