Format for fields in Update To (1 Viewer)

[AndyS48UK]

Can I populate a table using an update query?

I'm having trouble referncing the fields in the table. Access Help seems to be saying to "Update To" [Tablename].[Fieldname] but when I run the query it keeps asking me for a parameter.

Thanks

 

[AndyS48UK]

Having just found some more help I think it may be that my tables in the original query are ODBC linked with no unique index.

I wonder if there is a way around this?

 

[Pat Hartman]

All tables should have a unique primary key. If the table does not contain any candidate keys, an autonumber is a suitable substitute.

If the table does contain a unique column (or set of up to 10 columns), you can create a psuedo index using DDL. I'm not sure that will convince Access to let you update the table but I think it will. Look up CREATE INDEX in help.

WARNING If you use this technique to gain update access to the table and it turns out that the psuedo index that you defined is not truely unique, you will CORRUPT the ODBC table.