Hi

I've been having problems with accessing certain files for some time now. I wrote about my problems in Elevate DB tech support forum and found out that error 11013 that I get is usually the result of AV or some other process locking mentioned files. After reading about others problems I found out that account permissions could also be guilty for it.

I used the method Tim suggested (thank you Tim!) which is looking for opened files via: Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files.
None of the tables that I am trying to open are marked as opened.

Than I used "unlockIt" tool which is supposed to show which process has certain files locked. It didn't show any of my .dat files as locked by any process.

To further explain ... I can open those files if I use my server computer, but I can't open them if I use any other "client" machines and I am opening them manually (double click on the file). So my problem should be somewhere in user/account permissions, wright?
But my permissions are the same for the entire disk. All other files are OK, just this one directory is giving me problems.
And the last thing to add to my confusion is something I discovered today. I can delete those files through my local machine but I can't rename or open them??? Where is the logic in that?

I don't use "simple file sharing" because I had even more problems with that. So .. how to set my permissions above full (every permission check box is checked) to avoid those errors in future?
I have deinstalled AV, DBISAM server and resetted all computers. My temp file location is set to dir with full control.

Thank you

Iztok Lajovic

Iztok


I have a vague memory of something similar. The onnly way I eventually found to cure it was to create a new directory, copy all the files into there, delete the original directory and rename the new one.

I never did find out what the problem was.


Roy Lambert [Team Elevate]

Iztok,

I'm assuming based on your description the files are shared from a
server/workstation and run by remote clients over share.

The permissions are fairly straightforward in this case:
- on server computer make sure Everyone has Full Control to the folder
and subfolders in question
- similarly on the shared folder (i assume it's one of the top folders
from previous step) make sure under sharing Everyone has Full Control
again (basically you need both local and share permissions to allow full
control for remote users to have full control on files).

As Roy suggested recreating folders and shares might be a good idea.
Simple sharing should be turned off.

Also disable anti-virus real-time scan on clients temporarily if it's
still running - I've seen some AV engines scan a remote share whenever
your OS accesses it by UNC and it causes all kinds of problems.

As i recall the "Shared Folders/Open Files" only shows files open by
remote clients and not by server itself (for example AntiVirus or even
something like dbsys running on server does not show there).

The other tool that has helped me with this kind of troubleshooting is
the Process Monitor from sysinternals:
http://technet.microsoft.com/en-us/sysinternals/bb896645

Basically run it on your server and set the filter so it only shows your
DB files (e.g. set filter : path contains <your folder> include"). The
procmon will log every file open/read/etc so if you run it and try to
run the app from remote workstation you might be able to see what it
actually taking place underneath at file access level. It can generate
lot of data but if you filter and then run a controlled test with single
remote client it should be easy to read.

Raul


On 12/15/2011 9:57 AM, Iztok Lajovic (1) wrote:
> Hi
>
> I've been having problems with accessing certain files for some time now. I wrote about my problems in Elevate DB tech support forum and found out that error 11013 that I get is usually the result of AV or some other process locking mentioned files. After reading about others problems I found out that account permissions could also be guilty for it.
>
> I used the method Tim suggested (thank you Tim!) which is looking for opened files via: Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files.
> None of the tables that I am trying to open are marked as opened.
>
> Than I used "unlockIt" tool which is supposed to show which process has certain files locked. It didn't show any of my .dat files as locked by any process.
>
> To further explain ... I can open those files if I use my server computer, but I can't open them if I use any other "client" machines and I am opening them manually (double click on the file). So my problem should be somewhere in user/account permissions, wright?
> But my permissions are the same for the entire disk. All other files are OK, just this one directory is giving me problems.
> And the last thing to add to my confusion is something I discovered today. I can delete those files through my local machine but I can't rename or open them??? Where is the logic in that?
>
> I don't use "simple file sharing" because I had even more problems with that. So .. how to set my permissions above full (every permission check box is checked) to avoid those errors in future?
> I have deinstalled AV, DBISAM server and resetted all computers. My temp file location is set to dir with full control.
>
> Thank you
>
> Iztok Lajovic
>

<Iztok Lajovic (1)> wrote in message
news:3D0EA79E-5B12-4F30-BC71-4AED188A4ABB@news.elevatesoft.com...
> Hi
>

There is an issue when you do table updates, restructures, optimize, etc. in
that the new table is created on the temp folder and then moved to the
database folder but with the temp permissions. See if this could be your
problem.

Robert

Hi

Thanks to all for your help. Moving those files to another locations actually worked. That solution is not exactly a good one since I have to manually move those files, but at least it works.
I will also change the location for my temp folder so there is no confusion about permissions.

Iztok Lajovic

Robert,

<< There is an issue when you do table updates, restructures, optimize, etc.
in that the new table is created on the temp folder and then moved to the
database folder but with the temp permissions. See if this could be your
problem. >>

That's exactly what I was thinking also - the permissions are okay, but then
keep getting changed as the files are created locally and then re-copied to
the share:

http://www.elevatesoft.com/bulletins?action=view&category=dbisam&bulletin=windows_xp_file_sharing

--
Tim Young
Elevate Software
www.elevatesoft.com