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
Ron Seidl
Independent Developer
VFP
"I'm playing in life's theater in anticipation of a great cast party!"