Recent content by ph74

Thanks Jim. The Database Browser does not work. It shows as connected but with an error? The post is useful, however I am in similar position and can not install any new stored procedures onto the DB server? Looks like this is a brick wall now!! Thanks . Paul

Yes, connecting to the Blue database. I am using Excel but have tried Access with the same error message -- Stored procedure 'sp_odbc_tables' not found. Also with version 15.5 of the odbc drivers there doesn't appear to be anywhere to reference the Interfaces File as with older version of the...

Yes, this used to work with the original drivers. The new drivers are installed and the ODBC test connection works, but can't connect to query db? Paul

Hi, We are currently using Call Pilot Application Builder to define voice prompts for use in symosium. I need to know the length of each message and have searched and searched but can not find the length of the recorded messages. Where do you look find this?? Thanks. PH.

This is the code i currently have at the beginning of the asp page, <% Set DBConnection = Server.Createobject("ADODB.Connection") DBConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\tyne\db-data$\User Details\User Details Data.mdb" 'SQLQuery = "SELECT * FROM Users WHERE "...

Thanks for all the advice, I tried the code supplied and still comes up with the same error? I have also taken the SQL code and run this from within Access on SQL view, and the query runs as expected?? The only difference in FAQ333-4770 is i connect to the database with this: Set DBConnection =...

Thanks for the quick reply. I have checked the data type and they are the same, and i have just done a quick SELECT PositionID FROM Position and i get the same error? What does that mean?? Surely a Select * from any table should work?? Paul.

Can anyone help with the following that I think should be working but just comes back with error'80004005' SQLQuery = "SELECT Users.DBID, Position.Position FROM Users INNER JOIN Position ON Users.Position = Position.PositionID" Any ideas appreciated Paul.

I am using the following INSERT INTO statement, to insert a users RecordID and a CourseID (CSID)into the training table, strInsert = "INSERT INTO training (RecordID, CSID)" & "Values ([RecordID], '" & cboSchedule & "')" DoCmd.RunSQL strInsert The problem being, if there is not already an entry...

Yes, the EndDate will be for the MAX(StartDate). Paul.

There is a field 'EndDate' i need to be able to show in the results.

Thanks for that, however, when I add another field in as you suggestion it changes the results of the query?

I have another issue with this query and can not find an answer the query is as follows, SELECT DISTINCT staff.RecordNo, staff.Surname, staff.Forename FROM staff INNER JOIN [SELECT RecordID, Max(StartDate) AS MostRecent FROM training WHERE courseid=44 GROUP BY RecordID HAVING...

Thanks PH, that has worked a treat.

I have tried changeing the WHERE to WHERE CourseID=44 AND DateDiff("d",[StartDate],Date()) >365 but this does not give the correct results from the Max(StartDate) section?? Paul.