On 10/07/11 19:13, Olivier Bietzer wrote:
Hello,
1/ You have to define a ODBC connection to your Access database (through
Control Panel - ODBC Connections)
2/ You have to create an OOo Database to connect to it (via OOo Base -
New Database - ODBC Database), then save the odb file
Then you have a connection to the base that you can see by pressing F4
on a writer or calc document
Hope this helps,
Thanks. I was aware of those steps with ODBC. Hence my post because it
just does not work. Attempts to connect fail every time with messages
about missing drivers. Yet the ODBC connection works fine with other
applications, Delphi or VB for example.
Registration of databases has been mentioned. That also fails for me.
Incidentally, the issues are common across OOo and LO.
Anyway, I've given up.
Cheers
Olivier
Le 9/07/2011 0:47, Pierre a écrit :
Before I give up, and I have struggled with this for a week now (off and
on), is there no way to connect to an MS Access database with
LibreOffice or OpenOffice?
Using the inbuilt MS Access connection provision doesn't work. Some
infuriatingly cryptic message about a missing sdbc driver.
Tried ADO, but the connection BROWSE button in the dialog doesn't do
anything.
I have an ODBC connection defined but this also doesn't seem to be
supported.
Very frustrating....
Thanks
--
-----------------------------------------------------------------
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
