>>
>>>
>>>Is this on a network? If so, do you have rights in the directory? Could someone else possibly have the files when you are trying to open them? Is there a Data Environment on the forms? (Doncha just love people who an
>>
>>Are you sure that you have exclusive turned off as your program starts up. If you don't, then the views are "USING" the files exclusively.
>
>The files are all stored on a local drive. As the program is still being built, only I have access to the files. None of the entry forms use any tables in the dataenvironment except for completely unrelated verification fields to fill in list boxes.
>I just tried "set exclusive off" before opening the project, and it now allows me to open the forms, but when I attempt to open the tables shared (behind the add record button) I get File access denied. I have a feeling I know why this happens, but I don't know how to fix it. In the main form's data environment, the exclusive property for the view used to fill the grid is set to true, but it is 'greyed' out; it cannot be changed. How can I tell a view to open it's tables shared?
1) Have you tried something like this that checks for currently open files?
procedure opendbf
parameters dbname,dbalias
if empty(dbalias)
store dbname to dbalias
endif
if used(dbalias)
select (dbalias)
else
sele 0
use (dbname) again alias (dbalias) shared
endif
return
2)Have you tried setting the thisform.datasession property to 2-private ?