Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Permissions on DBISAM Files
Tue, Aug 2 2011 3:51 PMPermanent Link

Gordon Turner

I'm using Delphi 7 and DBISAM 3.30.  All of a sudden (without any
updates to the application) I have several users receiving messages that
they are opening data files as Read-Only.  User have full access rights
to the folder and to the files in the folder.

Here is the code I'm using (which has been running fine for years)...

  with TDBISAMTable(Components[i]) do begin
    sStopWords := TextIndexStopWords;
    CheckDBIndexes(DBPath, TableName);
    Exclusive:=False;
    ReadOnly:=False;
    Open;
    if ReadOnly = True then begin
      MessageDlgCtr('You do not have the proper access to the TimeOff'
            + ' data files located in '
            + ExcludeTrailingBackslash(DBPath) + '.  You need a'
            + ' minimum of Modify, Read, and Write access to this'
            + ' folder.  Please check with your IT department to make'
            + ' sure you have the proper privileges.' + MsgCrLf
            + 'TimeOff will now close.', mtWarning, [mbOK], 0);
      ...
    end;
    ...
  end;

I am at a loss to explain why the users suddenly can no longer open data
files.  I've tried having them create a brand new data folder manually
and then letting the app re-create the files in the new folder, but it
fails after trying to create the first .DAT file.  I've tried creating a
folder locally (C:\Data) and on a file share with the same result.  I've
tried letting the app create the data folder with the same result.

I had one user send me a copy of the data files and I had no problem
opening them on my workstation.  As best I know, users are running XP - SP3.

Any help would be greatly appreciated.
Tue, Aug 2 2011 3:57 PMPermanent Link

Gordon Turner

Just to add on, the problem is spreading rapidly - from 3 customers
yesterday to 5 more today.
Wed, Aug 3 2011 3:21 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Gordon


With that spread it sounds like an AV update. Do they all run the same anti virus software?

Roy Lambert [Team Elevate]
Wed, Aug 3 2011 3:13 PMPermanent Link

Gordon Turner

On 8/3/2011 3:21 AM, Roy Lambert wrote:
>
> With that spread it sounds like an AV update. Do they all run the same anti virus software?

Difficult to say as they are different companies.  However
(interestingly enough) I have been using Armadillo (currently called
Software Passport I believe) as a part of my copy protection scheme
(this version of the program was released in October of 2009) and
removing the Armadillo wrapper seems to have resolved the problem.
Thu, Aug 4 2011 3:05 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Gordon

>Difficult to say as they are different companies. However
>(interestingly enough) I have been using Armadillo (currently called
>Software Passport I believe) as a part of my copy protection scheme
>(this version of the program was released in October of 2009) and
>removing the Armadillo wrapper seems to have resolved the problem.

Preventing them updating the data is pretty good protection Smiley

Roy Lambert [Team Elevate]
Fri, Aug 5 2011 5:59 PMPermanent Link

Gordon Turner

On 8/4/2011 3:05 AM, Roy Lambert wrote:
>
> Preventing them updating the data is pretty good protectionSmiley

Well, how else are you going to prevent those pesky data input errors?
Image