Recent content by robblack

As it turns out, the above SQL executed in ADODB/JET when called via an ASP script. However, when there is a need to nest SQL SELECT queries (even for the purpose of visulising a recordset) it seems the Access 97 query/SQL editor isn't up to the job. Thanks anyway. Rob.

Something like the following would be good but It doesn't appear to work. SELECT auth_user, count(session_id) as sessioncount FROM ( SELECT DISTINCT auth_user, session_id from tblUserLog ) AS X GROUP BY auth_user ORDER BY count(session_id) DESC

String conatenation will at least be part of your problem: StrSql = "UPDATE TBL_StockEntry SET TBL_StockEntry.[Date Booked In] = Date(), TBL_StockEntry.[State] = me.combobox1.value " & _ "WHERE (((TBL_StockEntry.StockID)=" & StrId & "));" Should read: StrSql = "UPDATE TBL_StockEntry SET...

All, I'm working on a bespoke logging feature for a web portal which records user events in a single table (tblUserLog as illustrated below). id session_id auth_user app_name event remote_addr http_user_agent timestamp 233 1063924932 jim App 1 Some event 10.203.115.30 Mozilla/4.0 (compatible...

Having tried many things (including extending SheetNumber chars to 255), I eventually discovered some erroneous symbols within the SheetNumber field of a particular record. I've no idea how these characters made there way into the database (corruption?) but having updated the offending field...

All, I have inheirited a database which I am attempting to query via an SQL statement: "SELECT * FROM MYTABLE ORDER BY SheetNumber;" This query works fine under Access but when executed thru ADO 2.5 / Microsoft.Jet.OLEDB.4.0 from VB6 it reports the following error ("2147217833"): "The field...

Thanks to all who responded to this post. This problem was complicated by the fact I was using ADO from VB (I appreciate I didn't state this in my original post); as such, I was not able to use any functions contained in Access modules as part of my SQL query. "E.g. SELECT * FROM MYTABLE ORDER...

I have a requirement to sort data of the following format by ref: ref heading ------------------ 1 Section 1.1 Test 1.2 Blah 1.3 Another 1.4 Things 1.4.1 Stuff 1.4.2 Other ... 10.1.1 Something 10.10.1 Else 10.2 Blah blah 2 Some other section 2.1...