473,395 Members | 1,452 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

MS Access Equivalent

I am new to Linux and am migrating a SQL Server DB with an Access front end
to MySQL and ?

What options are available under Linux for development of a client front end
without copious amounts of programming.

Without knowledge of PHP can a front end be developed using plugin
components with minimal fuss ?
--
Thanks

Murph
Jul 23 '05 #1
2 1666
"Murphy" <m@urphy.com> wrote in message
news:vA*****************@news-server.bigpond.net.au...
I am new to Linux and am migrating a SQL Server DB with an Access front end to MySQL and ?
If you like the way Access front ends for SQL Server, then the best front
end you can find for MySQL would be - Access.
What options are available under Linux for development of a client front end without copious amounts of programming.
Assuming you are talking about Microsft front ends - MySQL Control Center
from www.mysql.com or MySQL-Front or {a bunch of others I don't have time to
try}. All useful but none have the full range of capabilities that Access
offers. Access really does cover a lot of ground, much of it only
peripherally concerned with database utility. Most manage to succesfully
gather a collection of tools to do the job BUT you will have to ask what you
want to accomplish and be rather specific.
Without knowledge of PHP can a front end be developed using plugin
components .... As wildly popular as MySQL is amongs PHP enthusiasts, there is no connection
between these 2 systems. You can "front" most any programmable system to
MySQL. I've already mentioned Access/VBA as a perfectly competent system to
both manage MySQL and serve as a reporting tool. My personal favorite for
creating reporting software under Microsoft would be Excel. Wonderful
Windows/Linux cross platform stuff can be done in Python. Or pick your own
favorite programming tools.
... with minimal fuss ? Sighhh! This brings us right back to Access :-(
It's like a drug addiction!

Drugs (Access!) make you feel good at first but the end results aren't all
that pretty!
Thomas Bartkus

--
Thanks

Murph

Jul 23 '05 #2
On Wed, 6 Apr 2005 08:39:32 -0500, in mailing.database.mysql "Thomas
Bartkus" <to*@dtsam.com> wrote:
| "Murphy" <m@urphy.com> wrote in message
| news:vA*****************@news-server.bigpond.net.au...
| > I am new to Linux and am migrating a SQL Server DB with an Access front
| end
| > to MySQL and ?
|
| If you like the way Access front ends for SQL Server, then the best front
| end you can find for MySQL would be - Access.
|
| > What options are available under Linux for development of a client front
| end
| > without copious amounts of programming.
|
| Assuming you are talking about Microsft front ends - MySQL Control Center
| from www.mysql.com or MySQL-Front or {a bunch of others I don't have time to
| try}. All useful but none have the full range of capabilities that Access
| offers. Access really does cover a lot of ground, much of it only
| peripherally concerned with database utility. Most manage to succesfully
| gather a collection of tools to do the job BUT you will have to ask what you
| want to accomplish and be rather specific.
|
| > Without knowledge of PHP can a front end be developed using plugin
| > components ....
| As wildly popular as MySQL is amongs PHP enthusiasts, there is no connection
| between these 2 systems. You can "front" most any programmable system to
| MySQL. I've already mentioned Access/VBA as a perfectly competent system to
| both manage MySQL and serve as a reporting tool. My personal favorite for
| creating reporting software under Microsoft would be Excel. Wonderful
| Windows/Linux cross platform stuff can be done in Python. Or pick your own
| favorite programming tools.
|
| > ... with minimal fuss ?
| Sighhh! This brings us right back to Access :-(
| It's like a drug addiction!
|
| Drugs (Access!) make you feel good at first but the end results aren't all
| that pretty!


Oh how painfully true that statement is :-)
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Jim Andersen | last post by:
Hi, I made a DTS-package and it works when I execute it manually, but when it is run by the SQL Server Agent, it fails. I have use the guide to create a maintenance plan. That doesn't work so...
5
by: jqpdev | last post by:
Hello all... I'm coming from a Borland Delphi background. Delphi has a specific component called a Data Module. In the designer the Data Module behaves like a windows form. A developer can...
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
0
by: AJ | last post by:
Hi all, I have the following query which isn't quite finished! 1) How do i specify the '@Country' parameter is optional in an ACCESS stored query? (like MSSQL @Country INT = NULL) 2) What is...
9
by: Alan Mailer | last post by:
Ok, my Access 2002 language writing skills are VERY rusty,. I would know how to do what I need using SQL Server's "Coalesce' function, but I don't have that available to me in the Access 2002...
19
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - How do I access a property of an object using a string?...
5
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends,...
14
by: ApexData | last post by:
I am considering building some distributable commercial applications. For about a year now, I have been using Access2000. This was my first venture into object oriented database development. ...
1
by: shovan mohanty | last post by:
Hi , Can anybody convert below access query into equivalent stored procedure. Also please advice in the below query,user defined function of VBA i.e anneeSelection41510() has been used in the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.