I posted this problem 4 or 5 days ago in forum "Visual Basic (Microsoft Databases) under thread709-260314 and decided to post it here now to see if I can get some further attention. If anyone has had this problem and was able to solve it then please let me know how.
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 an answer that will work for the above set-up only - not for Microsoft ACCESS!
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.
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 an answer that will work for the above set-up only - not for Microsoft ACCESS!
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.