Link to home
Start Free TrialLog in
Avatar of CultLeaderZero
CultLeaderZero

asked on

Error attempting to open TApolloTable dbf

I am using Delphi 7, Apollo VCL 6.1. I am getting the message that the code cannot open the file, even though the file is there. It is not open by any other application or user. The TApolloTable has a dbf file (USERS.dbf) as its source.
if dm.Table_Users.Exists then
  begin
    messagedlg('Users table exists',mtInformation,[mbOK],0);
  end;
 
  try
    dm.Table_Users.Open;
    dm.Table_Users.SetOrder(dm.table_Users.TagArea('USER_ID'));
  except  
    MessageDlg('Can''t Open the User List file',mtError,[mbOK],0);
    Close;
  end;

Open in new window

Avatar of SteveBay
SteveBay
Flag of United States of America image

Change exception handling code to find out what the exact error is:

  except  
    on e : exception do begin
    MessageDlg('Can''t Open the User List file:' + e.Message  ,mtError,[mbOK],0);
    Close;
    end;
  end;

Open in new window

Avatar of CultLeaderZero
CultLeaderZero

ASKER

The error message is 'Unable to open table: 'j:\paprless\txcdo\claims\users.dbf'.

This is the correct path to the dbf file.
ASKER CERTIFIED SOLUTION
Avatar of SteveBay
SteveBay
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I found the error. I need the appropriate dll, SDECDX61.dll, to use Foxpro files.