At 07:19 PM 17/07/2006, you wrote:

>Hi Helen,
>
>Thanks for the reply,
>
>I am opening the connection and the dataset explisitly, but it only
>works when I open it from within the module which contains the
>IBODatabase or IB_Connection,
>
>//This works fine
>//This code is from a connect function in a datamodule, which
>//contains the connection component
>
>dbPanstrat.Server := #ServerName;
>dbPanstrat.Path := #Path_to_db;
>dbPanstrat.Username := #Username;
>dbPanstrat.Password := #Password;
>dbPanstrat.SQLDialect := 1;
>dbPanstrat.Protocol := cpTCP_IP;
>dbPanstrat.Connect;
>
>//After this the login screen is shown, and on the OnShow event the
>//following tables are opened:
>
>dmConfiguration.wtblUsers.Open;
>dmConfiguration.wtblTills.Open;
>dmConfiguration.wtblShifts.Open;
>
>*dmConfiguration is a datamodule
>
>When the any of these Open commands are executed the application
>hangs but if I were to Open these datasets from within the
>datamodule which contains the connection component, it works.

1. Is dbPanstrat on a different datamodule? If so, is that
datamodule in the Uses clause of dmConfiguration?

2. Once that is done, have you selected the IB_Connection and
IB_Transaction properties of each dataset?

Helen