> 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

I wrote this application.
There are about 3000 installations of it around Australia and contrary to
SETs suggestion, the tranasaction management is fine and not an issue in
this instance.
I do not get any feedback from the agency, unfortunately, but I do know of
one other person who had this issue. I never got more information back other
than "it seems fine for them now", so I have to assume it was a simple
change. 99% of installations are on windows servers so we did not go into
exahaustive install testing (and therefore instructions) on setup to a
myriad of linux setup possibilities. It was left to assume that anyone with
a desire to use linux was experienced enough to know what to do.
I can only imagine that it has something to do with the linux setup.
What user do you use to run the setup? What user is running the server?
You will probably need to try and restore tha database on the server rather
than just copy it to see that the udf library is accessible.
When you copy it, you are you - the person who copies. But the server is
running as someone else.
What is in the server log?
You can access it because you have read access but not write access to save?
If we get this sorted I will document the problem.
Alan