Access to Web

[Big Nate]

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

 

[Danny J. Lesandrini]

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]

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