Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 08-31-2005, 10:25 AM   #16
Randall Slack
Registered: Feb 2005
Location: Rotterdam, The Netherlands
Distribution: Debian - Ubuntu
Posts: 219

Original Poster
Rep: Reputation: 30

Thanks again,

Another option would be to migrate your data to a 'real' database application: MySQL or Oracle and then do the same as above: write a web application using a server-side scripting language such as php, perl or asp if your going to use Windows. The advantgaes of this are a better performing database and if you choose the components carefully - the database app and the programming language you won't be tied down to a specific platform and you could migrate to another OS in the future. In both cases you could run the application over a secure http connection to keep the data away form prying eyes during transmission.
I already figured this to be the best option, and as i understand you can create a similair user-side experience with the same functionality as MsAccess. (already knew on the server-side)

Thats all i wanted too know actually!


MS Access isn't suitable for this purpose and as you can see even in the solution that keeps the mdb database MS Access wouldn't be used. What MS Access is suitable for is a database on a single computer that will be only accessed by one user at a time. That is one computer in an office on its own and everyone queues up outside the office waiting for their turn.
At this moment i use a mdb on the server and created replica's on the client computers, and we can use it simultaniously with 4 people without any problems, only when editing the exact same field at the same time makes it ask wether you would like to drop or save the changes
Old 08-31-2005, 10:37 AM   #17
Senior Member
Registered: Oct 2004
Posts: 1,192

Rep: Reputation: 101Reputation: 101
Okay, I was exagerating slightly on its limitedness as a database app, I am not exactly sure how limited it is - the last time I used MS Access was for a school assignment - though I imagine you can't do much more with it than what you are doing now
Old 09-02-2005, 07:41 PM   #18
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 879

Rep: Reputation: 208Reputation: 208Reputation: 208
To answer a few points:
In place of what M$ calls an "intellisearch", (BRa as in Brazil and NE as in nederland..) using javascript, you can use regular expressions and search using wild cards. Have an example somewhere and will try and post it. Maybe php or perl or python has the capability directly. So M$Access's front end portion can be easily replicated.

As a back end, we all know it's capabilities.

So why the troll?



Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Can OpenOfficeBase 2.0 Replace MsAccess? Randall Slack Linux - Enterprise 6 04-28-2005 01:17 PM
3 General Questions AndrewZorn Linux - Newbie 4 04-02-2005 11:09 PM
few general questions and what now Vid Linux - Newbie 1 01-27-2004 11:10 PM
Some questions in general... kierwind Linux - Newbie 8 07-24-2003 08:36 AM
Help Me: Few General Questions ?? alteredinsanity Linux - General 2 09-12-2002 02:40 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:38 PM.

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