Problem with .EXE file

[EKC]

Hi,
I have strange problem and being new to VFP ,I need help on this.I made project that contains form on which user enter date criteria and he gets report (Very simple).

The problem is that when I made .exe file,it runs only from the folder when project files are and when I try to run it from another location I have displayed Open dialog box asking me to locate .dbf file.If I dissmis it I have msg "Table Cust.dbf doesn't exist!".
Because I couldnt access tables from the database (Access denied),the only way was to copy .dbf files(tables nedded for report )in the folder i made my project as well as .DBC file.I guess that way I have this problem but I don't any other way.
The database and tables I try to use in my project are used by everyone and Network Administrator didn't put any restrictions on tables or dbc files.

Any help appreciated,
Lyn

 

[ramani]

you have to set the path to your database in your programe.

Example:

SET DEFAULT TO JUSTPATH(SYS(16,0))
SET PATH TO SET("PATH&quot+";"+"MyData\"

This will fix the problem, I hope

ramani

 

[ramani]

1. If the access is read only (Obvious since you are able to copy from server), you can open the files read only fom the server location. This could solve your problem of needing to copy from server to your location.
USE xxx IN nn ALIAS xxx NOUPDATE

2. You can write your temporary files in your local dive.