SQL Statement Works on Win 2000 not Win 98 Machine

[timsledge]

I'm updating an Access database developed by another programmer. Some of the forms use SQL statements to create the recordset behind the form. When I install the db with the runtime version of Access, the SQL statements work on a machine using Win 2000, but not on a machine using Win 98. What am I missing? Thanks

 

[jgoodman00]

The obvious suggestion is one of the reference libraries. You should check all the necessary libraries are installed. If you attempt to compile the app on the win98 machine (not sure if this is possible on runtime access), it will flag any missing references.

Another problem I have encountered across these platforms is in the use of the Environ function. Certain functions (I believe Environ("UserName&quot is one, will not work in Win98...

James Goodman

 

[cmmrfrds]

If the program is using ADO, which uses the MDAC libraries, then you may need to download the MDAC from Microsoft. MDAC is built into the Windows 2000 OS but not necessarily the Win 98 OS. If you find the ADO library under references you should be okay. If the program is using DAO objects make sure one of the DAO libraries is checked under references.