Web- Access- Excell

[smilodon]

I'm in the midst of a final major project for my BSc Degree course and have an interesting problem to solve. Any broad advise about how I might approach the problem would be much appreciated. I'm certainly not looking for any serious assistance as that would be plagarism but general help would be welcome.

I need to create a system to achieve the following theoretical result.

I'm project managing a series of installations into a number of customer premises (100+) . Several colleagues need to be able to imput data into the system but cannot get access from outside the network i.e.from home. Therefore I need to set a up a web page which can be accessed by the user via the Internet and data entered into some sort of web form.

The data needs to be passed from there into a database (Access) where it is stored. The end users who want to see the data displayed don't have access to the database, so it will have to populate a spreadsheet across the company Intranet to which they do have access.

So what I need to do is design a system that allows data to pass from a web form  into a database and then output itautomatically to a spreadsheet.

Is this even possible and if so broadly what would the process be? I don't actually have to create any of this, just explain the procedure as aprt of my project. I've worked with the applications concerned ( web edtors, Microsft Acces  & Excel) and think??? it's possible. Any good websites would be useful. As long as I acknowledge the sources I can use any material I can find both on-line or off.

Ta.  :winkiss:

[TeaLeaf]

Sharepoint?  That would give you exactly this result although not quite in the way described.

TL.

[Gandalf]

yes it is possible. ASP can write to access databases easily enough and Access can export to spreadsheets.

However, I'd go the entire web route. Have the whole thing on a database and use a web frontend. Sharepoint will do that, but a custom written design would be best from a degree standpoint

[smilodon]

Thanks for the info. I'll take a look at Sharepoint. I don't actually have to write any code, just explain the basic design and processes i.e explain that it can be done and how it would be done if I did design it. I wasn't sure linking the three parts together was possible but now I know I'm on the right track. Ta