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 =--- 3  3056 
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:uo****************@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:41**********@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
<an*******@discussions.microsoft.com> wrote in message
news:57****************************@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 =---
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.
"Mike Wilson" <mikewse@h_o_t_m_a_i_l.com> wrote in message
news:41**********@127.0.0.1... 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:uo****************@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:41**********@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
<an*******@discussions.microsoft.com> wrote in message
news:57****************************@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 =---
Well, I don't think the interesting comparison is which
particular API is used to access the database in this case,
as long as it gets the job done.
I don't care if Access would use ADO or OLE DB directly
when letting me work with my OLE DB provided database in
the same way it lets me work with my ODBC sources.
The problem is that it uses neither.
And I still think it is very surprising that Access will not
import tables from an OLE DB provider, while Excel and Word
can do it... ;-)
Mike
"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message
news:eO****************@TK2MSFTNGP14.phx.gbl... 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.
"Mike Wilson" <mikewse@h_o_t_m_a_i_l.com> wrote in message
news:41**********@127.0.0.1... 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:uo****************@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:41**********@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
<an*******@discussions.microsoft.com> wrote in message
news:57****************************@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 =---
----== 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 =--- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Wayne Aprato |
last post by:
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:
"The Visual Basic for Applications project in the database is
corrupt."
...
|
by: Ralph2 |
last post by:
I made some Access 2K databases using Windows98SE, now I am making
some modifications and find myself inundated with Microsoft Warnings.
Windows 2000 Pro and Office 2003 all updated with the latest...
|
by: MLH |
last post by:
If I give someone a runtime app,
they can open the database
window by pressing the F-11
key. How to prevent???
|
by: nsharish20 |
last post by:
Hi,
I have an Access database file with all the switchboard commands and
what I want to do is to try to access the switchboard command without
opening microsoft access. Which means i want to...
|
by: rdemyan via AccessMonster.com |
last post by:
I'm getting the following error message both when opening and closing my dB.
The Microsoft Jet database engine cannot find the input table or query
'MSysAccessStorage'. Make sure it exists and...
|
by: John |
last post by:
Hi
In my vb.net app I am trying to open a db via DAO as below;
Imports dao
Dim dbSynch As dao.Database
dbSynch = DBEngine(0).OpenDatabase("C:\MYDB.MDB")
|
by: Phil Stanton |
last post by:
I have a form with a button which is supposed to open an Excel file (With
lots of Macros /VBA) in it. The Excel file gets it's data from the Access
program
Here is the code
Private Sub...
|
by: janders468 |
last post by:
Hi,
I have been messing around with automating Access (I am attempting to actually manipulate the Access objects themselves so it requires going beyond data access) from a c# program (long story...
|
by: Samuel |
last post by:
I have some questions that are sort of connected. I use Access 2003.
Is it possible to set some properties that can make the Access window
open at a particular size?
Is it possible to make a...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
