When linking to an ODBC table for update in MS Access, the table must have an unique key.
You must select that key on the last screen during the linking process regardless of keys established on the source system. This is my first time asking a question here, so please bear with me if I seem 'unconventional! OS: Windows_NT App: MS Access 2000 (also in 2003) ODBC linked table into a DB for which I have read/write/delete authority. Here however, I can update fields within the table.
Therefore, if you know something about them, you’ll also know something about web tables.
So, it is not necessary to re-link the tables in order to receive new information.
To create a macro in Microsoft Access that automatically links tables in two different databases, do the following: How-to: Prior to running the macro, ensure that the linked table is closed.
I have looked at the security within MS Access and cannot find anything relating to table access authorization.
Can you suggest some areas I may have missed, please? NZaiser Well, I have found the answer to my question.
To run the macro without stopping, select the exclamation point icon (Run).
To perform each action in the macro, use the icon to the right of the exclamation point (indented block paragraph with the arrow).
I'm trying to set up an automated procedure that runs a Crystal report against an Access database.
The tables in Access are ODBC linked to an AS400 database.
I have a set of linked tables (To Oracle DB) that I need to update via a form.