Updating a linked table in access dating fellow grad student

Rated 4.6/5 based on 532 customer reviews

Tip For Access developers who enter connection strings in VBA code, consider adding and editing the connection string from the Linked Table Manager dialog box instead of revising your code directly or writing complex code that automatically changes connection strings.

You can use the Linked Table Manager to re-establish the links from your linked tables when the backend database has been moved.

It has something to do with some copyright battle or something like that. 2000) where the capability to update linked files still exist.

But that may not be feasible or possible (unless you have an old copy available to you). Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.

However, when I go to view my form of the information from the table the form does not show the same amount of records as the table or any updates that were made to the table.

If your solution requirements have changed, you can also add or delete linked tables.

Note Depending on the version of Access you have, the Linked Table Manager dialog box works differently.

Is there something that changed in the linking process between access 97 and access 2003? Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. However, to update the Excel file in the end, I think you would need to export from Access at that point (and import that into Excel).

The spreadsheet is not write protected or otherwise in use. "I don't think you need to import anything into Access, you can link the Excel file to Access to get what you need.

Leave a Reply