recommendations re: access/sql server

[Guest]

Hi All.

I have an Access 2002 database, with tables linked to a SQL 2000 Server via
ODBC driver. What is the best way to append data (create a new record) to a
SQL table using data from a local Access table? I've tried append queries,
pass-through queries, and considered creating an Access Project instead, but
I'm having difficulties. Without knowing any details, can anyone suggest the
best approach to this?

Thanks in advance.

steve.

 

[Matthias Klaey]

Hi All.

I have an Access 2002 database, with tables linked to a SQL 2000 Server via
ODBC driver. What is the best way to append data (create a new record) to a
SQL table using data from a local Access table? I've tried append queries,
pass-through queries, and considered creating an Access Project instead, but
I'm having difficulties. Without knowing any details, can anyone suggest the
best approach to this?

Thanks in advance.

steve.

What, exactly, *are* your difficulties? Without any information about
this nobody will be able to help you.
If possible, please post the code of the SQL statements that "give you
difficulties".

Kind regards
Matthias Kläy

 

[Guest]

Thanks for your reply.

I was really just looking for some feedback on the best way of doing this.
I'm not an Access newbie by any means, but I do find myself working out
complicated solutions when simplier ones exist.

In any case, I've come up with a solution on my own. The problem had to do
with key violation errors while running append queries from an Access table
to several tables in an SQL DB. My solution was to append the data to a
single temp table in SQL, and executing a SQL query from that table to the
live tables.

Thanks again.

 

[dbahooker]

the best practice for Access against SQL Server is to use Access Data
Projects


don't listen to these linked table guys; they are a waste of time

Microsoft.public.Access.ADP.SqlServer

thanks

 

[dbahooker]

projects rock

please ask in the projects newsgroup; specific questions