Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connection object vs. Opendatabse on Databaseobject
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Excel crash closing ADO connection object | Excel Programming |