unable to modify table

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

It depends on the database properties to the linked
database however you may want to try to make changes to
the linked DB by using a pass through query. Open a
standard query wizard do not select a table. Click the
QUERY menu item select Specific Query > Pass Through.
This will open an SQL script window. Type your query in
SQL format for whatever it is you want to change. See
some examples below.

This will change all the values of fieldname1 to -1
where fieldname2 is equal to 9:

UPDATE TableName SET TableName.FieldName1 = -1
WHERE TableName.FieldName2 = 9

There are any number fromulas you could write. If you
need help with the syntax be specific about what you need
I I'll see if I can help.

Marty
 
I think you need to have a PrimaryKey on the Table in the Back-End database.
It sounds like the Back-End is not an Access / JET database?
 
Back
Top