Sharing database problem. 1

[rianeiromiron]

Hello there!

I have the following problem, but first I'll describe my working environment:

Novell Netware network
Users running Windows 2000
The machine I use for devoloping applications has Win98.
Users run VFP 6.0 .EXEs files from .EXE main program.

Here's the problem:

When a program (user) opens a table that belongs to a database, the table will no longer be available to other users. That is, if user A opens table TB1 and user B tries to open TB1, B receives a "File access denied" message.

What I did to try to fix the problem was:

1) SET EXCL OFF in user A program (Did not work)
2) Open the table using USE TB1 SHARED (Did not work)
3) Explicitly open the database using OPEN DATABASE MY_DATABASE SHARED (Did not work)

The file attribute for the files I'm opening is set to shared by Novell.

Can anyone help?
Thanks in advance

Rianeiro

 

[jwstockwell]

Can you open the table from two instances of Fox from your machine? i.e. use your step 1 then step 2 from the command line in both instances?

 

[rgbean]

Rianeiro,

Any chance you are using forms with private datasessions? Remember there are a number of SET values that are reset to default values for each datasession. According to the help, EXCLUSIVE defaults to ON for the global datasession, and OFF for private datasessions. (For other SETs that are effected by a datasession see the topic SET DATASESSION Command.) So depending on where you SET EXCLU OFF, it may be not be doing what you are expecting.

Also, if you are using any kind of framework check to see what it says about it's forms defaults.

Rick

 

[rianeiromiron]

Thanks a lot to both of you. I haven't been able to try your suggestions because of some unexpected duties buy I'll notify you as soon as posible.

Thank you, you are always helpful.

Rianeiro