Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: elpintado de colores
  Where is elpintado de colores?
 elpintado de colores
Subject: RE: Someone is messing with my data
Thread ID: 22214 Message ID: 22218 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: Forms
Date: Saturday, April 12, 2003 2:27:03 AM         

> Hey guys
> This is weird, I use databases (.DBF) at work. But the last form I made can't run beacuse it says that a certain DBF is allradey in use.
> I do: close all data, clear all, and shut down; but when I want to test the form it still displays that error.
> How can I make this go away, bacuse I'm sure the DBF is not in use.
> I call the DBF in the "LOAD" of the form with a "use ******.DBF shared"
> Hope you can help me out.

I know this may sound basic, but......

In the VFP development environment with the project loaded can you use the table
from the command window and open it... this is first thing to try.

I judge this is a muti-user application... and if you copy the database container and tables
down to your local harddrive can you open the table there, and prove it only fails on the
network ?

If you "DO FORM MYform" at the command window can you load the form and run it
without the problem ?

Actually if you have the table as shared, multi-access should be available.

Question, why are you opening the table in the Load event....? Why not add it to your
forms data environment with buffering=5 and let the form look after the mechanics ??

Let me know !

Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Someone is messing with my data Posted by elpintado de colores @ 4/11/2003 10:32:04 PM
RE: Someone is messing with my data Posted by Pete Sass @ 4/12/2003 2:27:03 AM
RE: Someone is messing with my data Posted by elpintado de colores @ 4/14/2003 11:06:34 PM