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

CultLeaderZeroAsked:
Who is Participating?
 
SteveBayCommented:
Hmm. well that's not very helpful at all. Have you tried opening it with any other applications like say Paradox?
0
 
SteveBayCommented:
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

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

This is the correct path to the dbf file.
0
 
CultLeaderZeroAuthor Commented:
I found the error. I need the appropriate dll, SDECDX61.dll, to use Foxpro files.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.