Delete qry from a linked table.

[cage4000]

I have two linked tables from a back end Access Database. I am trying to run
a delete qry from the front end database but it tells me that “Could not
delete specified tablesâ€.

I trouble shouted with Access help and it told me to look at the reed-only
properties, and so I made sure that the read-only properties wore set to off
on the front end and on the back end. Both the front end and the back end
Databases are located in the same folder on the same computer.

The qry runs from “link table-tblCMI†to “link table tblCMIsecRun†finding
all duplicate information in a field named “Containerâ€. There is a join
between the 2 tables in the qry that connects the Container field together to
make it understand that that is the field that is unique.

The two fields that are used in the qry are:

FEALD #1
Field: Container
Table: tblCMISecRun
Delete: Where
Criteria: [tblCMI]![Container]

FEALD #2
Field: tblCMISecRun.*
Table: tblCMISecRun
Delete: From

Can you please help me on making this delete qry work?

Thanks,

Cage

 

[John W. Vinson]

The two fields that are used in the qry are:

FEALD #1
Field: Container
Table: tblCMISecRun
Delete: Where
Criteria: [tblCMI]![Container]

FEALD #2
Field: tblCMISecRun.*
Table: tblCMISecRun
Delete: From

Please use View... SQL to see the SQL text of the query - it may look
cryptic, but it's the actual query and will contain the information
that might help to resolve the problem. I gather that there are two
tables involved - tblCMISecRun and tblCMI? How are the two tables
related in the Relationships window?

John W. Vinson [MVP]

 

[cage4000]

I saw the problum in the SQL. thanks for your help.

The two fields that are used in the qry are:

FEALD #1
Field: Container
Table: tblCMISecRun
Delete: Where
Criteria: [tblCMI]![Container]

FEALD #2
Field: tblCMISecRun.*
Table: tblCMISecRun
Delete: From

Please use View... SQL to see the SQL text of the query - it may look
cryptic, but it's the actual query and will contain the information
that might help to resolve the problem. I gather that there are two
tables involved - tblCMISecRun and tblCMI? How are the two tables
related in the Relationships window?

John W. Vinson [MVP]