Update ODBC Link Table

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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
 
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.
 
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
Click to expand...

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