My apologies if this is the wrong place to post this question, however,
not real sure where to post it.

I have a linked table in Access 8.0 from SQL Server, I join this table
with one that resides in Access.  I then create a simple "make table
query".  The problem is that the new table that I have now created will
not allow me to do a Delete query from it.  I get a message that states
that I must use an updatable table.

Anyone know why this is occuring?  I have tried coping the data (without
the structure) from my new table into another table that I have defined
and this still doesn't work.

Thanks in advance for any assistance.

Cathi

Cathi,
No need to apologize... :)

If you are simply attaching the SQL Server table to a local table and then
using the resulting data (via a make table query) to create a new table that
new table should be updateable.  Perhaps there is something unusual in the
SQL syntax of the query which is throwing off the results.
An example of the two queries would be:
SELECT dbo_tblCustomers.*, tblCustomerDomains.SiteName INTO testing
FROM dbo_tblCustomers INNER JOIN tblCustomerDomains ON
dbo_tblCustomers.CustomerID =
tblCustomerDomains.CustomerID;

then

DELETE testing.*, testing.CustomerName
FROM testing
WHERE (testing.CustomerName = "Deleteme");

If you still can't get it to work feel free to e-mail me directly

you cannot get to work and I will see if I can help you out.

Jennifer