Re: Differences in data description in programming languages

From: LX-i (lxi0007_at_netscape.net)
Date: 12/03/04 

Date: Thu, 02 Dec 2004 18:35:17 -0600

Pete Dashwood wrote:
>
> I was so intriqued, I decided to convert the ACCESS database to MySQL which
> was a very simple process. To my astonishment, I found that MySQL had all
> the facilities of ACCESS (although it took a few days to get round the
> learning curves) and ran much faster! Running it on the same server the
> initial response was under 4 seconds and subsequent under 2. All of my
> existing SQL ran without change (apart from one complex piece of nested SQL,
> which I simply broke into simpler statements).
>
> MySQL is Open Source and a free download.
>
> These products are stable, supported, and in use all over the world by
> hundreds of thousands of people.
>
> So it would be unfair to classify all Open Source as "Mickey Mouse"... I
> have decided to use MySQL for all future development and have found the
> support forums and the products and documentation to be first class.

Welcome aboard! :) I had an application that was originally written
using ASP and Access (heck, it was already on the computer). I
converted the database to MySQL, and was astounded at the improvement.
Now my web stuff is PHP (also free) and MySQL. 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~   /   \  /         ~        Live from Montgomery, AL!       ~
~  /     \/       o  ~                                        ~
~ /      /\   -   |  ~          LXi0007@Netscape.net          ~
~ _____ /  \      |  ~ http://www.knology.net/~mopsmom/daniel ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~         I do not read e-mail at the above address           ~
~    Please see website if you wish to contact me privately   ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w$ ~
~ !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e    ~
~ h---- r+++ z++++                                            ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Relevant Pages

  • Access conversion to SQL
    ... I have an application that currently connects to an Access database, ... customers are asking for a MySql and MsSql server back end database. ... MySql handles True and False values through the bit field without any ... It also gives me the problem of setting controls true/false value by ...
    (microsoft.public.access.conversion)
  • Interesting ODBC problem
    ... I have just converted a guestbook to use an Access database rather than ... MySQL via odbc and have come across an unusual problem. ...
    (comp.lang.php)
  • Re: Pocket Access - Sync to Linked Table?
    ... syncronizes a Pocket Access database with my Access ... I can then maintain my DB within Access and syncronize the PDA ... Recently I've re-created my tables in MySQL, set up ODBC connections to them ... Pocket Access database through ActiveSync anymore because the linked tables ...
    (microsoft.public.pocketpc.activesync)
  • trouble with SQL syntax
    ... I'm having some trouble getting a search in an access database to work ... Model between StartYr and EndYr.On the form I have a combo named ... Dim mySQL As String ... the EndYr entries are "later" so as a result the StartYr and EndYr ...
    (microsoft.public.vb.general.discussion)
  • Problems accessing a MySQL database using an Access linked table
    ... between MySQL and another database, I've created an Access database ... application - classic ASP works fine but .NET gives me... ... If you are not the intended recipient please notify the sender that you have ...
    (microsoft.public.dotnet.framework.aspnet)