I have a form with a grid on it and the form uses a data environment as well. One of the tables is called "ABSNTCDE.DBF" and is located in E:\EMPLOYEE\DATA. The ABSNTCDE table is linked to a DBC called EMPLOYEE.DBC and it is located on E:\EMPLOYEE. When I start up the form, I get the following error:

Error instantiating cursor object.
Cannot find E:\Employee\Data\Absntcde.dbf in E:\Employee.dbc

I have opened the DBC file and did a MODI DATA to see if the ABSNTCDE table was linked and it is. I have also been able to open the ABSNTCDE table easily in the command window.

The following is the code I placed in the BeforeOpenTables Method.

SET PATH TO E:\EMPLOYEE,E:\EMPLOYEE\DATA
This.Cursor1.cursorsource = "E:\employee\data\payhrs.dbf"
This.Cursor3.CursorSource = "E:\Employee\Data\Absntcde.dbf"

No matter what I do, I keep getting the same error that it cannot find the table in the database. I ran the "repair database" also.