1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Which is better- MSAccess or mySQL???

Discussion in 'Databases' started by shanmugappriya, Dec 19, 2011.

  1. Techz SEO

    Techz SEO Banned

    Messages:
    197
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    73
    Digital Goods:
    3
    #21
    If you are not big company or have a big site storing many data Just use MSAcess but for more efficiency, fast and easy to use go wit MySQL
     
    Techz SEO, Mar 7, 2012 IP
  2. skooda

    skooda Greenhorn

    Messages:
    85
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #22
    It could go anyway
     
    skooda, Mar 8, 2012 IP
  3. pediatricdentist

    pediatricdentist Peon

    Messages:
    16
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #23
    My sql is simplest database also its open source platform as campare to ms access
     
    pediatricdentist, Mar 10, 2012 IP
  4. RobertStev

    RobertStev Peon

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #24
    open source is always the best
     
    RobertStev, Mar 10, 2012 IP
  5. NothingLikeThis

    NothingLikeThis Member

    Messages:
    113
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #25
    also i would like to suggest nosql,a different kind of dbms ,better than sql and mysql .
     
    NothingLikeThis, Mar 11, 2012 IP
  6. pagaraon

    pagaraon Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #26
    MySQL is free, Good luck!:eek:
     
    pagaraon, Mar 13, 2012 IP
  7. mical

    mical Greenhorn

    Messages:
    63
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    18
    #27
    MS Access database is more suitable for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Microsoft Access over SQL Serve it is having more compatibility then sql
     
    mical, Mar 20, 2012 IP
  8. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #28
    So is MS SQL Server.
    Compatibility with what? Any language I can use to connect to an Access database I can use to connect to an MS SQL Server database. My only reason for preferring Access in a few very limited cases is that I don't know how to create an MS SQL Server database on the fly (but I could learn if I had to).
     
    Rukbat, Mar 20, 2012 IP
  9. yauza

    yauza Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #29
    Definitely mySQL since it is free and has tons of users. Regarding disk space, it will only depend on your application. I suggest you get a bit more just in case.
     
    yauza, Mar 20, 2012 IP
  10. ivickon

    ivickon Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #30
    The fact that the app is "client level" has absolutely
     
    ivickon, Mar 21, 2012 IP
  11. ivickon

    ivickon Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #31
    Although I've got quite a lot of experience with php and (M/My)SQL, I only used both within an online php script. These last few months I bought an option with my webhost to access the remote database via ODBC via my homePC. I use MS Access (linked tables) on my PC, just because it's very easy to make new reports / forms / querys / ... And, in principle, it should work, shouldn't it? And it does... most of the time, however there very, very often errors. Most of the time I can solve these just by closing and re-openinging Access, but there have to be better solutions for this. can you connect to a MySQL database in another (better) way.
     
    ivickon, Mar 21, 2012 IP
  12. mark2048

    mark2048 Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #32
    MySQL is way better and free.
     
    mark2048, Mar 22, 2012 IP
  13. mrdon

    mrdon Active Member

    Messages:
    32
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    95
    #33
    mysql for sure
     
    mrdon, Mar 22, 2012 IP
  14. calflowers

    calflowers Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #34
    mysql is your only choice especially if you want to deal with web access development.
     
    calflowers, Apr 9, 2012 IP
  15. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #35
    Who told you that lie? You can use any database you can access when you develop a website. There's no problem using MS Access, MS SQL, Oracle, etc. - I've used them all for websites. With most hosting companies, you're only given a choice of MySQL with Linux hosting and MS SQL with Windows hosting, but that has nothing to do with whether a site can use a different database. That would be like saying that bvecause there's a Chevy dealer in your town, but no Ford dealer, that you can only drive Chevys in your town. Availability and ability aren't the same thing.
     
    Rukbat, Apr 10, 2012 IP
  16. spaculus

    spaculus Peon

    Messages:
    187
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    0
    #36
    ofCourse MySql is best.
     
    spaculus, Apr 20, 2012 IP
  17. copxxx

    copxxx Well-Known Member

    Messages:
    374
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    180
    #37
    MySQL is a lot more faster than MSAccess and ofcourse MySQL is free.
     
    copxxx, Apr 20, 2012 IP
  18. geekos

    geekos Well-Known Member

    Messages:
    3,365
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    140
    #38
    Another vote for MYSQL . I'ts free! ;)
     
    geekos, Apr 20, 2012 IP
  19. shamsaalia

    shamsaalia Peon

    Messages:
    28
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #39
    MySQL is best as compared to MS Access. But if it's small sized application, better use MS Access.. and if it's big, then opt for MySql thanks.................................
     
    shamsaalia, Jun 7, 2012 IP
  20. hostmedia

    hostmedia Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #40
    Ms Access is not used that much in web applications due to the security / file based storage and it can be a lot slower to query from your code. Really you would want to migrate that data into MySQL or MsSQL. Deciding on which one to use it really based on what your application will do :)

    Just my two cents!
     
    hostmedia, Jun 8, 2012 IP