Hello,
i'm working with W2K centura sqlbase server 7.5.1 and access the database
with MS ACCESS 2000, it works. I only combine the tables.

1st problem:

I'm wondering that I cannot change any data record. I always get the
message:
Microsoft Access
ODBC: Aktualisierung in einer verknüpften Tabelle "tablename..."
fehlgeschlagen
MERANT] [ODBC SQLBase driver][SQLBase]01102 SEC SVI Security violation
attempting to access (#1102)

2nd problem:

I cannot create any calculation such e.g. qty * price

Microsoft Access
ODBC-Aufruf fehlgeschlagen.
MERANT] [ODBC SQLBase driver][SQLBase]00907 PRS ICN Invalid column name
(#907)

I would be very grateful for any help.

Regards

Christian Schabert

Hi Christian.

Christian Schabert wrote:
From Centura's Error.sql:
01102 SEC SVI Security violation attempting to access
Reason: Attempting to access an object when authority has not been
granted to use the specified object.
Remedy: Obtain proper authority before attempting to access the
specified object.

I would try it again with username = sysadm, which is the default for
SQLBase.

Error.sql:
00907 PRS ICN Invalid column name
Reason: The column name is invalid.
Remedy: Verify that the specified column names are valid.

It seems that your sql statement has a syntax error. What does it look
like?

-Niels-