>>>
>>>>
>>>>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 ?

hmmmm......that was going to be *MY suggestion, although the error given is usually "File is in use"