Queries to an Access db from vs2005

  • Thread starter Thread starter Max
  • Start date Start date
Hi,

max said:
Hi,

Bart Mermuys said:
Hi,

max said:
Hi Robin,
I have an access db; in my form I have a textbox; on it, click on data
menu, added a new query, gave it a name and put it in query text:
SELECT * FROM table WHERE name LIKE name + '*' (I'm not really sure it's
the right syntax for querying an access db).

Try:

SELECT * FROM table WHERE [name] LIKE ? + '%'

JET uses unnamed parameters (?) and % as wildcards.

HTH,
Greetings

It works fine!
I just add a query from the TableAdapter Icon using the query wizard,
paste the code you wrote, then designer adds a button and a textbox, and I
wrote on it just some digit to get the results I was expecting!
It was an Access issue. I didn't expect it was so hard to work with Access
db in VS2005, I find only sql samples in internet...
Do you know a place where I can learn more about SQL statements for Access
db in a VS2005 environment?

Sorry for the late reply, but unfortunately i don't know such place. But
there is a jetsql reference file, if you have Access2003 installed, do a
local search for the JETSQL40.CHM file.

HTH,
Greetings
 
Back
Top