"Sharon and James" <sjbright3@comcast.net> wrote in message
news:tqKdnUbf_OY9YKrdRVn-gg@comcast.com...
> Hi,
>
> Can I connect to an Access DB using the Data Adapter Configuration Wizard?
> How would I fill in the provider information for this?
>
> Thank you.
>
>
> --
>
>

"Sharon and James" <sjbright3@comcast.net> wrote in message
news:YKqdnbkWpJ9sUKXdRVn-sQ@comcast.com...
> Peter,
>
> Thank you. If I enter the absolute path to the DB and include the ext
> (.mdb), I can test the connection successfully. However, when I continue I
> get an error that the connection created does not work with the current
data
> adapter. How can I determine the type of data adabter that is compatible
> with my connection?
>
> Thanks.
>
> --
>
> "Peter van der Goes" <p_vandergoes@toadstool.u> wrote in message
> news:eoeMpnU%23DHA.548@TK2MSFTNGP11.phx.gbl...
> >
> > "Sharon and James" <sjbright3@comcast.net> wrote in message
> > news:tqKdnUbf_OY9YKrdRVn-gg@comcast.com...
> > > Hi,
> > >
> > > Can I connect to an Access DB using the Data Adapter Configuration
> Wizard?
> > > How would I fill in the provider information for this?
> > >
> > > Thank you.
> > >
> > >
> > > --
> > >
> > >
> > First, click New Connection, then click the Provider tab. From the
> provider
> > list, select Microsoft Jet 4.0 OLE DB Provider. Now. when you return to
> the
> > Connection tab, it will simply ask you to fill in the path to the Access
> DB
> > you want to use.
> > Hope this helps.
> >
> > --
> > Peter [MVP Academic]
> >
> >
>
>

"Peter van der Goes" <p_vandergoes@toadstool.u> wrote in message
news:eoeMpnU%23DHA.548@TK2MSFTNGP11.phx.gbl...
>
> "Sharon and James" <sjbright3@comcast.net> wrote in message
> news:tqKdnUbf_OY9YKrdRVn-gg@comcast.com...
> > Hi,
> >
> > Can I connect to an Access DB using the Data Adapter Configuration
Wizard?
> > How would I fill in the provider information for this?
> >
> > Thank you.
> >
> >
> > --
> >
> >
> First, click New Connection, then click the Provider tab. From the
provider
> list, select Microsoft Jet 4.0 OLE DB Provider. Now. when you return to
the
> Connection tab, it will simply ask you to fill in the path to the Access
DB
> you want to use.
> Hope this helps.
>
> --
> Peter [MVP Academic]
>
>

"William Burrows [MVP]" <burrowsREMOVEME@u.washington.edu> wrote in message
news:ej2fKxV%23DHA.3500@TK2MSFTNGP10.phx.gbl...
> Hi Sharon and James,
>
> Use the OleDBDataAdapter for an Access database. As Peter pointed out, the
> provider includes "Microsoft Jet 4.0 OLE DB Provider". The "OLE DB" in the
> provider name is the key term here.
>
> HTH ... bill
>
> PS Peter, sorry to jump into your thread but I am having a hard time
beating
> you to the punch lately :)
>

William Burrows [MVP] wrote:

> PS Peter, sorry to jump into your thread but I am having a hard time beating
> you to the punch lately :)

"DotNetJunkies User" <User@-NOSPAM-DotNetJunkies.com> wrote in message
news:Osjak7pyEHA.3376@TK2MSFTNGP12.phx.gbl...
> i'm having major problems with this part... when i click on new connection

>
> ---
> Posted using Wimdows.net NntpNews Component -
>
> Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup