Lookup queries

  • Thread starter Thread starter Martyn King
  • Start date Start date
M

Martyn King

Hi

I am trying to get a lookup query to work with a linked
ODBC table from a non access database.

It does the lookup fine but will not allow me to update the
recordset to add a new record into the non lookup side. The
lookup on the ODBC database table is non-updateable but
this should not matter.

Anyone got any ideas..

Thanks in Advance.

MK
 
Martyn said:
Hi

I am trying to get a lookup query to work with a linked
ODBC table from a non access database.

It does the lookup fine but will not allow me to update the
recordset to add a new record into the non lookup side. The
lookup on the ODBC database table is non-updateable but
this should not matter.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It should matter. If the query is not updateable then you can't
update it.

To make an updateable query you have to include the unique keys,
primary keys and required fields of the table that you want to update.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQFe02IechKqOuFEgEQLCoQCgr0RCNOm+N5WLr1roXMKWWm9WduEAniJT
P9K8puGdoxMa7K/ZOvooZ+ls
=K1KZ
-----END PGP SIGNATURE-----
 
Back
Top