James,
So you mean you changed from DAO to ADO ?
Last() is a DAO/Jet3.5 function from what I can tell.

You could RS.MoveLast, then read your data.

NickHK

"James McDowell" wrote in message
...
I have SQL that has worked using the Database Object and Recordset
objects.
I have switched to a connection object in place of the database object so
that I am able to define the user and password for the DSN (please do not
suggest going DSNless, can't get it to work). In my original SQL I used
the
line "Last(myDATABASE.myTABLE.myDATE) AS LastOfmyDATE". The SQL worked
fine
when I used a Database object, but I'm not sure why the connection object
does not accept the "Last" functionality. The table has the MyDATE fiels
defined as date/time and I found out earlier today that the connection
object
requires the SQL to be changed to enclose dates in single brackets. Not
sure
if it has any bearing on the subject.
I am pulling records and I need to be able to only pull the last instance
Can anyone suggest a replacement for the last.

Thank you,

Jim