DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: executing procedure in ms Access from VB6

  1. #1
    ery d Guest

    executing procedure in ms Access from VB6


    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

  2. #2
    Paul Clement Guest

    Re: executing procedure in ms Access from VB6

    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)

  3. #3
    Anthony Jones Guest

    Re: executing procedure in ms Access from VB6

    >How can I call Ms Access procedure in module,

    You can't.

    --
    Anthony Jones
    Secta Group Ltd




  4. #4
    jy Guest

    Re: executing procedure in ms Access from VB6


    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



  5. #5
    Anthony Jones Guest

    Re: executing procedure in ms Access from VB6

    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




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center