Convert a Delphi example using TDatabase and local paradox table to server storage

Question

I am looking at the Developer Express Quantum Grid example 'IssueList' which is a useful bug reporting and tracking application that's almost ready to go out of the box. It uses a TDatabase component with several paradox (.db) tables.

Is it simple to rejig the TDatabase settings to use a database on a shared machine so that several of us can access it together across the network? If so, what would be the steps needed please?

Answer 1

This TI describes the settings involved for sharing Paradox databases on a network.

In your configuration you need to set the working directory and private directory correctly.
Often it is easier not to use aliases for this, but perform all the settings in your TDatabase.Parameters property and your TSession.

The working directory must be the same path (sharename, drive letter) for all users.

The private directory must be different for all users.

Here are two links that explain some of the defails you need in more detail:

• Building one and two tiered apps
• Managing Database Sessions

--jeroen