I see why its working now!...

I don't see an error when I execute the following in Management Studio:

USE PUBS

GO

DECLARE @sql VARCHAR(2000)

,@fnam VARCHAR(20)

SET @fnam='Paolo'

SET @sql = 'SELECT fname,lname FROM employee WHERE fname= '''+ @fnam + ''''

PRINT @sql

EXEC (@SQL)

Edit : You'll see...

Perfect! Just something I needed!! Thanks Luiz!

WILLIAM MITCHELL (2/7/2008)

---

If you have a corrupted memo field, compact & repair cannot fix that.

The usual fix is to locate the bad record, copy all fields from that record...

Matt Miller (2/7/2008)

---

Question is - could you run that update from within Access itself?

OLE being what it is - there are some provider specific errors that don't get past back...

Or do you think it was this very record with date 2/2/707 that was the problem throughout??? Like that's an invalid argument, maybe!

Any thoughts??

UPDATE My_LinkedServer...My_AccessTable

SET ID = @MaxID + T.Rank

FROM #Temp T

WHERE Address = T.a

gives me the same error, Matt!

And I did try the Compact and Repair tool... doesn't help!

There was an invalid...

UPDATE My_LinkedServer...My_AccessTable

Set ExportedFlag=0

This is just one of the several update queries that throws this error. In every case, its the same table that's causing the problem..

And like I said,...

FYI

This is something i googled...

3001 - Invalid argument. This one typically happens when clicking on a corrupted record within a table. Or by running a query or form against that...

Whoa! Thanks!

And I had no clue about the EXISTS keyword.

Perfect! Thanks again!

OK.. Like I said, application throws this error on Export to SQL (from Access).

I decided to debug the SP to see the exact point of error.

This is what I found:

The...

Could you tell me how exactly I'm supposed to know if my tempdb is full?

It's set to unrestrictive growth by default, right?

And what about the Temp folder? When does...

There was an existing application by the same name in the system.. therefore a folder by that application name in registry.

The Import module connection string was picking up 'null' as...

Thanks! I will definitely check it out..

The problem has been resolved for now. The tester was just being a jerk. No need to elaborate further.