Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Jet error

 
   Database Help (Home) -> Visual Basic -> DAO RSS
Related Topics:
Error 3043 - We are an older app written in VB 6.0 (sp5), with Jet 3.51 connected to Access 97 For most users, the system works great, but at a few sites we hit error 3043 which then causes the dreaded 3343 error. At one site, this seems to..

Error Trapping - I am trying to trap the error that raises when you attempt to query a database that does not exist. noted that does contain the value of how many errors have happened. Just cant seem to catch the error so that It can be handled..

error 3265 - can anyone pls tell me what to do? i have done all the that need to be done, but this error keep (error 3265) please help -- This article was posted by author's request Articles checked for..

DAO360 Error - My access an mdb database using dao360 and works fine in the VB6 SP6 IDE. When I create a package and try to run it it fails at the first attempt to access a field value. The is correct and works, but..

Error 3146 (VB6) - I am opening two iterating through a table in one of them and making queries to copy the data to a table in the second (using the execute method). The machines are both on the same network segment. I am getting error..
Next:  VB 2008 Professional and SQL Express Questions  
Author Message
MikeR

External


Since: Jan 12, 2008
Posts: 27



(Msg. 1) Posted: Wed Feb 20, 2008 7:36 pm
Post subject: Jet error
Archived from groups: microsoft>public>vb>database>dao (more info?)

I've just started getting this error message on a seemingly random basis.
'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or
expression.'
CID is a text field, and it is a valid column name.

The line of code that generates the error is
ListRec.FindFirst('CID = "' + retCID + '"');

The database (Access 2K) is opened like this:

dbE := CreateOleObject('DAO.DBEngine.36');
//open Jet
try
dbDAO := dbE.OpenDatabase(WritePath + FOLDER_NAME + DBName, True, False, ';pwd='
+ '');
except
on E:Exception do
begin
MessageDlg('Error opening database.'#13#10 + E.Message, mtInformation, [mbOK],0);
Result := False;
Application.Terminate;
exit;
end;
end;

ListRec is a recordset, opened with

procedure TfrmLog.OpenCountry;
var
sql: String;
begin
sql := ('Select * from C_List order by CID');
try
ListRec := dbDAO.OpenRecordSet(sql);
ListRec.MoveLast;
except
on E:Exception do
begin
MessageDlg('Error opening Country table.'#13#10 + E.Message, mtInformation,
[mbOK],0);
exit;
end;
end;
end;

The only thing Google brought up wasn't what I need to solve this.
TIA,
Mike

 >> Stay informed about: Jet error 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]