1. Why do I get an error using VB6 and DAO when including the ROUND function in a select statement one one computer and not the other - 3085?
2. How to correct?
On Developer PC:
VB6 IDE, NT, MDAC_Typ 2.5, Jet3.5 SP3, DAO 3.51
Database is an MDB '97 (Tables only) - no MS Access application
On PC #2
Win 98, the VB application created with the first PC and installed using P&D, The same MDB ('97 format), MDAC_Typ 2.5, Jet3.5 SP3, DAO 3.51, NO no MS Access
Note: I need and answer that will work for the above set-up only!
I appreciate any help that I could get. I read 2 Kb articles concerning this but the first applied to MS Access 2000, and the second applied to MS Access '97 - but to the application - I wasn't able to figure out how to apply it in my case to my VB program using just an 97 MDB.
2. How to correct?
On Developer PC:
VB6 IDE, NT, MDAC_Typ 2.5, Jet3.5 SP3, DAO 3.51
Database is an MDB '97 (Tables only) - no MS Access application
On PC #2
Win 98, the VB application created with the first PC and installed using P&D, The same MDB ('97 format), MDAC_Typ 2.5, Jet3.5 SP3, DAO 3.51, NO no MS Access
Note: I need and answer that will work for the above set-up only!
I appreciate any help that I could get. I read 2 Kb articles concerning this but the first applied to MS Access 2000, and the second applied to MS Access '97 - but to the application - I wasn't able to figure out how to apply it in my case to my VB program using just an 97 MDB.