About PDOXUSRS.NET file

[James]

In my program I use a table with CachedUpdate set to True. Every time the
program opens the table, it creates a file "PDOXUSRS.NET" in C:\. The
program had been fine until recently our company upgraded all workstation to
Windows XP which doesn't allow the ordinary users do not have write
permission in the C:\ . The program uses BDE and uses MSSQL as database
driver. I can not figure out why it has to create a file called "
PDOXUSRS.NET " because the program doesn't use Paradox as its database. I
hope I can find a way to prevent the program from creating this file or have
the program create the file in other location. Can anyone give me a hint?

Thanks,

James

[Aage Johansen]

Let's just say 'it comes with the BDE - it's the way the BDE works' ...
If the problem is that you didn't specify a "NET DIR", you can just use the
BDE Administrator to set this parameter in the
Configuration|Drivers|Native|Paradox. Set it to some directory where you
have read/write/erase/whatever rights on. Usually this is somewhere on the
LAN, and _every_ BDE user must use this directory (or else!).
Free advice: The BDE (or SQLlinks drivers) are deprecated. If you can
rewrite your program to _not_ use the BDE you may avoid future problems
(and you should be able to use new features of the latest SQLserver
versions).

--
Aage J.

[Bill Todd]

On Wed, 14 May 2003 17:11:07 -0400, "James" <jy...@myrealbox.com>
wrote:

>In my program I use a table with CachedUpdate set to True. Every time the

>program opens the table, it creates a file "PDOXUSRS.NET" in C:\. The
>program had been fine until recently our company upgraded all workstation to
>Windows XP which doesn't allow the ordinary users do not have write
>permission in the C:\ . The program uses BDE and uses MSSQL as database
>driver. I can not figure out why it has to create a file called "
>PDOXUSRS.NET " because the program doesn't use Paradox as its database.

The cache used by Cached Updates is a Paradox database. As Aage said,
set the NetDir to a location the users do have write access to.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

[heiko Luettge]

for cached updates you do not have to set net dir to a common dir where
all users in the net have access, because the paradox files are stored at
local drive.

Simply create a temp file (c:\temp), and give all users full access.
Then set the net dir to c:\temp

heiko