LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-17-2007, 10:10 AM   #1
cornish
Member
 
Registered: May 2005
Location: Sussex, England
Distribution: Ubuntu 7.10
Posts: 131

Rep: Reputation: 15
MS Access database


I have created a database using access, that I wish to access as a standalone database from a laptop can anyone start pointing me in the right direction OObase doesnt seem to have any features yet, i.e multi lined combo boxes.

I was thinking of creating a web version of this database but to be run locally from a laptop if this makes sense?
 
Old 07-17-2007, 10:18 AM   #2
lleb
Senior Member
 
Registered: Dec 2005
Location: Florida
Distribution: CentOS/Fedora/Pop!_OS
Posts: 2,983

Rep: Reputation: 551Reputation: 551Reputation: 551Reputation: 551Reputation: 551Reputation: 551
use a better database as access only really works with access and then only semi well.

as for accessing the access data base across a LAN or WAN you will need to figure out a way to host it and keep in mind that only 1 location (computer/user) can use the data base at a time.

you might want to check out MySQL or one of the many other true data base applications/servers out there.
 
Old 07-17-2007, 10:24 AM   #3
cornish
Member
 
Registered: May 2005
Location: Sussex, England
Distribution: Ubuntu 7.10
Posts: 131

Original Poster
Rep: Reputation: 15
I have heard about this MySQL I will look in to it, will I be able to run it on just the one laptop or will it need to be installed on a server?

And then what do I use for creating a gui front end?
 
Old 07-17-2007, 11:29 AM   #4
rickh
Senior Member
 
Registered: May 2004
Location: Albuquerque, NM USA
Distribution: Debian-Lenny/Sid 32/64 Desktop: Generic AMD64-EVGA 680i Laptop: Generic Intel SIS-AC97
Posts: 4,250

Rep: Reputation: 62
Check out ReKall for the GUI.
 
Old 07-18-2007, 04:36 AM   #5
cornish
Member
 
Registered: May 2005
Location: Sussex, England
Distribution: Ubuntu 7.10
Posts: 131

Original Poster
Rep: Reputation: 15
I think im going to look in to creating a web based front end
 
Old 07-18-2007, 09:22 AM   #6
jiml8
Senior Member
 
Registered: Sep 2003
Posts: 3,171

Rep: Reputation: 116Reputation: 116
You can use phpmyadmin for a front end for mysql, and access it via your web browser.

Mysql is a server and can be accessed across the internet. phpmyadmin is a web-based UI client that lets you have full control over mysql without having to learn how to run everything from the command line.

Be careful about security; if you intend it for use only on one box, you should make sure it isn't opening any ports to the internet (iptables will handle this for you or if you are running Windows make sure the firewall blocks its ports).

Access is a really horrible product and you should avoid it. If you MUST use it, look at ODBC drivers; it is possible to get to its data from outside.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to access database created with MS Access on Windows using PHP on Linux Server anjani.78 Linux - Software 1 12-21-2005 06:07 PM
How can access the sybase database? wuzhong Programming 9 12-12-2004 02:28 PM
database access from the internet odious1 Linux - General 3 04-26-2004 08:46 AM
Alternative to MS Access Database. glenn69 Linux - Software 2 08-26-2003 10:59 PM
MySQL Cannot Access Database ChineseElite Linux - General 13 11-27-2002 08:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:01 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration