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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
