Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2009
    Posts
    3

    Which database software to use?

    Hi everybody,

    I am a new member in this forum and I would like to ask you a question.

    Until now, I've worked only with Microsoft Access to create databases. Now, I need to create a large database that will contain students records of an university and will be managed by more than 2 persons.

    Can you suggest me whitch software/ tool to use in order to make it. Even if its something that I don't have any clue, I'm ready to start learning and doing it.

    Thanks,
    A

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Can you use Access to build it?

    Seriously, Access is a good tool and has pretty reasonable scaling capabilities. It cannot manage more than 20 or so [B]concurrent[/B[ connections, which is more than most people need.

    Access also makes a very quick and easy to develop front end to most databases.

    What are your reasons for thinking that Access is not a viable platform? Let us know your thoughts and we'll see what we can come up with
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2009
    Posts
    3
    First of all, thank you for quick reply

    Second,... I would like to start and learn from a beginning and Access is not my favorite. I heard some of my friends saying that Visual Studio is cool. What I need to do is to create a database with the name and all details about a thousands of students, about their grades in each academic year and so on.

    Since, I don't know what other softwares/ tool offer, I asked anyone of you who have experience to help me in this. Which is the best choice for me?
    Last edited by aukrreze; 09-28-09 at 11:30.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    if you are just starting out on the db developmentn trail then Access may well be a smarter choice than other tools. you could alos try Filemaker and the db that comes with Open office.

    Visual studio is a great tool for developing large scale applications. if you are familiar with which ever .NET language then fien use it.

    the learning curve to get something working will be shallower in Access or one of the other 'desktop' development tools than any general purpose language (except possibly Delphi).

    whetehr something is 'cool' or not is largely irrelevant, what matters is what tools you have available, what experience you have, and if you are just starting out what resources can you draw on to get to where you want to be. one thing I woudl say is that this forum isn't the best resource fro someone starting from scratch, although we try to help we don't really do teaching, helping yes, but not teaching from basics.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Access may be perfectly capable of storing the number of records, and handling the number of users you need (with appropriate care in your access - using disconnected recordsets whenever possible, for instance)

    But, if this is an actual real-world application, I wouldn't think that Access would support the real-world security requirements to ensure that users cannot access (or change) private data that they shouldn't, and a more secure back end would be appropriate. It could be fine, from a prototyping viewpoint, though, to test many of your concepts.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  6. #6
    Join Date
    Sep 2009
    Posts
    3
    So, which software do you prefer me?

  7. #7
    Join Date
    May 2009
    Location
    India
    Posts
    66
    Try SQL SERVER. if you want to move on from Access. But remember that SQL server needs more RAM and resources.

    SQL server has an express version whiuch is free for less than 5 users (I think).

    End

Posting Permissions

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