Re: How to Call MS Access Form through VB 6

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Carlock (anonymous_at_127.0.0.1)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 12:08:20 -0400

Develop the form in VB and use a VB form to access Access.

You can use ADO, DAO and / or RDO in this manner. You
will be able to run internal Access queries to extract tables, will
be able to execute Access action queries, will be able to open
recordsets.

You can use the SQL that is created by Access to develop
parameterized queries for VB. With some slight modifications
to these parameterized SQL everything is within reach. 

-- 
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.
"Dib" <dshahene@consoftware.com> wrote in message news:u3Ew99%23REHA.2704@TK2MSFTNGP10.phx.gbl...
Thanks for your reply.
What are my options here since my Back end is SQL Server version 7.
Thanks
Dib
"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:rs7pb01s0mj0oe42n3af5acb2fcg6m2ai7@4ax.com...
> On Tue, 1 Jun 2004 10:23:04 -0400, "Dib" <dshahene@consoftware.com> wrote:
>
> ¤ Hi, Can anyone help with a syntax on how to call an MS Access 2000 Form
> ¤ through Vb 6.
> ¤
> ¤ I am using ADO connection in VB and would like to use the same
connection
> ¤ for the Access Form when the Form is Opening.
> ¤
> ¤ The Access will contain a Form and a Sub Form.
>
> You can use automation with DoCmd and the OpenForm method. You can't
really use an ADO connection
> since Access objects use the Jet database engine directly.
>
> OFF97: Using Automation to Run Microsoft Access
> http://support.microsoft.com/default.aspx?scid=kb;en-us;167472
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: How to Call MS Access Form through VB 6
    ... "Jim Carlock" wrote in message ... > will be able to run internal Access queries to extract tables, ... > to these parameterized SQL everything is within reach. ... I am using ADO connection in VB and would like to use the same ...
    (microsoft.public.vb.general.discussion)
  • Re: How to Call MS Access Form through VB 6
    ... > will be able to run internal Access queries to extract tables, ... > parameterized queries for VB. ... > to these parameterized SQL everything is within reach. ... > really use an ADO connection ...
    (microsoft.public.vb.general.discussion)
  • VC++6, ADO, Purify
    ... I have a DLL that I am writing some C++ classes to wrap some ADO ... These essentially allow one to execute simple SQL ... Select queries and access stored procedures. ...
    (microsoft.public.data.ado)
  • Re: ADO Copy Table to new MDB Help!
    ... Dim sql As String ... ADO is simply connecting to JET and asking JET to do the ... DBEnginecan each be used instead of the created ADO connection. ...
    (comp.databases.ms-access)
  • Re: crosstab, ADO and VB
    ... through ADO it doesn't work. ... ADO will not run MS Access PIVOT queries using only the name of the MS ... You'll need to view the query as SQL, ... If you don't want to copy the PIVOT text and run the query using its SQL ...
    (comp.lang.basic.visual.misc)