Search results for query: *

Hi Everyone, We have a MS Access application which connects to a DB2 LUW database backend. It appears that whenever the database.OpenRecordset command is executed the application opens a new connection to DB2 to perform the query. Is it possible to just open one connection and reuse it? I...

Hi Everyone, I have a question regarding the data types that appear next to the fields in the drop down when selecting the field to link your subform and form on. Both my form and subform are bound to queries which essentially query the same table. I'm trying to link the two together using the...

Thanks vbajock...I tried what you suggested and I was able to add a new record so it appears DB2 is returning an updateable recordset.

Hi Everyone,I am in desperate need of some assistance from the experts here. I'm working on a project to convert an existing application from Oracle 8.1.7 to DB2 9.7 on windows. The application has a MS Access 2000 front end. The current implementation on Oracle works fine. Here is the issue I...

Hi Everyone, I am in desperate need of some assistance from the experts here. I'm working on a project to convert an existing application from Oracle 8.1.7 to DB2 9.7 on windows. The application has a MS Access 2000 front end. The current implementation on Oracle works fine. Here is the issue I...

I was wondering if anyone else has come across an issue trying to open a form that contains a DB2 LUW recordset using the acFormAdd argument to open the form to a new record. The exact same code works fine against a Oracle recordset but for some reason doesn't for DB2. My code ends up failing...

Hi Everyone, I've inherited a MS Access 2000 mdb database. I can recompile the vba modules without any issue but run into problems when trying to create the mde. I sometimes receive the popular "Microsoft was unable to create the mde" message. Sometimes it does create the mde but once I go into...

Hi Everyone, I'm having an issue trapping a ODBC timeout coming from a SQL Pass through query. The query times out but the subroutine isn't capturing the error message. It just continues with the next line of code. The subroutine does have the On Error check in it. The results of the pass...