opening ole db databases in access

G

Guest

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.
 
B

Brendan Reynolds

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.
 
B

Brendan Reynolds

Not really, no. VB doesn't. VB.NET doesn't. C# doesn't. They all access
OLEDB providers via ADO or ADO.NET. The only people I ever heard of working
directly with OLEDB is C++ programmers, and if you think learning to work
with OLEDB via ADO is a pain, I hear working with OLEDB directly is a real
nightmare.

--
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.
 
M

Madeiras

It can be done, but it's not pretty.

- Create a project that connects to MSDE2000 (has to be local).
- Menu File -> Get External Data -> Link Tables
- "Create Transact SQL" [Next ->]
- Select "+Connect To New Data Source.odc" [Open]
- Select "Other/Advanced" [Next ->]
- Select OLE DB Provider [Next ->]
- Select Database [Next ->]
- Link Tables [Next ->]

Should Work, I guess MS does not want Access to use other OLE DB Providers.

Felipe
 
Top