
Make Table Query from Linked SQL Table
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
Quote:
>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