Database link

The place to post if you need help or advice

Moderators: ChrisThornett, LXF moderators

Database link

Postby Nevil_Devon » Thu Sep 06, 2012 4:00 pm

I have a dual-boot setup, with Ubuntu12.04 and Windows7.
I have a MSAccess2000 dbase on the Windows7 partition.
I want to view and sort the tables in Ubuntu, not edit them. What is the easiest way to do this? I can view the tables using MDB File Viewer, but cannot sort them.
Nevil, Devon
Nevil_Devon
 
Posts: 5
Joined: Tue Sep 27, 2011 9:20 pm
Location: Devon

Postby johnhudson » Thu Sep 06, 2012 9:15 pm

AFAIK there is no Linux program that will do what you want. The nearest possibility is Kexi which will import the Access flles into its own format files and then sort them - but you cannot export them as Access files - but I haven't checked the latest release.

A long term option is to install mysql on Windows because you can use Access as a frontend for mysql (as well as SQL sever). The main problem is that Access only respects blanket security - so you cannot use any of the fine-grained security that a Linux user takes for granted.
johnhudson
LXF regular
 
Posts: 883
Joined: Wed Aug 03, 2005 1:37 pm


Return to Help!

Who is online

Users browsing this forum: No registered users and 5 guests