Problems running on a net work

[hag]

I have a user who installed on a network server.
OS is windows xp.
Administrator has no problem using the program but one user without adm. rights gets error messages that reflect the inability to open data bases.
The administrator can't figure out what to do to let a typical user open the program. He can't find anything that allow the user on opening the program as administrator rights as in windows 7.
Any ideas will be welcomed.

[James Bott]

The data and index files cannot be in the Program Files directory like they can under XP.

Regards,
James

[hag]

It is xp. I have programs on networks and all files in same directory. Can you send me some info on this. Doesn't make sense.

[James Bott]

Are you using:

SET DEFAULT TO (cDbfDir)

Without that, sometimes the app is looking in the wrong directory.

Regards,
James

[James Bott]

This info on "limited" accounts may also help:

http://vlaurie.com/computers2/Articles/xprunas.htm

James

[hag]

Thanks for the link. I sent it to the administator.

The program he is using is Not a multi user program so they all use it one at a time.
What is SET DEFAULT TO (cDbfDir)
cDbfDir ????

[James Bott]

Harvey,

The program he is using is Not a multi user program so they all use it one at a time.

I assume you have thought of this, but maybe one user is trying to run the program when it is already in use. The EXE would load but the DBFs would not open if they are already open in EXCLUSIVE use. This would error out.

What is SET DEFAULT TO (cDbfDir)
cDbfDir ????

This sets the directory where the data files are located. If they are in the same directory as the EXE then you can use:

set default to (cFilePath( GetModuleFileName( GetInstance() ) ))

This is better since the directory is not hard-coded so if the program is installed in another directory that the one intended, it will still work.

By default the EXE's directory is the one that is supposed to be used when the app looks for the dbf's (when no SET DEFAULT is used). However, I have had this fail a few times and never when I use SET DEFAULT TO.

Regards,
James

[StefanHaupt]

Harvey,

a normal user is not allowed to write in the programs folder, even not under XP. If you try to open a dbf in read/write mode, this will fail and you will get an error. If you don´t have admin rights, you have to separate the program from the data.

I suggest to move the data to the ProgramData folder instead (standard folder for data since XP) or better a subfolder in the ProgramData folder and set the path to your databases in your application with SET DEFAULT TO (cDbfDir) to this folder as James already said. This works fine for me since XP.

You can also install your software with all dbf in another folder, e.g. c:\myfolder and set read/write rights to this folder for the group "everyone". But this is no standard installation for XP, Vista, Win7, so it´s not recommended.