Re: how closing open dbf file?

Tech-Archive recommends: Fix windows errors by optimizing your registry

OK - Third Thought, now that I've re-read your post a few times.
So you got a vfp-compiled app that generates this file, you run this exe on
the task scheduler in a computer.
As is, it over writes the file each time. It fails because your users have
the same file open.

I suggest you change your program a bit -
1. generate a unique file name.
2. pass the unique file name to some other program.

this'other program' will
1. clear all file locks and connections on the current file.
2. copy the newly generated file (name given during invocation as
parameter) to the current production area.

What are your thoughts?

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Patrick Tura" <patrick@xxxxxx> wrote in message
news:9C6F6992-9DBC-4BBA-B0C4-484C4AFDE293@xxxxxxxxxxxxxxxx
Hi!

I have a freetable that is open by more than one users to look at result
of
thier performance.

I wanted this table to be updated every hour in our server but however, if
somebody is keeping this freetable file open my sql query that will save
and update the result into freetable cannnot overwrite the .dbf file while
it is open.
cannot overwrite freetable file(.dbf)

I need to close this freetable before starting my sql-query to be able to
update the freetable every hour...

Anybody, can help me.

Our server is Windows Server 2003. I have my foxpro sql-query prg running
on
schedule...

Thanks.

/patrick



.

Relevant Pages

  • Re: how closing open dbf file?
    ... copy your newly generated file to the proper place with the proper name. ... and update the result into freetable cannnot overwrite the .dbf file while ... Our server is Windows Server 2003. ... I have my foxpro sql-query prg running ...
    (microsoft.public.fox.programmer.exchange)
  • how closing open dbf file?
    ... I have a freetable that is open by more than one users to look at result of thier performance. ... I wanted this table to be updated every hour in our server but however, if somebody is keeping this freetable file open my sql query that will save and update the result into freetable cannnot overwrite the .dbf file while it is open. ... I have my foxpro sql-query prg running on schedule... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: how closing open dbf file?
    ... You can close an alias via USE command, ... I wanted this table to be updated every hour in our server but however, if somebody is keeping this freetable file open my sql query that will save and update the result into freetable cannnot overwrite the .dbf file while it is open. ... I have my foxpro sql-query prg running on schedule... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: how closing open dbf file?
    ... The usage for the server is 'full rights' .. ... Switch back to record inserts and updates, ... and update the result into freetable cannnot overwrite the .dbf file while ... I have my foxpro sql-query prg running ...
    (microsoft.public.fox.programmer.exchange)
  • Re: how closing open dbf file?
    ... My Clock? ... I'm just happy the post is accepted by the News Server and actually posted. ... > Switch back to record inserts and updates, ... I have my foxpro sql-query prg ...
    (microsoft.public.fox.programmer.exchange)