write permission for linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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'
Click to expand...
dialog with all fields listed. If i select all the fields, then the resulting
linked table is editable.
 
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)
 
Back
Top