SitePoint Sponsor

User Tag List

Results 1 to 11 of 11
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is MS Access ok to use?

    I dont like working with mysql because i learned access in school and i think it is easy. If I use access and asp, would i have problems. I dont know how much traffic i will have, but please let me know if it would be bad to use access. If i shouldnt use access, what is a good database to use with ASP

    Thanks

  2. #2
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think it depends on you. http://www.sitepointforums.com/showt...threadid=27206

    If you already know asp, then use access or sql server

  3. #3
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Access is fine as long as you don't intend using it on a high traffic site
    .NET Code Monkey

  4. #4
    SitePoint Enthusiast
    Join Date
    Oct 2001
    Location
    Titusville, FL
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    yeah

    Access will do everything you want and is very easy to deal with. But as stated by big_al don't use it on a high traffic site. What happens is that Access has trouble locking records while dealing with many simultaneous connections. It's pretty good and can take a lot of abuse, but it will stop scaling so well once you get (and i'm not sure of the exact number, but depending on the type of data driven site you're using) to about 100 or so concurrent users. At that point, access won't hold up as well as SQL server, which is VERY good at handling MANY more users than that.
    ::::::: Lutter Interactive, LLC ::.
    -: Web Design -:- Programming -:- Consulting :-
    http://www.lutterinteractive.com

  5. #5
    SitePoint Enthusiast spike's Avatar
    Join Date
    Dec 2000
    Location
    Baltimore, MD
    Posts
    33
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    If you're using Access for a small site, (personal, brochure, etc) then Access works fine.

    If money is on the line, then definitely go with SQL Server; it's faster, offers much more management tools and as stated above handles much more traffic.
    www.blenderking.com
    over 50,000 blenders can't be wrong!

  6. #6
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Does Access is much the same as SQL Server but less powerful? I'm interested in how much they are in common with each other. Thanks,
    John

  7. #7
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by johnn
    Does Access is much the same as SQL Server but less powerful? I'm interested in how much they are in common with each other. Thanks,
    John
    Hi,

    Access if the GUI that sits on top of the JET SQL engine, it is a downsized version of SQL.

    Access also is just a means of storing data whereas SQL Server actualy serves the data. SQL Server has so many features built in it that can make your sites exteremly powerful, it has better security. I would have to suggest to look at Microsofts SQL site for the full feature list ( can't think of the URL at the moment)
    .NET Code Monkey

  8. #8
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    .NET Code Monkey

  9. #9
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'll just add me 2 cents.

    Access was never intended to be used online, it just kinda happened.


  10. #10
    SitePoint Guru Husain's Avatar
    Join Date
    Sep 2001
    Posts
    620
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Access works file on low traffic website. I use Access for my website and I have not had any problems with it for quite some time now.

    One thing to keep in mind though is that Access does not support more than 20 simultaneous connections. (The number is an average - Microsoft gives a much higher number, but tests have concluded that about 20 connections is it)

  11. #11
    SitePoint Addict kevin_tremblay's Avatar
    Join Date
    Jul 2001
    Location
    Boston Area (North shore)
    Posts
    233
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Like most people here have said it all depends on your traffic volume. If it is going to be a high traffic volume than some thing like SQL server would be a better bet for you .
    Kevin Tremblay-- Sys Admin
    work: kevin_tremblay@hsgmed.com
    "The object of the journey is not to arrive."


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
  •