Home > Archive > FoxPro Help and Support > July 2005 > error file inuse









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author error file inuse
bijan

2005-07-21, 3:24 am

Hi
I have to exe program that use one table at one time
When I run first program and after that I run second program I got an error
file in use with another program how I can solve this problem I want run
multi program use one table
Thank you

Fred Taylor

2005-07-21, 3:24 am

SET EXCLUSIVE OFF

or

USE yourtable SHARED

--
Fred
Microsoft Visual FoxPro MVP


"bijan" <bijan@discussions.microsoft.com> wrote in message
news:DF1BD735-AB8F-4649-9BDF- 69A3B9B2C714@microso
ft.com...
> Hi
> I have to exe program that use one table at one time
> When I run first program and after that I run second program I got an
> error
> file in use with another program how I can solve this problem I want run
> multi program use one table
> Thank you
>



bijan

2005-07-21, 7:24 am

hi fred
how can i share my table .
could you explain what must i do
thankyou


Rick Bean

2005-07-21, 9:24 am

bijan,
I think Fred explained as best as he can without seeing your code. Only your
program is making the table non-shareable. By default, files are opened
EXCLUSIVE unless you do something in the program to override it. SET EXCLUSIVE
OFF or opening a file with SHARE are the two ways to accomplish this. Note: If
you use private data sessions, EXCLUSIVE ne4eds to be reset in each session.

Rick

"bijan" <bijan@discussions.microsoft.com> wrote in message
news:18F6A9A8-DA19-41C2-862E- 07679754932E@microso
ft.com...
> hi fred
> how can i share my table .
> could you explain what must i do
> thankyou
>
>


Fred Taylor

2005-07-21, 9:24 am

SET EXCLUSIVE OFF is the default for private datasessions, so no need to set
that in each session.

--
Fred
Microsoft Visual FoxPro MVP


"Rick Bean" < rgbean@unrealmelange
-inc.com> wrote in message
news:exvi9jfjFHA.2472@TK2MSFTNGP15.phx.gbl...
> bijan,
> I think Fred explained as best as he can without seeing your code. Only
> your program is making the table non-shareable. By default, files are
> opened EXCLUSIVE unless you do something in the program to override it.
> SET EXCLUSIVE OFF or opening a file with SHARE are the two ways to
> accomplish this. Note: If you use private data sessions, EXCLUSIVE ne4eds
> to be reset in each session.
>
> Rick
>
> "bijan" <bijan@discussions.microsoft.com> wrote in message
> news:18F6A9A8-DA19-41C2-862E- 07679754932E@microso
ft.com...
>



bijan

2005-07-22, 3:27 am

thank you it is working very good

"Fred Taylor" wrote:

> SET EXCLUSIVE OFF is the default for private datasessions, so no need to set
> that in each session.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Rick Bean" < rgbean@unrealmelange
-inc.com> wrote in message
> news:exvi9jfjFHA.2472@TK2MSFTNGP15.phx.gbl...
>
>
>

Rick Bean

2005-07-22, 9:26 am

Fred,
There you go reading the help file again! <vbg>

Rick

"Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
news:O1ceFPgjFHA.320@TK2MSFTNGP09.phx.gbl...
> SET EXCLUSIVE OFF is the default for private datasessions, so no need to set
> that in each session.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "Rick Bean" < rgbean@unrealmelange
-inc.com> wrote in message
> news:exvi9jfjFHA.2472@TK2MSFTNGP15.phx.gbl...
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com