how do you delete records or update records in a link table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to delete records based on a certain criteria in a linked table
and also I am trying to update records in a link table summing two functions
together. I get a message stating that "Deleting data in a link table is
not supported by this ISAM"
 
(1) Need example of SQL
(2) You cannot sum functions, you can only sum variables or columns.
What version of Access are you using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot delete records in linked table 1
Delete Query: Could not delete from specified tables 0
Access Dcount (multiple criteria) 3
Trying to delete records from multiple tables 2
not supported by ISAM 3
Delete table's records in another database 1
You can not add or change a record because a related record... 8
Update Query On Linked Table 4

Back
Top