I have created a user and granted it select, references on several tables. I
publish this user and password to clients who wish to connect to the
database via e.g. access to design their own reports. Works well. But for
some reason, there is one table which, when I grant select etc to it, the
ODBC driver comes back with a ODBC "fail code" message. I can't see why this
table would not work it's defined as
CREATE TABLE DEMOUNTMOVES (
DNO PKID,
BNO PKID,
REMOVED DATESTAMP,
SCHFROM GENINTEGER,
ADDED DATESTAMP,
SCHTO GENINTEGER
);
which does not indicate any reserved words or strange datatypes, the types
(domains) here, are also seen in other tables which are imported, linked
fine into access.
I'm using Visigenic ODBC with IB6.01.
It's definitely just this table which does not want to come across either by
itself or in combination with other tables.

Any ideas anyone?
Alan McDonald


[Non-text portions of this message have been removed]