MS Jet Database Engine could not find the column 'colText'

[Orgil]

Hi all,

I have made many applications using Delphi 6.0, Delphi 7.0, MS VS.Net
2003, MS VS.Net 2005 and MS Access 2000 - 2003. But all of my
applications have following error on some computers (machines).

The error message: MS Jet Database Engine could not find the column
'colText'

I have this problem for two years. But I can't stop this error
occurring, however I've done everything I can.
I quess that OS (Windows XP with SP2) of those computers have
corrupted MS Jet Database Engines and the MS JET is core object of
this problem but not MS Access, Programming languages and Programing
tools.
Also, I have known that MS Jet can't find the column that is the first
not numeric column of a table.

for example:
Table 'tTable1' has 3 columns. Column 'id' is autonumber and primary
key. Other 2 columns' types are Text(50).
When I execute a query "SELECT id, colText, colText2 FROM tTable1"
then the error occurs on column 'colText'.
If I change the query to "SELECT id, colText2, colText FROM tTable1"
then the error occurs on column 'colText2'.
In all cases of the query, the column 'id' is out of the error.

Help me guys !!!!!!
Any suggestion will be highly appreciated.

 

[Albert D. Kallal]

Hum, I don't have any suggestions, but the error msg you get is simply that

columns colText, and colText2 don't exist in the table....

Switching coltext & colText2 around simply means you get the "1st" field
that not defined in the table.

I would double check the field names in the table design. If your creating
this table via code, perahps a space is in the field name(s)???

 

[Orgil]

Thanks your reply Albert!

That error occurs some few computers. Not all computers have the
error. So I think that my application and database are all fine.
In addition, my applications run finely on my computer.
the computers, have the error on my applications, are all with Windows
XP SP2 same as other computers and my computer.
The problem which I've finding 2 years is just here.

If you have not any suggestion still now, you would may tell my
problem with your friends.