Re: opening ole db databases in access

From: Mike Wilson (mikewse_at_h_o_t_m_a_i_l.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 13:18:22 +0100

Ok Brendan, thanks.
It seems using Access will not help my very much with what I
want to do - in an easy way examine the structure of the
database I have at hand (and which is unknown to me).

It looks like all the options I have require me to already
have learned the things I wanted to know in the first place
(database schema etc) through ADO coding, so then there is
no reason to involve Access.

But it is a bit suprising, isn't it, that Access 2003
doesn't natively support OLE DB providers when this is the
"chosen technology of the future"? :-)

Mike

"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message
news:uobSDO%23xEHA.1192@tk2msftngp13.phx.gbl...
> To the best of my knowledge, you can only create linked tables using
> either Jet or ODBC. If your data source is not supported by Jet and there
> is no ODBC driver, then the only way to access the data will be via ADO,
> as in the examples you have seen. To make that data available in Access,
> you could try binding forms and reports to ADO recordsets, or using
> unbound forms, or importing the data into local Jet tables and binding the
> forms and reports to those.
>
> --
> Brendan Reynolds (MVP)
> http://brenreyn.blogspot.com
>
> The spammers and script-kiddies have succeeded in making it impossible for
> me to use a real e-mail address in public newsgroups. E-mail replies to
> this post will be deleted without being read. Any e-mail claiming to be
> from brenreyn at indigo dot ie that is not digitally signed by me with a
> GlobalSign digital certificate is a forgery and should be deleted without
> being read. Follow-up questions should in general be posted to the
> newsgroup, but if you have a good reason to send me e-mail, you'll find
> a useable e-mail address at the URL above.
>
>
> "Mike Wilson" <mikewse@h_o_t_m_a_i_l.com> wrote in message
> news:41925cb7$1_5@127.0.0.1...
>>I have looked at that alternative and it only works for
>> ODBC connections, not OLE DB, and thus doesn't solve my
>> problem...
>>
>> Mike
>>
>> <anonymous@discussions.microsoft.com> wrote in message
>> news:57fc01c4c71e$8bd317b0$a301280a@phx.gbl...
>>> you might try to link to the tables. with linked tables it
>>> would amount to the same as opening the database in access.
>>> you would be able to use access features on it's data.
>>>
>>>>-----Original Message-----
>>>>Is there a way to open an OLE DB database from within
>>> Access?
>>>>I would like to use the Access GUI with its table and
>>> query
>>>>explorer to examine a database only available through an
>>> OLEDB
>>>>provider interface.
>>>>
>>>>I have seen several references on how to open an OLE DB
>>>>database through VBA/ADO code but I wouldn't know how to
>>> go
>>>>from there to actually have the database available in the
>>>>Access GUI...
>>>>
>>>>Background: the database is of Visual Foxpro 8 "free
>>> table"
>>>>format and I only have the set of files comprising the db.
>>>>Apparently the Foxpro ODBC driver only supports up to the
>>> 6.x
>>>>version of Foxpro, and from there you have to use the OLE
>>> DB
>>>>provider interface. I have succeeded in opening tables
>>> into
>>>>Excel by using the Foxpro OLE DB provider, but have yet
>>> not
>>>>found a way to open them into Access.
>>>>
>>>>Cheers / Mike
>>>>
>>>>
>>>>
>>>>
>>>>----== Posted via Newsfeeds.Com - Unlimited-Uncensored-
>>> Secure Usenet News==----
>>>>http://www.newsfeeds.com The #1 Newsgroup Service in the
>>> World! >100,000 Newsgroups
>>>>---= East/West-Coast Server Farms - Total Privacy via
>>> Encryption =---
>>>>.
>>>>
>>
>>
>>
>>
>> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
>> News==----
>> http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000
>> Newsgroups
>> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---
>
>

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Relevant Pages

  • Re: [Access2003, VBA] Use DAO or ADO?
    ... One of the reasons my clients preferred Access / Jet / ODBC was that they ... Autonumber or its server equivalent and could have been shown to the users ... real world of development, Dot Net", ADO has been superceded by ADO.NET ...
    (comp.databases.ms-access)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... ODBC, whatever the back end. ... to a jet backend to open a ado recordset. ... customers want/need sql server and another wants to use MySql. ...
    (comp.databases.ms-access)
  • Re: Replacement for Dao
    ... roy fine ... the application uses Jet database or SQL server. ... > that Jet actually provides ADO support through its ODBC (I am still ... > was straight forward in Dao) and hence ODBC may perform better than ADO. ...
    (microsoft.public.vc.database)
  • Re: ODBC Refresh Interval
    ... isn't a huge deal most of the time), is that I can't rely on FindFirst! ... a form bound to an ODBC linked table, ... with Jet x.y, or Jet y.z, or whatever. ... ADO is dead, of course. ...
    (comp.databases.ms-access)
  • Re: Multiple Criteria syntax for Find Method
    ... Brendan, I tried your ADO example but I am getting a Type Mistmatch on this ... the form is a DAO recordset and I am trying to set it to ADO? ... >> If your recordset is a clone, it is instantiated when you clone it. ...
    (microsoft.public.access.modulesdaovba)
Quantcast