I don't know why it used the old copy / destroy / rename but that sure was the cause of your headaches.

Are you sure you didn't change that after the original question was posted?? 

Are you sure nothing's changed??

Select O.Name from dbo.SysObjects O inner join dbo.SysComments C ON o.id = C.ID and O.XType = 'P' AND OBJECTPROPERTY(O.id, 'IsMsShipped') = 0 AND C.Text like '%YourTableName%' ORDER BY O.Name

Ya like for a homepage... if you were to count out the owner's visit, there would be very little need for the counter .

Agreed. I also support this site, but I don't see much of the money that comes in every month .

Yeah right nothing's changed, I swear .

That's what I said.  You can't do that without running it.  Maybe you can do a general table with 100 varchar columns and insert into that... but that won't come...

We can't really help unless you provide some sample data and the required output.  Once we have that we can get started on a solution.

Do you guys have extacly the same databses on both servers?

Did you try dropping the executions plans and rerunning.

Does it do that on every execution or is is bad only...

Select Main.* FROM dbo.Tbl Main INNER JOIN (SELECT SSN, MAX(Date) AS Date from dbo.Tbl GROUP BY SSN) dtLast ON Main.SSN = dtLast.SSN AND Main.Date = dtLast.Date

No you can't do that... because the sp can have more than 1 result set at the same time, also it can have different results set at each run.

The only...

Tried the old compact/repair?

What happens if you copy those tables to a new access DB and rerun the query?

Last resort.... tried recompiling the application?

Yes, different OS use different row delimiter.  IIRC unix use char(10).  While windows uses Char(10) + Char(13).  Some other might use Char(13) only.

Just paste the char(10) from the clipboard and...

Search the articles on this site.. you'll find quite a few.

There's your answer...

(rptPXA2.DCode) = 1

==

Char(9) = int

===

see rest of my previous explanation for the error.

Once you try with '1' it'll work.

Good afternoon.