Post reply

Please Help!!!!!!!!!!!!

  • January 13, 2004 at 5:00 am

    #358797

    Hi everyone,

    Im not sure if im in the right forum here but i was hoping someone could help me, my problem is that ive been asked to design a webpage where users can log in and update there products stock quantities in a database, other users must also be able to search this database and view the updated info. These updates will be happening eveyweek on all products (thousands of), can some one please help and let me know if i should use SQL Server with ASP or shall i use MS ACCESS with ASP? Will people be able to log in from across the uk to do the updates each having there own passpord,

    I will me most greatfull for any help given,

    Best regards ...... Sean     

  • January 13, 2004 at 5:06 am

    #489708

    If you have the choice between Access and SQL Server, use SQL Server.

    As your app will be exposed to the web, it shouldn't matter from where they log in.

    One thing to keep in mind when using SQL Server is security. I found this http://www.sqlsecurity.com a very useful starting point.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 13, 2004 at 5:08 am

    #489709

    Thank you very much, ill have a look at that right away

    Regards ..... Sean

  • January 13, 2004 at 10:31 am

    #489795

    Agree that if the load is expected to be high, SQL provides much better concurrency over Access. Access is best and cheaper for small numbers of users.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply