Add SET EXCLUSIVE OFF so table is opened shared.
>I am getting a 1705 error "can't open database" when opening a form that has a single grid with the datasource specified in the grid recordsource property. The program works fine with no errors when running in the main Foxpro window, but when I compile it and put it on the network I get the error. The network locaiton uses a separate copy of the data table. But it should not be locked. I canopen that data table from the command window with no problems. Is I delete that table and the program creates it and populates it with a SQL select, the form opens fine, but the next time I call the form. the table reports as the 1705 error, can;t read the table. I error trapped that error and fur sure the grid loads empty, no data. Has anyone seen this before?
>
>TIA
--sb--