Results 1 to 12 of 12

Thread: Pros & Cons of Access (over other DBMS)

  1. #1
    Senior Member Tobeman's Avatar
    Join Date
    Apr 2005
    Location
    IN YOUR FRIDGE, AWPIN' YOUR NOOBS
    Posts
    1,823
    Thanks
    34
    Thanked
    11 times in 11 posts

    Pros & Cons of Access (over other DBMS)

    Having never used anything else on the market, I don't really know what features are available in other packages, and what they lack in comparison to others. Obviously theres bonuses such as similar interface throughout the Office suite, but I'm finding it hard to write about anything else.

    Any comments and thoughts are welcome

  2. #2
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,662
    Thanks
    53
    Thanked
    383 times in 313 posts
    Not very good with record locking
    Poor network performance
    No stored procedures
    Poor Security
    Not good when you have multiple databases / linked servers


    Pros:

    quite easy to generate reports
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  3. #3
    Senior Member
    Join Date
    Apr 2006
    Posts
    859
    Thanks
    6
    Thanked
    8 times in 8 posts
    Pros:

    Pretty easy to use for setting up a database.

    Reasonably easy to make it more secure (requires some VB work though), as the above poster states, the standard security isn't great.

    Good for a small database for say 20 users.

    Cons:

    Not good for high usage database (i.e. many records being added by different users at the same time.

    Very prone to corruption with large databases, particularly when using the "Memo" type field.

    Overall, its ok for a relative novice to set up a databse. I understand that SQL server is a better all round option, but I've never used it myself.

  4. #4
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts
    SQL express is much better, and its free, just limited to 4gb, and only 1 CPU operation.

    You can make access, access it very easily.
    throw new ArgumentException (String, String, Exception)

  5. #5
    Does he need a reason? Funkstar's Avatar
    Join Date
    Aug 2005
    Location
    Aberdeen
    Posts
    19,874
    Thanks
    630
    Thanked
    965 times in 816 posts
    • Funkstar's system
      • Motherboard:
      • Gigabyte EG45M-DS2H
      • CPU:
      • Intel Core2Quad Q9550 (2.83GHz)
      • Memory:
      • 8GB OCZ PC2-6400C5 800MHz Quad Channel
      • Storage:
      • 650GB Western Digital Caviar Blue
      • Graphics card(s):
      • 512MB ATI Radeon HD4550
      • PSU:
      • Antec 350W 80+ Efficient PSU
      • Case:
      • Antec NSK1480 Slim Mini Desktop Case
      • Operating System:
      • Vista Ultimate 64bit
      • Monitor(s):
      • Dell 2407 + 2408 monitors
      • Internet:
      • Zen 8mb
    As a frontend, access is great. with a bit of VBA in the background, they can be very powerful and flexible.

    SQL Express is definitely recomended. I was going to move the Access DB we use at work to SQL Server (came with SBE Sever 2003) but we are moving to Microsoft CRM and Greatplanes instead.

  6. #6
    Vive le pants! directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • MSI X99A Gaming 7
      • CPU:
      • Intel Core i7 5280k
      • Memory:
      • 32GiB ADATA DDR4
      • Storage:
      • Corsair Neutron XT 960GB
      • Graphics card(s):
      • MSI GTX 980 Gaming 4G Twin Frozr 5
      • PSU:
      • Corsair AX860i
      • Case:
      • NZXT H440
      • Operating System:
      • Ubuntu 17.10, Windows 10
      • Monitor(s):
      • Dell U2713HM
      • Internet:
      • FIOS
    Pros:
    * Access knowledge can help you get jobs at doomed companies

    Cons:
    * Not a real multi-user relational database
    * Costs money
    * Not helpful for real jobs

    Use a free real database (Postgres, SQL Server Express, cut-down Oracle, whatever), learn real SQL.

  7. #7
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts
    another con:
    bugger all upgrade path.
    throw new ArgumentException (String, String, Exception)

  8. #8
    Senior Member
    Join Date
    Dec 2005
    Location
    south of heaven
    Posts
    519
    Thanks
    0
    Thanked
    2 times in 2 posts
    mysql is fun

    I've always found access very shoddy for anything but report making.
    SmoothNuts!~yaman_an@*.dsl.pipex.com > change my rating to exceptional tbh

  9. #9
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts
    mysql is hardly better than access
    throw new ArgumentException (String, String, Exception)

  10. #10
    Treasure Hunter extraordinaire herulach's Avatar
    Join Date
    Apr 2005
    Location
    Bolton
    Posts
    5,618
    Thanks
    18
    Thanked
    172 times in 159 posts
    • herulach's system
      • Motherboard:
      • MSI Z97 MPower
      • CPU:
      • i7 4790K
      • Memory:
      • 8GB Vengeance LP
      • Storage:
      • 1TB WD Blue + 250GB 840 EVo
      • Graphics card(s):
      • 2* Palit GTX 970 Jetstream
      • PSU:
      • EVGA Supernova G2 850W
      • Case:
      • CM HAF Stacker 935, 2*360 Rad WC Loop w/EK blocks.
      • Operating System:
      • Windows 8.1
      • Monitor(s):
      • Crossover 290HD & LG L1980Q
      • Internet:
      • 120mb Virgin Media
    I dont want to turn this into a holy war, but it is for some stuff (web based stuff interfaced with php/perl for example)

    Since i assume this is for the stupid justify what program youre going to use part of an a level project:

    Easy to create forms etc
    Easy to make reports
    Availability (put in the client already has it, who cares, theyre made up anyway)

    Cons
    Most of the simplifications are just awkward (autonumbers in relationships for example)
    Security is laughable
    Hard to scale to a multi user/site environment
    Use of VBA means its incredibly difficult to do anything online (auto email orders or something like that)

  11. #11
    Vive le pants! directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • MSI X99A Gaming 7
      • CPU:
      • Intel Core i7 5280k
      • Memory:
      • 32GiB ADATA DDR4
      • Storage:
      • Corsair Neutron XT 960GB
      • Graphics card(s):
      • MSI GTX 980 Gaming 4G Twin Frozr 5
      • PSU:
      • Corsair AX860i
      • Case:
      • NZXT H440
      • Operating System:
      • Ubuntu 17.10, Windows 10
      • Monitor(s):
      • Dell U2713HM
      • Internet:
      • FIOS
    Quote Originally Posted by TheAnimus
    mysql is hardly better than access
    it's a lot better than it was, and at least it's a real multi-user database - though you're right that it misses out on some basics

  12. #12
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,147
    Thanks
    798
    Thanked
    2,151 times in 1,407 posts
    Quote Originally Posted by directhex
    it's a lot better than it was, and at least it's a real multi-user database - though you're right that it misses out on some basics
    I should clarify that a bit more. Think of it as comparing a hampster to a dead gerbil. when there are capybara to be had.

    MySQL is fine for simple, very simple, abortion of SQL stuff.
    Access is *slightly* better when it comes to certain command types, but mysql is getting better.

    Access can be used as a rather good front end to databases. MySQL just really shouldn't be confused with a proper SQL server.
    throw new ArgumentException (String, String, Exception)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New car for gordy time , help please
    By Gordy in forum Automotive
    Replies: 74
    Last Post: 17-12-2004, 09:05 PM
  2. Power Supplies - Supplied vs Expensive Pros / Cons
    By stytagm in forum PC Hardware and Components
    Replies: 17
    Last Post: 12-12-2004, 10:52 AM
  3. Belkin F5D6130 802.11b Wireless Access Point
    By Howard in forum Reader Reviews
    Replies: 4
    Last Post: 10-12-2004, 11:20 PM
  4. Hercules XPS 5.100 Pros / Cons
    By mi11er in forum PC Hardware and Components
    Replies: 0
    Last Post: 16-07-2004, 12:37 PM
  5. Access Reports - help....
    By Lead_Head in forum Software
    Replies: 5
    Last Post: 22-10-2003, 12:19 PM

Posting Permissions

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