I have a databse on a share on a computer across a small network. I
restructures one table by adding a field using DBSYS. After that the
workstation machine cant access this file only, giving access denied error
11013 but the server access it well. all other table work ok? Private
directories are or.

Please advise what else could cause this so suddenly.

winxp, dbisam 4.19, peer-to-peer network

Regards

Hi

> I have a databse on a share on a computer across a small network. I
> restructures one table by adding a field using DBSYS. After that the
> workstation machine cant access this file only, giving access denied error
> 11013 but the server access it well. all other table work ok? Private
> directories are or.
>
>

I have this problem too and I think it's a file permisson problem.
This happen when altering a table from de server when the user is the
administrator.

With Win2000 or Win2003 you must reasing the permissions.

With WinXP one solution must be altering the table from the workstation.
Another solution perhaps it's copy the table from the server to a
PenDrive and in a workstation copy the table from the PenDrive to Server.


And my question is why the AlterTable change the table user permissons ?

Regards
Robert

Hi

Yes this is a known permissions issue.

When altering a table the new table is created in the
Database.Session.PrivateDir folder and it picks up its
permissions from that folder, then it retains those when
finally being moved back into the database folder.

The quick and dirty solution is to point the
Database.Session.PrivateDir at the database folder .. but
then you lose the advantage of a temporary folder.

Alternatively you can create your own temp folder with the
correct permissions and set your
Database.Session.PrivateDir to that temp folder.

Malcolm

Omik,

<< I have a databse on a share on a computer across a small network. I
restructures one table by adding a field using DBSYS. After that the
workstation machine cant access this file only, giving access denied error
11013 but the server access it well. all other table work ok? Private
directories are or. >>

Please see this technical bulletin:

http://www.elevatesoft.com/bulletin_9.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Ok thanks for the info guys.

Regards



"Omik_1" <kimowaugh@yahoo.com> wrote in message
news:CD6BAF09-A96C-437D-BF5C-1210380B2D2E@news.elevatesoft.com...
>I have a databse on a share on a computer across a small network. I
>restructures one table by adding a field using DBSYS. After that the
>workstation machine cant access this file only, giving access denied error
>11013 but the server access it well. all other table work ok? Private
>directories are or.
>
> Please advise what else could cause this so suddenly.
>
> winxp, dbisam 4.19, peer-to-peer network
>
> Regards
>