Rob Clement wrote:
Barbara Duprey wrote:
Rob Clement wrote:
Barbara Duprey wrote:
Rob Clement wrote:
Hi
I wonder if you can help me. I am trying to read an Access 2007
database
from OpenOffice 3.1 on a computer running MS Windows Vista SP2
I am getting an error "The connection to the data source xxxx
could not
be established. Function sequence error" (where xxxx is the name
of the
openoffice base I have chosen to use.)
You will probably get the most useful information from the Wiki
page http://wiki.services.openoffice.org/wiki/MSA-Base_Faq. It has
a good description of how to make this work, what the limitations
are, and so on.
<snip>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Barbara
That was an extremely helpful link. It helped me to find the
OpenOffice Wiki on "Connecting to Microsoft Access". The example is
from Windows XP and where I am coming unstuck is in the "additional
initializations for the OLE DB provider". The example for mdb is
helpful as a pointer but there is something I cannot find that needs
to be entered in the all tab of the data link properties of the ADO
database that I cannot find on the Microsoft site or any other that
I have searched in Google.
As soon as I click OK for the setup of the ADO database, in spite of
the fact that I have entered my database location, I cannot get the
Datsource URL to be displayed or the Next button to be usable.
I feel I am a little closer but not there yet.
thanks
Rob
Hi, Rob, glad that link gave you some more help.
It sounds as if you're using the ADO connection type for an Access
2007 database, right? Have you already tried the connection that's
specifically for Access 2007 (bottom of the connection type list, on
my OOo 3.0.1/VistaHP setup)? I don't have any such databases to play
with, but that may work better, if you haven't already tried it.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Barbara
Yes I have. In step 1 I select the Access 2007 and select Next.
In step 2 I browse to the Accdb and select next. In step 3 I select
Finish. I am then presented with a screen to select where I create and
ODB database and the name.
I get an error message "The connection to the data source xxxx could
not be established. Function sequence error." Where xxxx is the name
of the ODB I have chosen.
I can get no further. Openoffice 3.1 then crashes and asks me to
recover any open files when I restart it.
Thanks
Rob
Sounds as if there may well be a bug here, Rob -- Drew's usually magic,
and he's having trouble too. But you're in good hands now (not mine!)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
