ODBC Linked Table - Write Lock Error (1 Viewer)

[B.S]

Hi terrific resources,

I have following table in Teradata database

create table myTable(
column1 varchar(20) not null
,column2 varchar(20)
,column3 varchar(20) not null default '_'
,column4 char(1) not null default 'I'
);
unique primary index(column1)

NOTE: for people not familiar with Teradata, unique primary index = primary key in normal concepts

1. I create a blank database (mydb.mdb)
2. I go to File > Get External Data > Link Table
3. I import this table via 'ODBC Database' file types
4. Once imported as Link Table, I right click > OPEN
5. Insert records with Success
6. Try to update records and get this error

" This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. "

I have 3 buttons on this dialog box

• Save Record [disabled - greyed out]
• Copy to Clipboard [active]
• Drop Changes [active]

Please not this is not in a FORM, just a simple imported link table. So no VBA attached to it or can be attached to it.

Furthermore, on thorough investigation, I found that I can get rid of this error by following solution

1. Remove default value of CHAR(1) column
2. Increase data length of Char(1) to CHAR(2)

But in my clien't case I can not make both of these changes to the DDLs. Hence is there a possibility you can advise WHY this is so and HOW can i forcefully make Access not to give error and just let the Business User update the record ?

I'll be grateful if you could provide any feedback.
Regards,
BS