We are running Paradox 9 on XP PCs. Paradox is loaded on the C Drive but
the data is on the Network.
Our network was on an NT Server, we just upgraded to a Win 2000 Server.
ALL was well on the NT Server but now…

When Paradox is loaded the Pdoxusrs.Net file is in C:\ by default as before.
In the past we have given this file Full Control and all was well.
Now it seems that C:\Pdoxusrs.Net can not be accessed even when given Full
Control. We are getting this message when we try to open a table stored
on the Network: You have attempted to open a database that is in use by someone
else, but the database cannot be shared. You must set the location for the
.NET control file.
I am also seeing that the default PRIV directory is: C:\Documents and Settings\USER
PROFILE NAME\My Documents\PdxPriv
rather than C:\Program Files\Corel\Shared\Private

The PRIV path should be located where by default?
The Pdoxusrs.Net file should be located where for best performance?

Jeanette wrote:

it's not the server, it's the XP machines.. first, the net file belongs on the server,
not on C drive.. and, on an XP machine, only a user with full Administrator rights can
access the root of C or the location in the registry where the BDE goes..

as for the priv, put it someplace simple where the user can find it.. like
C:\pdox9\priv..


--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox
---------------------------------------------------
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Trading Cards and other Sports Memorabilia
---------------------------------------------------

"Jeanette" <HarrisJR (AT) bwsc (DOT) org> wrote

To share or network your tables, the NET file must be in a common and
accessible location for all users. On your server, let up a folder, at say
c:\paradox\network. Make that location shareable with full access for
everyone. On each workstation, map a drive to your share. It's nice if the
same drive letter is used but not absolutely required. Set the NET control
file location with the BDE admin to the mapped drive letter.

For PRIV, I like to setup a folder, say c:\paradox\private and use the -p
command line parameter in the startup shortcut (target field) for my
applications.

i.e.

"C:\Program Files\Corel\WordPerfect Office
000\programs\pdxwin32.exe" -pc:\paradox\private

It is best practices if PRIV is located on the local disk drive.

Additionally, I recommend the -w parameter to set the location of :WORK: to
the applications main folder.

"C:\Program Files\Corel\WordPerfect Office
000\programs\pdxwin32.exe" -pc:\paradox\private -wc:\appfolder

Rick Kelly
Crooit Software

Jeanette wrote:
A little background ...

(1) Each user should have his own :PRIV: directory, which should be located
in most cases on their private (C drive.

(2) The NET FILE DIR specifies the location of Pdoxusrs.Net, which is the
central file that is used to co-ordinate multi-user access (along with the
".LCK" files found in each database directory). This is why the NET FILE
DIR setting must be the same for all users and must be a directory that all
users can see. It should NOT be a database-directory.

(3) Paradox has the VERY annoying habit of resetting these settings to their
default if you ever accidentally start Paradox without being logged-on to
the network.

----
ChimneySweep(R): F-A-A-ST table repair at a click of the mouse!
http://www.sundialservices.com/products/chimneysweep

This is WRONG!

You don't "accidentally" start Paradox without being logged on to the network.

Paradox warns you, and the user must ELECT TO CONTINUE with the network
disabled.

This is not an accident.

This is a deliberate action. Regardless of whether the user understands the
consequences, it is deliberate not an accident.


--

Tony McGuire
"It's not about having enough time. It's about priorities."
___________________________

Tony McGuire wrote:

Not every version warns you... and even so, what's the user realistically
expected to do? :-/ They're going to click "OK" without reading the
message (certainly without understanding it) and now, "the application is
broken."

People are creatures of routine. They rely heavily upon rote procedures,
and if what they did is "a deliberate action" it usually does not come from
understanding. So, from a pragmatic point-of-view as a systems manager,
"why ask 'why?'"

----
ChimneySweep(R): F-A-A-ST table repair at a click of the mouse!
http://www.sundialservices.com/products/chimneysweep

And this isn't 'routine'. They should be taught to stop and ask for help.

Wasn't aware of that. Seems every 32 bit version does; or are we talking the
BDE here?

Stop and ask for help!

That's the problem. Get new users.

Regardless. Don't give a free ride on this.


--

Tony McGuire
"It's not about having enough time. It's about priorities."
___________________________

Tony McGuire wrote:
Versions 8 and 9. They tell you that the configuration reverted to the
C-drive default, and by that time it's au fait accompli...


Would be nice, wouldn't it? :-)

I think we're all experienced enough in this game, Tony, to well understand
how it is played. :-) In the present case, the issue can be addressed by
making sure that every computer has a good configuration on its C-drive,
and by starting applications through scripts that explicitly check for the
presence of aliases and so-forth. And making good use of Caller ID... ;-)

----
ChimneySweep(R): F-A-A-ST table repair at a click of the mouse!
http://www.sundialservices.com/products/chimneysweep

Hi, Jeanette,

Have you checked for duplicate .net files? Have you set the location in
the BDE? Probably.

I would have thought the Private directory location odd, and have mine at
the same level as the data directories. I also put the .net file in the
data directory, but had not thought of performance issues.

Just a Sunday reply from another who is struggling with network problem,
noting that since the 6th you may have had a private reply.

There is an FAQ on the CNews usenet server that has some info on networks,
and another post there with some network info.

Anne


"Jeanette" <HarrisJR (AT) bwsc (DOT) org> wrote in
news:43bd3b2a$1 (AT) pnews (DOT) thedbcommunity.com:




--
-----
Anne Wainwright
Please reply to group