• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 646
  • Last Modified:

How to open MS Access .mdb file in Star Office 7

Hi, this is for my work computer. We are running Windows 2000 Pro and just purchased StarOffice 7. We have files created with MS Access (2000) and need to edit them. I have not found very good instructions for this so far. If someone could give me a good 1,2,3 on this I would be super pointedly grateful. What did I leave out?
0
PcVerse
Asked:
PcVerse
  • 4
  • 3
2 Solutions
 
ChipM0nk JGLeaderCommented:
- Export your tables to dbf files.
- Import the data into your star office apps.

I would suggest using MySQL instead of MS-Access and importing your data to it.  There are great front-end tools for MySQL available.

0
 
PcVerseAuthor Commented:
Thanks, I should be able to give that a try tomorrow. Appreciate the fast response.
0
 
gabit25Commented:
So you said that you want to edit the mdb files that you already have:

It is possible to access (load, edit and save) MS Access database files via an ODBC or ADO driver.

The best way is to connect with ADO  since it is probably already installed on the computer's system. If not, please download the latest ADO version package (currently "MDAC 2.8") from Microsoft at the following address: http://www.microsoft.com/downloads/details.aspx?FamilyID=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en

Next open the menu "Tools - Data Sources". In the following dialog, create a new database connection by selecting the [New Data source] button. In the field "Name", enter an appropriate name for the database. As source, choose "ADO" from the list box and enter the following "data source URL":

Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=<path_and_name_of_mdb_file>
(please pay attention to the spelling and you need everything in a single line)

If necessary, please enter a username and a password on the tab page "ADO". Once the connection is successful, a list of all available database tables on the "Tables" tab page will be shown.

Select [OK] to apply the new data source for the MS Access database in StarOffice. This data source can now be used, for example, in a text document with the menu "View - Data source".

Does this help?

Bye,
Gabriel
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
PcVerseAuthor Commented:
Thank you very much for your help. As we did have Access on the other computer, I was able to export and import as Chipm0nk said and I was able to use the information immediately. Gabriel, your answer is literally right, as well, but there is still manipulation from that point that had been difficult for me (it was similar to answers that I have found in the past).... kudos all around.

Great stuff, thanks.

Scott
0
 
gabit25Commented:
Ok no problem, the only thing is that Iget the answer exactly to your question: "We have files created with MS Access (2000) and need to edit them". You cannot edit mdb file in the way that Chipm0nk says.

You should split the point at least.

Bye
0
 
PcVerseAuthor Commented:
gabit ... though it may be true that your answer is valid, it did not work for what I needed at the time. It was the answer I found with Star Office help and the output I got was difficult (for me, admittedly) to work with. I am able to edit the file that was exported as dbf and opened in Star Office, it worked very well and truthfully, I needed the simpler answer. I would be happy to split the points.
0
 
gabit25Commented:
ok.... but it was no problem. Maybe my post was a little upset but .... it's clear that you have to assign the point for the response you consider relevant. So please let the things as they are. :) I mean it, really!

Thanks for your intention and keep in touch! :)

Gabriel
0
 
PcVerseAuthor Commented:
Love, love, love this place. Keep up the good work.

Scott
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now