I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Interbase table with a primary key defined on a VARCHAR field. What can I do?

Easysoft ODBC-InterBase Driver

I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Interbase table with a primary key defined on a VARCHAR field. What can I do?

Article :	00930
Last Reviewed :	29th October 2008
Revision :	4

This issue is to do with how Access returns the SQL datatype from the database on the key. To stop this tick the following attribute within your Interbase ODBC datasource set-up:

Default_SQL_Char

Once reconnected you should see the data. It should be mentioned that setting this could cause other applications to have problems with the data. For a full description of this configuration and the behaviour of the driver please reference the ODBC-Interbase Driver User Guide:

ftp://ftp.easysoft.com/pub/docs/interbase/odbc-interbase-4_0_0.pdf

Applies To

Products
- Easysoft ODBC-InterBase Driver
Applications
- Microsoft Access

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-InterBase Driver

I am getting #deleted with my MS Access linked table when connecting to a UNICODE_FSS Interbase table with a primary key defined on a VARCHAR field. What can I do?

Applies To

Knowledge Base Feedback