Ms access linked table not updating Clipchatsexviet

You can easily update the location information in the table links by using the Linked Table Manager.To use this handy utility, open the database that contains linked tables that you need to relink, and on the External Data tab, in the Import & Link group, click the Linked Table Manager command.

ms access linked table not updating-3ms access linked table not updating-28ms access linked table not updating-22

You can open a linked table in Design view to change the Format, Decimal Places, Caption, Description, and Input Mask property settings for any field.

wrote: Christian IF I've understood you correctly you try and update the Access table and expect the underlying Excel sheet to change?

Unfortunatley this doesn't work by design, its a security issue and a Service pack and/or fix for Access disabled this functionality. Count yourself lucky, on one machine I've seen the ISAM error when using a linked table to update a "normal Access" table i.e. Apparently Jet gets a bit confused and doesn't realize which table is being updated...

----------- Count yourself lucky, on one machine I've seen the ISAM error when using a linked table to update a "normal Access" table i.e. Apparently Jet gets a bit confused and doesn't realize which table is being updated...

Sounds less like a security issue and more like a feature they just couldn't implement correctly.

Leave a Reply