Welcome to SPN

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

Sign Up Now!

Access to Web

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

Tags:
  1. Big Nate

    Big Nate
    Expand Collapse
    Guest

    I have 1 .csv file that we get from the accounting dept showing sales by
    salesperson. We import that to an access database that has 1 Table only.

    How would I proceed to have each of the 10 salespeople be able to go to our
    website, login and only display the data that corresponds to their sales?

    Sorry for the newbie question, but we all have to start somewhere :)

    TIA
     
  2. Loading...


  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    It's not a trivial task, but can be done with ASP and VB Script.

    Here's a couple articles on how to build a web page datasheet
    http://amazecreations.com/datafast/GetFile.aspx?file=dsexample1.htm&Article=true
    http://amazecreations.com/datafast/GetFile.aspx?file=dsexample2.htm&Article=true

    Here's an article at DBJ that includes a download which will turn
    any Access table into a web page. It's not complete, but it's a good start.
    http://www.databasejournal.com/features/msaccess/article.php/3487741

    It's not a simple answer to your question, but you can do a lot with Access
    and ASP web pages. Here's a site you can play with that's based on Access.
    http://amazecreations.com/slm/login.asp

    Cheers
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Big Nate" <jncracing@yahoo.com> wrote ...
    >I have 1 .csv file that we get from the accounting dept showing sales by salesperson. We import that to an access
    >database that has 1 Table only.
    >
    > How would I proceed to have each of the 10 salespeople be able to go to our website, login and only display the data
    > that corresponds to their sales?
    >
    > Sorry for the newbie question, but we all have to start somewhere :)
    >
    > TIA
    >
     
  4. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    I've rethought this one, and decided to create an ASP page that can display
    records from any table in your database. I'm going to write this up for my
    June article at DBJ, but I'd be interested in getting some feedback.

    I'm not saying this is pretty or terribly useful, but it's fast and could serve
    as a good tutorial and/or starting point for a simple Show-Me-The-Data app
    that might fit someone's needs, who wants to access their data over the web.

    Here's the link to the page on my server. There are simple setup instructions
    there, but if you've never done ASP before, you'll need additional help.

    http://amazecreations.com/showmethetable/ShowMeTheTable.asp

    What it does, after you point it to your MDB file and grant Read permission
    on the MSysObjects table, is to give you a datasheet of the top 100 rows.
    You can replace the Top 100 with a WHERE and ORDER BY clause, if you
    know how to write SQL. (I threw this together quickly and you should be
    warned that in its present state it is susceptible to sql injection.)

    Give it a look and send me feedback on suggestions that might make the
    article better. Thanks
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "Big Nate" <jncracing@yahoo.com> wrote ...
    >I have 1 .csv file that we get from the accounting dept showing sales by salesperson. We import that to an access
    >database that has 1 Table only.
    >
    > How would I proceed to have each of the 10 salespeople be able to go to our website, login and only display the data
    > that corresponds to their sales?
    >
    > Sorry for the newbie question, but we all have to start somewhere :)
    >
    > TIA
    >
     

Share This Page