Ask Your Question
0

Cannot open ACCDB file in Libre office? [closed]

asked 2014-10-18 06:26:25 +0200

claire.picouet gravatar image

updated 2016-03-05 09:24:04 +0200

Alex Kemp gravatar image

Hi,

I am trying desperately to open an ACCDB File in Libre office I tried several releases 4.3 , 4.1.2.3 and 4.0.5 without any success have you an idea how to make it works please ?

I followed those advices: https://www.libreoffice.org/bugzilla/...

thanks for your help Claire

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 09:24:15.133719

2 Answers

Sort by » oldest newest most voted
1

answered 2014-10-18 14:04:22 +0200

Regina gravatar image

Your PC has some version of Windows? Then it should work; at least it works for me with LO4.2.5 on Windows 7.

  • Start LibreOffice > Data Base. You are in the Database Wizard.
  • Chose Microsoft Access 2007 in field Connect to existing database. Next.
  • Button Browse. Goto the folder with your .accdb file. Write *.accdb into the data name field. Enter.
  • Click on your .accdb file. Open.
  • Register if you wish, open for editing, save. You get the .odb file.

If you need more options, you can try to use ODBC. For details see https://wiki.documentfoundation.org/F... . The article has not been updated, but the description for ODBC should be still valid.

edit flag offensive delete link more

Comments

There is no "Microsoft Access 2007" in field "Connect to existing database". So what should I do? My libreOffice Version is : 4.2.8.2

clrathnayake gravatar imageclrathnayake ( 2016-02-25 06:49:41 +0200 )edit

Do you work on Windows?

Regina gravatar imageRegina ( 2016-02-27 14:37:10 +0200 )edit
0

answered 2014-10-19 01:45:10 +0200

claire.picouet gravatar image

Hi , thanks for your quick answer I followed the step by step , all was fine until I got this error message:

The connection to the data source "New Database" could not be established. SQL Status: HY000 The connection could not be created. May be the necessary data provider is not installed.

since my database never opened

have any idea what is it? thanks again Claire

edit flag offensive delete link more

Comments

Which of the solutions do you have tried? What is your operating system? I'm not sure and others might help you better, but perhaps you need "Access Runtime" from Microsoft, or for ODBC you need "AccessDatabaseEngine".

Regina gravatar imageRegina ( 2014-10-19 02:27:18 +0200 )edit

Hi Regina, my OS is window 7, Ok I will search some info on those softwares , seems to be a good idea , I have to try thanks again

claire.picouet gravatar imageclaire.picouet ( 2014-10-20 02:19:44 +0200 )edit

Hi everyone, I installed AccessRuntime and AccessDatabaseEngine but my file don't open (for the same reason I wrote above). I decided to open my file via LibreOffice .odb file I created before but still not open correctly cause the software is opening it with LO Writer even if I chose Database file as type file. dont know how to open it now, maybee my only solution is to reinstall Access 2007 in order to open it ...do you suggest me other solution before ? thanks

claire.picouet gravatar imageclaire.picouet ( 2014-10-22 17:44:22 +0200 )edit

Are you sure your .accdb file is not damaged? If you have got Access 2007, then you should reinstall it. Then you can look, whether Access still opens the file correctly. When there is no special reason for uninstalling Access, why not use it? Access has a database called "Northwind" for testing and learning. Can you use that file with LibreOffice? Further help is difficult, without having your file.

Regina gravatar imageRegina ( 2014-10-22 23:31:19 +0200 )edit

ok Regina, I will test this file in Access 2007, after that I will be able to determine if this file has been damaged or not, hope not ! =) thanks again

claire.picouet gravatar imageclaire.picouet ( 2014-10-23 18:53:01 +0200 )edit

had a mistake like claire. then i installed Access Runtime and Access Database Engine and successfully opened my .accdb file in libreoffice (but i dont know which one runs

Yixuan Mo gravatar imageYixuan Mo ( 2019-03-03 03:07:01 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-10-18 06:26:25 +0200

Seen: 21,229 times

Last updated: Oct 19 '14