|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 15th, 2007, 07:52 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Using ODBC Connection Query Error: Non-Updatable Query
A query was running using a linked table to an Access database. The query
linked an access table from the current database and uptated that table with data from the linked table. We then used an ODBC connection to linke to SQL Server to obtain the required information to update the Access table in the current database. An error was displayed: Non-Updatable Query. We then imported the table and the query worked. Is there a way to modify the connection so we can still use linked tables to the ODBC data source ? 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode