> I've used the comma before and had no problem in other applications
> for the SET PATH command, but as you say, it is most likely best to
> use the semi-colon. I did change the comma to a semi-colon, but this
> made no difference. I still have the same error.
OK, it was just a shot in the dark.
What's wondering me is that You get the error
can't find table X in E:\Employee.dbc
though it should be E:\Employee\Employee.dbc if I'm right. But it could be that Your working directory is E:\ and if VFP does not find anything it falls back to that. I know it sounds rediculous but, could You doublecheck the locations and if the files *are* there.
Did You try to completely comment the BeforeTable() out and set the path before You call the form (i.e. in the application's startup program.
Ah... another idea. If You work with tables that are members of a database, I think "CursorSource" does not have a path at all as the Database knows where its tables are.... wait... I'll look it up somewhere in my code ... Yep! If you have a table that belongs to a database. You have the path with the Database = ... but You do NOT have a path with CursorSource.
So the code should be:
SET PATH TO E:\EMPLOYEE; E:\EMPLOYEE\DATA
this.Cursor1.Database = "E:\employee\Employee.dbc"
This.Cursor1.cursorsource = "payhrs"
this.Cursor3.Database = this.Cursor1.DataBase
This.Cursor3.CursorSource = "Absntcde"
Could You try that?