hi set. thanks for your help.

Unfortunately the process I have been given to install the acsaa
database does not involve any direct sql and I would have no idea where
to start with this.. The process basically is

a) take the acsaa database and place on your server
b) take the acsaa security.fdb and replace the firebird one.
c) check folder/file ownership permissions on the server
d) open the acsaa client on your desktop, go to preferences and then
change to a remote server, test connection, enter new credentials and it
is done.

This does work and I can access the database. The database seems to be
essentially a lot of word type pages where staff enter details about
aged care accrediation. there are not any real rows or columns obvious.
However when entering data and going to the next screen and then
returning to the original screen the data is not there.

I have now set this up on a windows server and it is working no
problems.. I would really like to resolve the linux server issues though

--

regards Rick Saul