write permission for linked tables

[Guest]

I created odbc linked tables through code:

Dim tdf As TableDef
With CurrentDb
Set tdf = .CreateTableDef("LNDETAILS", dbAttachSavePWD, "LNDETAILS",
"ODBC;DSN=WAXSERVER;UID=WAXUSER;PWD=MAX99;DBQ=WAXSERVER.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MTS=F;MDI=F;CSR=F;FWC=F;PFC=10;TLO=0;")
.TableDefs.Append tdf
.TableDefs.Refresh
End With

The code successfully creates the linked tables. But the resulting linked
table do not have write access. Please advise how to provide write access.

 

[Baz]

That is surely a function of the database engine (whatever it is)?

 

[Guest]

When i create a linked tabled manually, i.e via menu File > Get External Data

Linked Tables, after selecting the table i get a 'Select Unique Identifier'

dialog with all fields listed. If i select all the fields, then the resulting
linked table is editable.

 

[Baz]

Right, so your question doesn't actually have anything to do with
permissions, it's really about identifying the unique field in the linked
table.

Look up CREATE INDEX in Access help (a search probably will not find it, you
may need to go to Table of Contents - Microsoft Jet SQL Reference - Data
Definition Language)