> Hi Fred,
>Paradox databases are a great choice for 2-8 users (and can handle many
>more).
>I use Paradox in my office everday with 6 users. This week, I extended the
>whole thing by writing a specific Delphi app, putting the exe file on my
>novel server along with the pdox tables they accessed so users throughout
>the rest of the company could access certain data.
>I had a couple of problems:
>1) I put the BDE on the server, thinking that was all I had to do, but I
>kept getting an error on a non-Paradox user machine that "Could not
>initialize BDE". It turns out that (at least in Win 95) there has to be some
>changes to the Windows Registry to point to the BDE on the network.
>2) After fixing #1, I got another BDE problem. "could not access network
>control file". In this case, the BDE config was pointing to another
>directory on the novel server, which we use as the network control file. I
>forgot to give the new user access rights and a mapping to that directory.
>It also was not good enough to give him access to the directory, it has to
>have the same mapping as the setting in BDE. For example, say the network
>control file is I:\APP\PDOXWIN\. I mapped the users I drive directly to
>I:\app\pdoxwin. BDE did not like this either. I had to map his I drive to
>the I root, and give him access to the subdirectories.
>For my money, Paradox is a great tool. Not too expensive, but flexible and
>powerful enough to handle many users and some pretty big tables.
Another thing I'm warming up to fast is InterBase. Yes, there are licensing
issues but as a "trouble free it-just-runs client-server" it's pretty
unbeatable.
by