jpalmer150
Technical User
I have a Lotus Domino table linked to my Access database through an ODBC driver. (LotusNotes SQL Driver.nsf).
The table views fine and I can build basic queries from the table. However if I do anything in the query at all such as add a filter or enter a formula I get a call failer error.
ODBC--call failed.
[Lotus][ODBC Lotus Notes]Name epected (cannot be a reserved word) (#23010)[Lotus][ODBC Lotus Notes]Incorrect syntax near ',' (#23064)
I did some renaming to test for use of reserved words and had no luck. Interestingly if I make a new unlinked table from the linked Lotus table, everything works fine. However unfortunately I need to remain linked to the original table.
The table views fine and I can build basic queries from the table. However if I do anything in the query at all such as add a filter or enter a formula I get a call failer error.
ODBC--call failed.
[Lotus][ODBC Lotus Notes]Name epected (cannot be a reserved word) (#23010)[Lotus][ODBC Lotus Notes]Incorrect syntax near ',' (#23064)
I did some renaming to test for use of reserved words and had no luck. Interestingly if I make a new unlinked table from the linked Lotus table, everything works fine. However unfortunately I need to remain linked to the original table.