problem to SELECT using Microsoft Access (sent again, connection problem)

problem to SELECT using Microsoft Access (sent again, connection problem)

Post by Rober » Mon, 15 May 2006 22:26:50

I am posting my question again, because I got a message, saying that
my message is invisible for most of the user. I am using Forte agent
and I can read my message.

I am apologizes if I am asking this question again and again. I
browse quickly the messages, but cannot find similar question:

I Want to make simple SELECT statement against Microsoft Access table.
Everything is very simple, the table has two column and I want to do:

SELECT Colimn2
FROM Table
WHERE Column1 = 'XYZ'

In my Delphi source code I have TADOConnection and TADOQuery
component. Next is my source code:

procedure TForm1.Button1Click(Sender: TObject);
sDB: string;
sDB := (ExtractFilePath(Application.ExeName) + 'Test.mdb');
adoConn.ConnectionString :=
'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=' + sDB + ';' +
'Mode=Share Deny None;' +
'Extended Properties="";' +
'Persist Security Info=False;' +
'Jet OLEDB:System database="";' +
'Jet OLEDB:Registry Path="";' +
'Jet OLEDB:Engine Type=5;' +
'Jet OLEDB:Database Locking Mode=1;' +
'Jet OLEDB:Global Partial Bulk Ops=2;' +
'Jet OLEDB:Global Bulk Transactions=1;' +
'Jet OLEDB:New Database Password="";' +
'Jet OLEDB:Create System Database=True;' +
'Jet OLEDB:Encrypt Database=False;' +
'Jet OLEDB:Don''t Copy Locale on Compact=False;' +
'Jet OLEDB:Compact Without Replica Repair=False;' +
'Jet OLEDB:SFP=False';

with ADOQuery1 do begin
' SELECT Column2' +
' FROM Table' +
' where Column1 = :param1';

Parameters[0].DataType:= ftString;
Parameters[0].Direction:= pdInput;
Parameters.ParamByName('param1').Value:= 'THREAT_EVENTS';


On open ADOQuery1 I got an exception:

Project Project1.exe raised exception class EOleException with message
'No value given for one or more required parameters'.

I thing something is wrong in my source code. I know Microsoft Access
has very odd rules.
I will appreciate if someone could help me.

Thank you.


1. Little problem: Can't stop "remote access connection manager" service after using vpn connections

2. problems sending mail using wireless connection

I am having intermittent problems since starting to use wireless.
Inbox works fine but stuff stays in Outbox without being sent. The
error message is:
Your server has unexpectedly terminated the connection. Possible
causes for this include server problems, network problems, or a long
period of inactivity. Account: 'Matthew ', Server:
'', Protocol: SMTP, Port: 25, Secure(SSL): No,
Error Number: 0x800CCC0F

Any help gratefully appreciated.


3. Problems sending emails to everyone using a sattelite connection

4. Microsoft access sending emails from within access by using outloo

5. Sending emails from Access - problems with Microsoft Exchange and vbSendMail.dll

6. sending mail using microsoft outlook problem

7. Connection problems using Linked Server with OpenQuery to access Analysis Server

8. Problems, problems, problems...Access 2002 into Access 2000

9. How to send again (or re-send) in Microsoft mail?

10. Problem: Using Windows Service to access Outlook to send mail

11. Using Microsoft Access via Excel VBA, Houston we have a problem

12. Using ACCESS 2003 to send Email with Outlook 2003 - PROBLEM

13. Problem with export report in Excel - Problem Microsoft Access

14. Problem with .send from microsoft example for vba send mail from e

15. problems editing SQL Server database using Microsoft Access 2002 as a front-end