>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.
What is Your working directory?
Your path-directive is not correct. You have a coma between the paths but You need ";"
Try to
SET PATH TO E:\EMPLOYEE; E:\EMPLOYEE\DATA
This.Cursor1.cursorsource = "E:\employee\data\payhrs.dbf"
This.Cursor3.CursorSource = "E:\Employee\Data\Absntcde.dbf"
activate SCREEN
? set("PATH")
BTW. I wouldn't work with hardcoded paths, but I guess You do this to track the f... Error