Make Table Query from Linked SQL Table 
Author Message
 Make Table Query from Linked SQL Table

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



Sun, 22 Oct 2000 03:00:00 GMT  
 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



Mon, 23 Oct 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Changing the linked table path without the linked table manager

2. Access 2000 VBA/SQL - cannot create pseudo-index on linked SQL Server table

3. making and populating a table to a linked backend

4. Making ODBC linked tables non-updatable

5. Linked Table VS Import Table

6. How to run Queries and Reports off Linked Tables

7. Make adp table behave like linked mdb table.

8. How to copy query results to linked table

9. Linking tables vs. Opening tables directly

10. VB using DAO to execute Access query containing a linked table

11. Linked Table VS Import Table

12. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

 

 
Powered by phpBB® Forum Software