Re: PHP and Access

rcnews@xxxxxxxxx wrote:
It sounds like Microsoft Access is not a favorite among programmers
here.

And most other environments where people have been exposed to the
alternatives.

That being said, I'm actually wondering if PHP is the best language to
use for connecting our Access database to the website based on your
comments? What I know is that we're currently using PHP (written by
another technician) to have our website forms filter data into email
accounts, so that the data can be manually entered later on in Access.
You say it's possible, Kasper, to combine Access and PHP, but not that
common.

I have done this (a few years back) and I didn't run into any particular
difficulties in terms of being able to make things happen.

However, at that time - and maybe things have changed - it seemed like a
lot of the relationalness of my queries was being handled by the ODBC
drivers or something, because queries that hit several large tables -
even if they didn't use very much of their data - resulted in huge
amounts of data traveling over the network.

As a consequence it ran at about 5% of the speed of a MySQL solution.

If you are just selecting rows by ID and that's it, then this doesn't
matter. But if your database structure is complex, and the behavior I
observed in 2001 is still the case now, then performance could be an
issue.

miguel
--
Photos from 40 countries on 5 continents: http://travel.u.nu
Latest photos: Malaysia; Thailand; Singapore; Spain; Morocco
Airports of the world: http://airport.u.nu
.

Relevant Pages

  • Re: Changing the properties of an Append Query in VBA
    ... On my website, is a small Access database ... sample called "CreateQueries2.mdb" which illustrates how to do this. ... the queries in the samples are Select queries, but the process is the same. ...
    (microsoft.public.access.modulesdaovba)
  • Re: [PHP] Help with where clause
    ... You should direct such queries to the MySQL mailing list as this is a PHP ... or try their website: ... I need to know how I can do a where clause in a select statement for mysql ...
    (php.general)
  • Re: Tracking Log In and Log Out times of Users
    ... On my website, are two small Access database ... These sample track the actual changes to table records, ... was also wondering if the log could track what forms, queries or table ...
    (microsoft.public.access.modulesdaovba)
  • Access Database to website
    ... website for users to query/search information. ... I know i can use php with MySQL, but I am not very familiar with those. ... Does access database has that functionality as well? ...
    (comp.databases.ms-access)
  • Re: Web Animation and Sound Advice Sought
    ... upon someone landing on my website, ... My blog program is a php program that makes use of a mysql database. ... linux (and the linux server supports all sorts of php). ... $500+ Premiere software -- at least on my first brief experimenting ...
    (misc.writing)