Steve, you say to wait till 09:00 AM.  The server time is now 12:39 AM.  Is something wrong?

If you are willing to look at somebody from SA, let me know.

jbotma@namakwa.co.za

Maybe you will understand this syntax easier: You do not need grouping because of the sub-select.

update products

set qty = a.qty - (select sum(b.qty) from invoice_product b where b.product_id = a.product_id)

from products a

To summarize:

Create a Temp table with an autokey and the other fields you want to output.  Then run : INSERT INTO TempTable SELECT Field, Field ... FROM MainTable ORDER BY...

Paul, you say you are worried about data traffic so just something to watch out for:  I havn't used Access for about 3 years, but one of the things it...

I have taken your advice and tried different drivers like: MS OLEDB provider for Oracle, Oracle provider for OLEDB, MS ODBC Driver for Oracle and the Oracle ODBC Driver, but...

Coincidence? I don't think so...

The datatypes are char (30) on both sides. My collation name on SQL is SQL_Latin1_General_CP1_CI_AS.

When you are using a temp table there is a way to do row by row processing without using a cursor:

DECLARE @Key ....

SELECT TOP 1 @Key = tKey FROM #Temp

WHILE...

If you got the error message by looking at the job history details, then you already know which dts package is causing the problem.  The only way to determine which...

The package is run by the SQL Service Agent when it is fired from the scheduler.  So you must check the rights of the SQL Service Agent.

Also, what SQL version...

I think DTS (Import objects) will be the best.  Save the package because they might want to do it in the future again.

You can move the tables to sql and link them back to access.  Your web pages will not see the difference. (Except maybe a little faster and more secure.)

Of course, before you can do any of that, you need to install the Oracle Client software (The network portion) and using the Net Configuration Assistant, add a local net...

Of course, before you can do any of that, you need to install the Oracle Client software (The network portion) and using the Net Configuration Assistant, add a local net...

Of course, before you can do any of that, you need to install the Oracle Client software (The network portion) and using the Net Configuration Assistant, add a local net...