“System.Data.OleDb.OleDbException: The Microsoft Jet database engine could
not find the object 'NextBackupTime'. Make sure the object exists and that
you spell its name and the path name correctly.”
If I change the query to be:
"SELECT Backups.NextBackupTime, Backups.NumberToKeep FROM Backups;" then I
get the following error:
“System.Data.OleDb.OleDbException: The Microsoft Jet database engine could
not find the object 'Expr1001'. Make sure the object exists and that you
spell its name and the path name correctly.”
This problem seems to happen regardless of the datatypes being returned from
the database - I have tried to query text fields as well with similar results.
Does anyone know why this is happening and what I can do to have the query
work for any of the regional and language settings?
Thanks.
SELECT Backups.BackupLocation FROM Backups;
will return the same type of error:
"System.Data.OleDb.OleDbException: The Microsoft Jet database engine could
not find the object 'BackupLocation'. Make sure the object exists and that
you spell its name and the path name correctly."
and the datatype is Text and the size is 250 (Using Access). It doesn't
seem to matter what the datatype is that I am returning. I even created a
small table that had only one field of type text and the same problem
happened.
Thanks.