I have a situation where "File Access is denied" shows up any time I try to open the main form in my current project. I'm running Windows 10 and when I get into File Explorer I can open both the .SCT and the .SCX files from notepad without a problem. If I double click on either one VFP opens, attempts to open the file, and throws the error message.
VFP opens other screen files without a problem so it seems there must be a problem with that specific file inside VFP. I tried opening the .SCX as a table and got the error too.
Any ideas about why this is happening and how to get around it will be most welcome!
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Joe Yoder wrote on 2016-05-05:
I have a situation where "File Access is denied" shows up any time I try
to
open the main form in my current project. I'm running Windows 10 and
when
I get into File Explorer I can open both the .SCT and the .SCX files from notepad without a problem. If I double click on either one VFP opens, attempts to open the file, and throws the error message.
VFP opens other screen files without a problem so it seems there must be
a
problem with that specific file inside VFP. I tried opening the .SCX as
a
table and got the error too.
Any ideas about why this is happening and how to get around it will be
most
welcome!
Thanks in advance,
Joe
Joe,
VFP will open the files exclusive. Notepad will not. Did you try to use the SCX as a table with the SHARE clause?
Do you have a process open or hung that still has the form open?
Tracy Pearson PowerChurch Software
Thanks Tracy,
I tried using with the share clause and it worked without error. I renamed the files and the same files with different names continued to give the error, I restarted the computer and the problem went away!
I'm glad to have my code back but am still puzzled about what was happening,
Thanks again,
Joe
On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson tracy@powerchurch.com wrote:
Joe Yoder wrote on 2016-05-05:
I have a situation where "File Access is denied" shows up any time I try
to
open the main form in my current project. I'm running Windows 10 and
when
I get into File Explorer I can open both the .SCT and the .SCX files
from
notepad without a problem. If I double click on either one VFP opens, attempts to open the file, and throws the error message.
VFP opens other screen files without a problem so it seems there must be
a
problem with that specific file inside VFP. I tried opening the .SCX as
a
table and got the error too.
Any ideas about why this is happening and how to get around it will be
most
welcome!
Thanks in advance,
Joe
Joe,
VFP will open the files exclusive. Notepad will not. Did you try to use the SCX as a table with the SHARE clause?
Do you have a process open or hung that still has the form open?
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
I guess you crashed the form at some stage and the .scx/sct table was left open somewhere hence not being able to open it. The open file could also be in another instance of VFP which isn't displayed because it has gone rogue at some stage and doesn't present a visual interface.
I have had this happen quite frequently when testing tricky code especially when using office automation. The "stranded" instances of VFP or office apps can be seen in the task manager and closed accordingly.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Joe Yoder Sent: 05 May 2016 22:05 To: Foxpro forum profox@leafe.com Subject: Re: Strange " File access is denied" message
Thanks Tracy,
I tried using with the share clause and it worked without error. I renamed the files and the same files with different names continued to give the error, I restarted the computer and the problem went away!
I'm glad to have my code back but am still puzzled about what was happening,
Thanks again,
Joe
On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson tracy@powerchurch.com wrote:
Joe Yoder wrote on 2016-05-05:
I have a situation where "File Access is denied" shows up any time I try
to
open the main form in my current project. I'm running Windows 10 and
when
I get into File Explorer I can open both the .SCT and the .SCX files
from
notepad without a problem. If I double click on either one VFP opens, attempts to open the file, and throws the error message.
VFP opens other screen files without a problem so it seems there must be
a
problem with that specific file inside VFP. I tried opening the .SCX as
a
table and got the error too.
Any ideas about why this is happening and how to get around it will be
most
welcome!
Thanks in advance,
Joe
Joe,
VFP will open the files exclusive. Notepad will not. Did you try to use the SCX as a table with the SHARE clause?
Do you have a process open or hung that still has the form open?
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
That all makes sense but why wouldn't giving the file a new name let me start over? I did look for evidence in the task manager but I am new to the Windows 10 version and did not spot anything with Foxpro in the name.
Joe
On Fri, May 6, 2016 at 3:53 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
I guess you crashed the form at some stage and the .scx/sct table was left open somewhere hence not being able to open it. The open file could also be in another instance of VFP which isn't displayed because it has gone rogue at some stage and doesn't present a visual interface.
I have had this happen quite frequently when testing tricky code especially when using office automation. The "stranded" instances of VFP or office apps can be seen in the task manager and closed accordingly.
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Joe Yoder Sent: 05 May 2016 22:05 To: Foxpro forum profox@leafe.com Subject: Re: Strange " File access is denied" message
Thanks Tracy,
I tried using with the share clause and it worked without error. I renamed the files and the same files with different names continued to give the error, I restarted the computer and the problem went away!
I'm glad to have my code back but am still puzzled about what was happening,
Thanks again,
Joe
On Thu, May 5, 2016 at 2:20 PM, Tracy Pearson tracy@powerchurch.com wrote:
Joe Yoder wrote on 2016-05-05:
I have a situation where "File Access is denied" shows up any time I try
to
open the main form in my current project. I'm running Windows 10 and
when
I get into File Explorer I can open both the .SCT and the .SCX files
from
notepad without a problem. If I double click on either one VFP opens, attempts to open the file, and throws the error message.
VFP opens other screen files without a problem so it seems there must be
a
problem with that specific file inside VFP. I tried opening the .SCX as
a
table and got the error too.
Any ideas about why this is happening and how to get around it will be
most
welcome!
Thanks in advance,
Joe
Joe,
VFP will open the files exclusive. Notepad will not. Did you try to use the SCX as a table with the SHARE clause?
Do you have a process open or hung that still has the form open?
Tracy Pearson PowerChurch Software
[excessive quoting removed by server]
Run a prompt as administrator and do:
taskkill /im vfp9.exe /f
That will kill any orphaned VFP instances that might have files open.
I think the application should have a log that indicates whether a user and/or IP address shut down the application normally.... A Foxpro/DOS application I maintained used to do that. Then we could find out who's locking a DBF file.....
On Fri, May 6, 2016 at 8:57 PM, Alan Bourke alanpbourke@fastmail.fm wrote:
Run a prompt as administrator and do: taskkill /im vfp9.exe /f That will kill any orphaned VFP instances that might have files open.
Or you could just turn it off and back on again...
On Fri, May 6, 2016 at 11:57 AM, Man-wai Chang changmw@gmail.com wrote:
I think the application should have a log that indicates whether a user and/or IP address shut down the application normally.... A Foxpro/DOS application I maintained used to do that. Then we could find out who's locking a DBF file.....
On Fri, May 6, 2016 at 8:57 PM, Alan Bourke alanpbourke@fastmail.fm wrote:
Run a prompt as administrator and do: taskkill /im vfp9.exe /f That will kill any orphaned VFP instances that might have files open.
-- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you!
[excessive quoting removed by server]
On 06/05/2016 18:21, Ted Roche wrote:
Or you could just turn it off and back on again...
Hey, that's a trade secret. I could be out of a job if that gets out ;-)
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
Don't blame me. Blame Chris O'Dowd and Channel 4. Ruined IT consulting:
https://www.youtube.com/watch?v=nn2FB1P_Mn8
On Mon, May 9, 2016 at 5:52 AM, Peter Cushing pcushing@whisperingsmith.com wrote:
On 06/05/2016 18:21, Ted Roche wrote:
Or you could just turn it off and back on again...
Hey, that's a trade secret. I could be out of a job if that gets out ;-)
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
On 09/05/2016 12:43, Ted Roche wrote:
Don't blame me. Blame Chris O'Dowd and Channel 4. Ruined IT consulting:
Not actually seen an episode of that series but heard all about it from people at work!
Cheers,
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
Nice one Ted - well worth a good watching over lunch for a chuckle!
Regards, Kurt Wendt Senior Systems Analyst
Tel. +1-212-747-9100 www.GlobeTax.com
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Monday, May 09, 2016 7:44 AM To: profoxtech@leafe.com Subject: Re: Strange " File access is denied" message
Don't blame me. Blame Chris O'Dowd and Channel 4. Ruined IT consulting:
https://www.youtube.com/watch?v=nn2FB1P_Mn8
On Mon, May 9, 2016 at 5:52 AM, Peter Cushing pcushing@whisperingsmith.com wrote:
On 06/05/2016 18:21, Ted Roche wrote:
Or you could just turn it off and back on again...
Hey, that's a trade secret. I could be out of a job if that gets out ;-)
Peter
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715 London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
This might be useful in a multi-user scenario....
Unlocking a Shared File Locked for Editing http://www.ozzu.com/mswindows-forum/unlocking-shared-file-locked-for-editing...
On Fri, May 6, 2016 at 3:53 PM, Dave Crozier DaveC@flexipol.co.uk wrote:
I guess you crashed the form at some stage and the .scx/sct table was left open somewhere hence not being able to open it. The open file could also be in another instance of VFP which isn't displayed because it has gone rogue at some stage and doesn't present a visual interface.
I have had this happen quite frequently when testing tricky code especially when using office automation. The "stranded" instances of VFP or office apps can be seen in the task manager and closed accordingly.
Dave