executing procedure in ms Access from VB6

[ery d]

Dear all,

I have a question about using ADO :
How can I call Ms Access procedure in module, e.g. : Module1.subTest(name
as string,address as string).
I have tried using this code :
dim adConnection as adodb.connection

...
adConnection.execute "module1.subTest " & strName & ", " & strAddress
....

but it didn't work...

thank you

Ery d

[Paul Clement]

On 13 Jun 2000 00:57:35 -0700, "ery d" <edwiyanto@yahoo.com> wrote:

¤
¤ Dear all,
¤
¤ I have a question about using ADO :
¤ How can I call Ms Access procedure in module, e.g. : Module1.subTest(name
¤ as string,address as string).
¤ I have tried using this code :
¤ dim adConnection as adodb.connection
¤
¤ ..
¤ adConnection.execute "module1.subTest " & strName & ", " & strAddress

Can't do this using ADO, you must use automation:

VBA: How to Run Macros in Other Office Programs
http://support.microsoft.com/support.../Q177/7/60.ASP


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Anthony Jones]

>How can I call Ms Access procedure in module,

You can't.

--
Anthony Jones
Secta Group Ltd

[jy]

may sound a bit backward, but could you try DAO? works great with access,
not surprisingly.
"ery d" <edwiyanto@yahoo.com> wrote:
>
>Dear all,
>
>I have a question about using ADO :
>How can I call Ms Access procedure in module, e.g. : Module1.subTest(name
>as string,address as string).
>I have tried using this code :
>dim adConnection as adodb.connection
>
>...
>adConnection.execute "module1.subTest " & strName & ", " & strAddress
>....
>
>but it didn't work...
>
>thank you
>
>Ery d

[Anthony Jones]

Nope thar won't help either. The only way to execute a procedure in an
access module is to automate a copy of Access to execute the procedure.

--
Anthony Jones
Secta Group Ltd