Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access's Ability

Discussion in 'Information Technology' started by DS, Jul 28, 2006.

  1. DS

    DS
    Expand Collapse
    Guest

    I have to build a database for a college. I'll need names, address,
    grades by semester, teachers and high school transcripts in the records.
    Also I'll need attendance. The college has roughly 2,500 a year going
    through it. Can Access handle this and for how long?
    Thanks
    DS
     
  2. Loading...

    Similar Threads Forum Date
    Vegetarianism And The Idea Of Untouchability Hard Talk Mar 24, 2015
    Sikhism and disability Business, Lifestyle & Leisure Dec 19, 2012
    Politics “Untouchability Is An Instrument In The Hands Of The Upper Castes” Breaking News Oct 28, 2012
    Opinion Pakistan Court Widens Role, Stirring Fears for Stability Breaking News Jan 23, 2012
    India India's Sex Ratio Imbalance a Threat to Stability Breaking News Apr 6, 2011

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "DS" wrote

    >I have to build a database for a college.
    > I'll need names, address, grades by
    > semester, teachers and high school
    > transcripts in the records.



    > Also I'll need attendance.


    > The college has roughly 2,500 a year going
    > through it. Can Access handle this and for how long?


    A single Access / Jet database can be as large as 2 Gigabytes. Access can
    also be used as a Client application to any ODBC-compliant server database
    (and that is most of them, commercial and open-source). For vital data, you
    might want to consider that reliability and recoverability of the data is of
    prime importance, more important than "can it handle the volume".

    Many server databases have built-in logging, backup, and restore features
    that would make them a data store that would give you more "comfort". You'd
    can implement similar functions in Access/Jet, but they are not builtin, and
    to implement them would require considerable work.

    Larry Linson
    Microsoft Access MVP
     
  4. DS

    DS
    Expand Collapse
    Guest

    Larry Linson wrote:
    > "DS" wrote
    >
    > >I have to build a database for a college.
    > > I'll need names, address, grades by
    > > semester, teachers and high school
    > > transcripts in the records.

    >
    >
    > > Also I'll need attendance.

    >
    > > The college has roughly 2,500 a year going
    > > through it. Can Access handle this and for how long?

    >
    > A single Access / Jet database can be as large as 2 Gigabytes. Access can
    > also be used as a Client application to any ODBC-compliant server database
    > (and that is most of them, commercial and open-source). For vital data, you
    > might want to consider that reliability and recoverability of the data is of
    > prime importance, more important than "can it handle the volume".
    >
    > Many server databases have built-in logging, backup, and restore features
    > that would make them a data store that would give you more "comfort". You'd
    > can implement similar functions in Access/Jet, but they are not builtin, and
    > to implement them would require considerable work.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    >
    >

    Thank You Larry, Will SQL Server do the trick. Also how would I do
    Loggong, BackUP and Restore with Access, at the very least can you
    suggest where I would start or read about it.
    Thank You
    DS
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "DS" <bootybox@optonline.net> wrote

    > Thank You Larry, Will SQL Server do the trick.


    Microsoft SQL Server, or other ODBC-Compatible Servers, can be used. I'm not
    familiar with _all_ of them, but many/most do have logging and recovery.
    Some are open-source (free) and others can be very expensive. Price is not
    a good way to determine functionality nor ease-of-use. I worked on one
    project with only about 25 users, that used MS SQL Server just because of
    the reliability and recoverability needs -- a split Access/Jet multiuser
    database would have provided them with adequate response time.

    > Also how would I do Loggong, BackUP and
    > Restore with Access, at the very least can you
    > suggest where I would start or read about it.


    1. You'll have to limit updates to Forms, or to code that you include,
    because if you allow users to update Tables directly, or to write their own
    Queries, you can't trap the updates to log them.

    2. On every Form where update is possible, you'll have to log the change by
    writing it to an external file, or to a log table in the DB.

    3. You'll have to create a manual or automated process to ensure that the
    database is backed up (copied on a regular basis) and that the log file is
    copied along with it and properly identified.

    4. You'll have to create a process, combination of manual and automated, to
    restore a particular backup and to apply all updates on log files since that
    date to the restored backup.

    The above description is, of course, "flying at 30,000 feet"; actually
    designing, implementing, and especially adequately testing such a facility
    is going to take a lot of work.

    I believe one or more of the Access MVPs has some backup/logging/restore
    discussions and/or examples. I suggest you Google to see if you can find a
    reference.

    But, frankly, I don't think I'd put in the time and effort necessary to
    create my own backup/log/restore facility in Access unless I had an
    inordinate amount of free time on my hands and unless watching paint dry was
    the most exciting thing I could do with that free time. <GRIN>

    Larry Linson
    Microsoft Access MVP
     

Share This Page