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

Easysoft ODBC-Firebird Driver

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

Article :	00929
Last Reviewed :	19th July 2005
Revision :	1

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 Firebird 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-Firebird Driver User Guide:

ftp://ftp.easysoft.com/pub/docs/firebird/odbc-firebird-1_0_0.pdf

Applies To

Products
- Easysoft ODBC-Firebird 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-Firebird Driver

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

Applies To

Knowledge Base Feedback