Access 2003 and SQL Server 2000 Linked Tables

[mike]

I have a database in Access 2003 where I have all my code written. In
that database I have some linked tabled (through ODBC system) from SQL
Server 2000.

I am running a "INSERT INTO

Select" query from Access, where I
want the data to be inserted into the linked table to SQL Server.
However, when I run this query Access deletes my linked table and
creates a new table IN ACCESS by the same name.

I am curious how I can get Access to send the new rows to SQL Server
via the linked table instead of deleting my link and creating its own
table locally.

Thanks so much!

Mike

 

[Brendan Reynolds]

I haven't been able to reproduce this. When I execute the following query
....

INSERT INTO dbo_Employees ( LastName, FirstName )
SELECT EmployeesLocal.LastName, EmployeesLocal.FirstName
FROM EmployeesLocal;

.... where 'dbo_Employees' is a link to the SQL Server Northwind Employees
table, and 'EmployeesLocal' is a local Jet table, records in the local table
are appended to the linked table as expected.

If you can post the SQL for your query and tell us how you are executing the
query, someone might be able to see what the problem is.