Update ODBC Link Table

[Rpettis31]

I have an old database that works fine it is an MDE however I was wondering
if I am able to update a table through an linked table in the odbc through an
update query.

Thanks

 

[Douglas J. Steele]

Not sure what you're asking.

If the linked table is in a Jet database (an MDB, MDE, ACCDB or ACCDE), then
you cannot connect to it using ODBC from an Access application.

If the linked table is in some other DBMS, then as long as it has a unique
index defined, you should be able to update it.

 

[John W. Vinson]

I have an old database that works fine it is an MDE however I was wondering
if I am able to update a table through an linked table in the odbc through an
update query.

Thanks

Update its contents? Sure. Update its structure? Not with an Update query but
with a passthrough DDL query, assuming you have the needed permissions.