access denied

[DanNorris2000]

Used Project/Build to create an .exe on a server. Then placed a shortcut to that exe on several PC's. When I try to run forms(doesnt have to be same form)on 2 pc's at the same time I get access denied errors. I have checked to see that exclusive is false in the DE for each table.
Thanks

 

[skoko]

How u open database? Need to be shared also.

 

[DanNorris2000]

We are using the Data Environment in each form

 

[danceman]

this may be a foolish question, are the forms internal to the exe or external? Attitude is Everything

 

[DanNorris2000]

The forms are included in the exe if that is what you mean

 

[EzLogic]

But, when you run the form on 1 pc at a time, it is working ok??? Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[DanNorris2000]

Yes

 

[GriffMG]

Is your server NT? Regards

Griff
Keep [Smile]ing

 

[skoko]

Did u try to open database (not tables) shared?

 

[GriffMG]

NT uses op' file locking - particularly on small files.

Create two registry merge files and add the keys to your registries on the w/s and server:


On workstations use this

REGEDIT4

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters]
"EnableOplockForceClose"=dword:00000001
"EnableOplocks"=dword:00000000

On server use this:

REGEDIT4

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkStation\Parameters]
"EnableOplockForceClose"=dword:00000001
"EnableOplocks"=dword:00000000
"UseOpportunisticLocking"=dword:00000000


HTH Regards

Griff
Keep [Smile]ing

 

[DanNorris2000]

I found the problem. One of the tables in the DE was set to exclusive .T. changing it to .F. solves the access problem but, how do I (in code) change it to temporarily be exclusive so that it may be zapped? I tried

Select tmpcash
Set exclusive on
Zap
Set exclusive off

but this does not work, error says file needs to be exclusive
Thanks

 

[EzLogic]

do you have any codes in the init event or load event of the form, that deals with data management???? Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[DanNorris2000]

I am not using NT, this is running on a novell 3.2 server with win98 and ME pc's

 

[DanNorris2000]

I do not have any code in the init event related to data management

 

[GriffMG]

Dan,

If it's netware 3.12 then op locks ain't your problem!
Sounds like you've got it sorted anyhow... good luck

Regards

Griff
Keep [Smile]ing

 

[DanNorris2000]

I still have a coding issue(see above) , if anyone can help

 

[skoko]

Dan already explain you. Please read.

 

[skoko]

Oops.
Try first to close table, and then reopen it as exclusive, or, u can use DELETE NEXT XXX to delete all.

 

[DanNorris2000]

That will mark the records for deletion , but I will still need to pack and will need the file as exclusive at some point

 

[skoko]

Sure, like I say. When u decide to pack, or to zap or whatever just close database and reopen exclusive.

CLOSE DATABASES
OPEN DATABASE \\server\name.dbc EXCLUSIVE
USE table EXCLUSIVE
ZAP