HELP! VB SQL Design Parameter PROBLEMS Arr

[Billie Boy]

Hi to all.
I’m new here and am coming to you from Melbourne Australia.
So a big
HELLO 2 ALL.

Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at home.

My problem is that it’s driving me NUTS NUTS NUTS.

I am connected to a data connection within my computer that accesses tables & views from a MS Access file.

I have achieved the connection and can run the SQL builder without problems.

My problem is that I CAN NOT, NOT, NOT! Create parameter queries within the SQL builder environment contained in VB.

I should say that I am most comfortable & qualified as a developer in MS Office applications namely Access & Excel and have some VB qualifications as well.

In Access a parameter query is fundamental & easy to achieve.
When I create a parameter query in SQL builder & try to use a placeholder as an unnamed parameter I get this message saying something like this.

“Unable to derive parameter info from provider!”
I have used the help files extensively. I follow the steps but still receive this message.

I am aware of creating parameter characters in the criteria column & indeed the help files recommend using the “[ and ]” characters as parameter placeholders.

But regardless of what characters I use as place holders I can run a parameter query in the SQL builder of VB!

I can successfully run hard coded queries like searching for surnames Where surname like ‘[b]’%

This returns all records within the criteria of surnames starting with b or B.

But when I try to do what even the help files recommend, syntax like

Where surname =?
I get PROBLEMS.

Can anyone PLEASE HELP.

Thanx heaps.
:confused: