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.

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

"raj" <(E-Mail Removed)> wrote in message
news:E7C73F0E-38BF-467C-94BE-(E-Mail Removed)...
> 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;EX
C=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MT
S=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'
dialog with all fields listed. If i select all the fields, then the resulting
linked table is editable.

"Baz" wrote:

> That is surely a function of the database engine (whatever it is)?
>
> "raj" <(E-Mail Removed)> wrote in message
> news:E7C73F0E-38BF-467C-94BE-(E-Mail Removed)...
> > 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;EX
> C=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MT
> S=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.
>
>
>

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)

"raj" <(E-Mail Removed)> wrote in message
news6D0DD2C-CC33-4E9A-BED8-(E-Mail Removed)...
> 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" wrote:
>
> > That is surely a function of the database engine (whatever it is)?
> >
> > "raj" <(E-Mail Removed)> wrote in message
> > news:E7C73F0E-38BF-467C-94BE-(E-Mail Removed)...
> > > 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;EX
> >
C=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=F;BAM=IfAllSuccessful;MT
> > S=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.
> >
> >
> >