We just moved the back end of an Access db to an SQL server and upgraded to Access 2000. A strange problem has arisen. The execution of a query in a certain function seems to be causing the function to prematurely terminate (that is, the query does not complete, and the function does not execute beyond the execution of the query). This error occurs only on workstations loaded with Windows 98. Windows 2000 users are unaffected, and the function runs uninterrupted. The query in question contains date parameters. On the SQL server, dates are enclosed in single quotes (')'s, whereas in Access they are enclosed in pound signs (#)'s. When a query is sent by Access to the SQL server, it is filtered through a program that converts the Access format to SQL-friendly code. Our theory is that this process fails to occur on the machines running Windows 98. Does anyone know why this is occuring?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Windows 98 vs 2000
- Thread starter marshw
- Start date
Cagliostro
Programmer
Create on root dorectory on drive c: the file MySQL.ini with content:
[mysqld]
basedir=driveLetter:/MySQLsDirectoryName/
Also is good to install MyODBC. John Fill
ivfmd@mail.md
[mysqld]
basedir=driveLetter:/MySQLsDirectoryName/
Also is good to install MyODBC. John Fill
ivfmd@mail.md
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question