Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    U.S.
    Posts
    26

    Unanswered: Help New to SQL server

    Im working for a company that has a relatively small database but will continue growing. We would like to use SQL server to accomodate the mass users who will be accessing the data. I have never used sql server and would like to know where to get started. IE. books, websites(besides this one), prices. what will i need to get this database up and running?? I would like to have sql server as my backend and microsoft access as my frontend. any help would be greatly appriciated.

    thanx

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    http://www.sqlteam.com/store.asp

    I would rethink Access as a front end...but that's just me...

    Have you seen how much sql server costs?

    You might want to look into MSDE...

    How many users?

    How much data are you talking about...

    Is it internal to one office?

    What is the application meant to do?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2004
    Location
    U.S.
    Posts
    26
    Originally posted by Brett Kaiser
    http://www.sqlteam.com/store.asp

    I would rethink Access as a front end...but that's just me...

    Have you seen how much sql server costs?

    You might want to look into MSDE...

    How many users?

    How much data are you talking about...

    Is it internal to one office?

    What is the application meant to do?
    -----------------------------------------

    Why would you rethink Access?? What else would you use as a frontend?

    Cost is not an issue. How mush is it?

    What is MSDE (microsoft developer edition??)

    mmm possibly 200 users accessing from the web and 6 users from the office.

    The data right now is about 40mb. I know this isnt alot. i could create the database in access then when necessary move it to SQL server, but access cant handle the amount of users i need.

    The database will keep track of all billings, customer info, shipping info

Posting Permissions

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