Hi, Anyone can help me with this problem?
Currently I'm using ADODC connecting to access. But When i key in the following SQL text, I encounter some problem when i tried both of them, Pls guide me.

Ven - table name
Field1 - Row

(Tried) Code:

Select * FROM Ven WHERE Ven.Field1= "'& Text3.Text & '"

Select * FROM Ven WHERE Field1 = "'& Text3.Text & '"

Both can't work, Is the quotes right?
double quotes comes first then single quote ???

Or is there any another way??
Thks & regards.