local views

[csvideo]

I have a project with two forms one has local views in the DE the other uses the SELECT statement. If I run the form with the local views in one instance of VFP and then try to run the form with the SELECT statement in the init I get and error message saying

"Database c:\sales\data\salesclerk.dbc : File Access Denied"


Does the local views open the database exclusively?

I placed set exclusive off in the DE beforetableopen method with no sucess. HELP ANYONE?

 

[DEDMOD]

You may need to check the SET EXCLUSIVE setting on your system. Here's what it says in the help files under OPEN DATABASE for the SHARED option

"SHARED
Opens the database in shared mode. If you open the database for shared use, other users have access to it. If you do not include EXCLUSIVE or SHARED, the current SET EXCLUSIVE setting determines how the database is opened. "

Since the default global setting is to have SET EXCLUSIVE ON, that's probably what you have. Changing it later, after the database is open won't change the status of the database already open. Dave Dardinger

 

[csvideo]

Thanks! I forgot about that tools->option stuff. i'm not using my usual computer right now.

what would i do without this site.

 

[rgbean]

If this doesn't fix your problem, you may want to read the discussion on the Fox Wiki (

http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews~VFP)

on multiuser use of views and the potential problems.

Rick