Professional Web Applications Themes

Access vs. DBF....which is better? - Macromedia Dreamweaver

I'm new at using a database on a web site. I'm setting up a very simple database for a client using Dreamweaver. It has 13,000 records and may grow to 60,000 over time. It only has four fields per record and people will only be searching on one field. So...I set up a test using Access and it works great. The thing is, the database is 6 megs now and will only get bigger. The client will be updating it steadily using Filemaker Pro and I'll have to convert it and upload it (and test it, of course). My question ...

  1. #1

    Default Access vs. DBF....which is better?

    I'm new at using a database on a web site. I'm setting up a very simple
    database for a client using Dreamweaver. It has 13,000 records and may grow
    to 60,000 over time. It only has four fields per record and people will only
    be searching on one field.

    So...I set up a test using Access and it works great. The thing is, the
    database is 6 megs now and will only get bigger. The client will be updating
    it steadily using Filemaker Pro and I'll have to convert it and upload it
    (and test it, of course).

    My question is: In playing around I see a DBF file is tons smaller. It looks
    to be about 25% the size. What are the pros and cons to using Access vs.
    DBF? If in this simple case DBF will work as well and be a smaller size,
    why not go that way? Will it be faster and less subject to corruption?

    Any thoughts?

    THANKS!



    Mad Dog Guest

  2. #2

    Default Re: Access vs. DBF....which is better?

    On Mon, 28 Jul 2003 20:59:19 GMT, "Mad Dog" <mdmdp.com> wrote:
    >.dbf is the file format started by dBase and used by them and a number of
    >other database programs (FoxPro, etc). I was using dBase back in the
    >mid-80's. It's actually a text file format so it's very simple and clean.
    >Since this web application only needs four fields per record and will be
    >doing a simple search on one field, I don't need anything fancy. The .dbf
    >file is smaller than .mdb, works fine, and from what I'm gathering, less
    >subject to getting corrupted. I'm trying to see if anyone has experience
    >with both before I make my decision.
    >
    >Thanks!
    >
    I suppose that one answer to your original question is that I'm
    getting less keen on using Access, as it doesn't hold enough
    connections, even for my small business clients. That's why I am more
    and more using PHP with MySQL - both open source and free. ASP and SQL
    Server form a robust solution, but very expensive. If dbf is really a
    text file format, I suggest it will not prove robust enough. I deal
    mainly with small business of 10 or less employees. Even there, Access
    is often not enough for their sirtes. i suggest you look at PHP/MySQL
    as a solution. MySQL can import text files - especially if you use a
    good GUI, such as DBManager from [url]www.dbtools.com.br[/url]. You can also use
    MySQL with ASP, if your server has the (free) MyODBC driver installed.


    Paul Taylor
    Paul Taylor Guest

  3. #3

    Default Re: Access vs. DBF....which is better?

    Mad Dog,
    Not sure if you are linked to ICCF but either way, drop Access and use
    MySQL/PHP for the website query function. Access is great but not best
    suited in these circs.

    Mickey


    mickeyblake Guest

Similar Threads

  1. Web Service + Anon Access, but getting 401 Access Denied Error
    By Alex Washtell via .NET 247 in forum ASP.NET Web Services
    Replies: 1
    Last Post: April 5th, 04:57 PM
  2. Network File access using anonymous access
    By Tim Menninger in forum ASP.NET Security
    Replies: 2
    Last Post: July 22nd, 03:37 PM
  3. Access 2002 PDFWriter VBA Code w/WinXP does not work like Access 2000
    By Tony_VBACoder in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: April 30th, 07:44 PM
  4. Replies: 0
    Last Post: December 16th, 06:19 PM
  5. Access denied when creating Access application object
    By Bill Murphy in forum ASP Database
    Replies: 7
    Last Post: July 31st, 05:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139