My experience FWIW:
I found that if you want a multi-user database then Access is very
inflexible, and I got in a real mess trying to split and re-merge
different datasets. Access (or similar) works well as a visual tool for
experimenting with data structures, and for quickly trying out reports,
queries and filters.
Design in flexibility - don't tie yourself to the Windows platform in
these days of high quality open-source software. Especially not if
you're running on a low budget. As has been said, a web-based design is
I moved from Access to go live on the web with MySQL using a fairly
straightforward SQL text dump script downloadable here
Mark Bell wrote:
> MySQL is very good and scaleable - I wrote most of the IFA's site based on
> MySQL and PHP.
> However it has two major downsides - no GUI which scares off novice users
> and it does not yet have some useful functions - they are coming but it
> will take time.
> On Mon, 28 Jul 2003 14:26:33 +0100, Christopher Joseph
> <[log in to unmask]> wrote:
>>From a nice GUI (Graphical User Interface) perspective I guess Access
>>does the job but so would filemaker or a host of similar apps. Wouldn't
>>a free, enterprise class database like http://www.mysql.com be of more
>>use? e.g. It supports functionality like soundex and other pattern
>>matching as well as full text keys which would, for example, support
>>PB's requirements for sophisticated search routines.
Try our NEW live Megalith Map
Prehistoric sites in the UK, Ireland and beyond
Thousands of Images, Links, Downloads, Maps, Web Search, Members Features
The exclusive online shop for Ancient Stones themed products:
CD-ROMs, Books at up to 75% off, Art, Jewellery, Crafts, CDs & Videos