I have a problem that may be related. I've written a program in
MS Access 2000 that grabs data from a dBase IV table and then
displays it on a form. It works fine in a Windows 2000
environment, but I get a run-time error when I run the very same
program in a Windows XP Pro (SP2) environment. All Office
updates and XP updates are installed. This is true for two
separate Win 2000 platforms and two separate XP platforms.
The code where the error is generated is as follows:
-----------------------------------
Dim pPath As New ADODB.Connection
Dim pTable As New ADODB.Recordset
pPath.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\DATA\;Extended Properties=""DBASE IV;"";"
pTable.Open "Table1.DBF", pPath
-----------------------------------
The program bombs on the 4th statement (pTable.Open) when I try
to open Table1. The error that I get is:
Run-time error '-2147217900(80040e14)': Invalid SQL statement;
expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
I can't figure this error out keeping in mind that the program
works fine in Windows 2000 but not XP. Any ideas?
Thanks,
Roger
message Yes it is. Why: are you having problems?
