Re: Display data from ODBC table

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 03/09/05 

Date: Thu, 10 Mar 2005 02:15:16 +1100

Have you tested updating the data in the DatasheetView of the Query?

If you can in the above, you might have set the Recordset Type of the Form
incorrectly.

If you can't update in the DatasheetView then the problem is in the Query.
In this case:

* Check that you have a PK defined in Table [tblSoftware] on the SQL Server.
* Check your permissions on the SQL Server.

Your terminology is slightly confusing. If you imported the Table, then the
imported Table is a (local Access) Table, _not_ "ODBC imported". My guess
is that you only linked the SQL Server Table to your Access database and the
correct term is ODBC-linked Table.

I am not sure whether you linked the Table directly from the SQL Server or
from the other MDE. If you linked from the other MDE, suggest you try to
link the Table directly from the SQL Server rather than via the MDE. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Gail" <Gail@discussions.microsoft.com> wrote in message
news:B6A301D5-F9D9-49CB-BFD6-E5FDCD58288A@microsoft.com...
> I am getting the message "this recordset is not updateable."  I would have
to
> believe that what I am doing is a common function...  updating one table
> while displaying (not updating) info from another table.  My current
> RecordSource for the form is the JOIN query I have shown, joining my
> hopefully updateable table PL-XP-2003 in the MDB, with the ODBC imported
> table from the MDE dbo_tblSoftware.  HELP!
>