write permission for linked tables

R

raj

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.
 
R

raj

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.
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top