SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2009
    Posts
    78
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Technical Questions Related To Access

    I am using database Microsoft Access with my website, i have few technical question related to this.

    Can Access handle 60,000 Records Per Month.

    Can Access give permissions to almost 20 people to view different records at a time.

    Can Access provide report services with web pages.

    I have these few question's related to Microsoft Access.

    Waiting for Experts answers.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    the answers are yes, yes, and yes, respectively
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2007
    Location
    Almere, The Netherlands
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,254
    Mentioned
    113 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by r937 View Post
    the answers are yes, yes, and yes, respectively
    Agreed, provided the coding/sql statements you use are handled correctly. Far too often, Access is blamed for not supporting decent workloads, when it is often the fault of the code accessing the database for doing things like not opening connections late/closing them early or keeping rows locked through suboptimal/poorly written queries.

    Access is probably one of the least forgiving in terms of adjusting for poorly written code/queries. It does GREAT with what you give it, but if what you give it garbage, then your results/performance are going to be the same.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style

  5. #5
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,625
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Technical answers are yes. Real world answers are "you probably shouldn't do that."

    I'd also argue for something of that scale, you are going to want some features which access can't handle--like triggers, transactions and online backups.


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
  •