database containers

[choppysuey]

I'm using VFP 6.0 and have several questions concerning the use of database containers. If I issue the following command: open database mydatabase exclusive
this shouldn't affect the opening of the tables attached to this database container should it even though the dbc is opened exclusive somewhere? This is normal behavior? In addition if I open a database exclusive how come in another instance of VFP I can issue open database mydatabase shared? and then I can follow this command with open database mydatabase exclusive and generate no errors? What's up with that? I know nobody would do this but I'm still a newbie and am trying to figure VFP out. Opening a table exclusive prevents anyone else from accessing it but it's not the case with database containers?

I have a small network at home and when I created a dbc and added tables to it, I couldn't open those tables anymore on my other machine by issuing the use mytable in 0 shared command. It kept telling me that access was denied to the dbc. After closing everthing and opening the project again, I can access the tables from my other machine fine.

Any feedback to these probably simple questions would be greatly appreciated.

Thanks.

 

[Mike Lewis]

Choppysuey,

This is the behaviour I am seeing.

If you open a database exclusively, no-one else can open the database or any of its tables. If user A has a database open exclusively, and user B tries to open a table from the database, then user B's instance of VFP will automatically try to open the database as well, and will fail to do so.

I have just tried to reproduce the behaviour you described but cannot do so.

Mike




Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk