bj said:
Can you update a linked ODBC table? I dont have a primary key but I have two
fields in the table when put together are unique.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Why don't you just make those columns the primary key (a PK can have
more than one column) & then re-link the table to the Access front-end.
Then the table will be updateable.
If you don't have any control over the table:
When you use the Get External Data menu item to link the ODBC table,
Access usually asks for the tables unique columns. Select the 2 columns
that uniquely identify the record from the dialog box that displays the
table's columns.
- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQGOmioechKqOuFEgEQKTxwCg5wWCR1WyMBG+3cF33b8xDMzaxe8AoL4B
lDDZYIslmkSHcnzJurDwe4WA
=w/pg
-----END PGP SIGNATURE-----
