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