Thanks for all your input. What finally worked was the sub-query method:

Delete dbo_tblBook_Inventory.* FROM dbo_tblBook_Inventory

WHERE dbo_tblBook_Inventory.Drive_Num in

(select Drive_Num from dbo_tblRHD_Inventory where Date_Verified Is Not...

I have never used the profiler but there is no error generated in SQL server when I run it through query analyzer. Only when I run the statement throught aCCESS.

The errors occurs when I run from ACCESS where these are linked tables and have a dbo_ prefixed. These statements run without any error when run directly on the server. But...

Tried that. Gives me the same error message as before.

Any other ideas ?

Thanku, That worked great.

Thanks . That worked. Now, I have another question for the same field.In some cases, the  same  field has  a value like   this :

CR 12,345 , CR 34,456

and I should...

Is it true that Micrsoft is continuing paid service for VB6.0 for another 3 years ? I could not find anything on their website about it. Is there any talk...

Thanks for all your input.

We have one big application that we are migrating from VB6.0 primarily because Microsoft is stopping support for VB6.0 very soon. Hence in order to...

Serge,

I set mine to 480 which is enough for the maximum amount of data that I transfer.

thriveni

Please refer to point 'a' of my last reply.

The table can have more than one distinct value of Lseries, and that is allowed. For eg, in a group of 10,000...

..continued ( sorry pressed the wrong key )

 A stored procedure from SQL server is called that does the following:

a. creates a cursor that determines the distinct values for field LSeries in...

Hello Charles:

Thanks for your offer to help.

My table structure is :

CREATE TABLE [tbl_group] (

 [StaffID] [int] NULL ,

 [TrackOrderID] [int] NULL ,

 [Qualifier] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [LSeries] [int] NOT NULL...

I have a front end ACCESS program that transfers a table to SQL server and then based on the table  values it has to update multiple tables. The multiple tables' names are...

Thanku for your responses. The tables have  more than two fields in them and the rows will not be exact duplicates in the two tables but they will have exactly...

That's it ! Thanku so much.

I had mine set to 256 character limit display.