Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Orgil - 26 May 2008 11:43 GMT
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 - 26 May 2008 12:20 GMT
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)???

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Orgil - 28 May 2008 08:40 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.