Posting INTERACTIVE spreadsheet and calendar

O

Ozzie845

I need to post a spreadsheet that designated users can access and enter new
data that will be saved when user logs off. I also need to do the same with a
calendar - one that users can share.

Assuming the users are using XP Pro SP2, Office with Web Extensins, and
Office 2003, how is this possible? I've been able to post an interactive
spreadsheet that users can manipulate but the data entered is not saved and
hence, lost once they logoff.

By the way, we do not have Office Server, if that's of any significance.

Any help is most appreciated.
 
J

Jim Buyens

The "classic" approach for these jobs is to write some custom ASP.NET or ASP
code, and store the data in an Access or SQL Server database.

Depending on your requirements, Windows SharePoint Services might also be a
good fit.

Otherwise, perhaps you can find a third-party product or template that does
what you want.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
O

Ozzie845

I should never ask a question the answer to which I am bound not to fully
understand. It's not that you use terms I'm not familiar with. It is just
that I don't know how to implement, say, a custom ASP.NET. I do have Access.
Should an Access db be placed in the website to store the data??

In lieu of all that, can you either recommend a thrid-party template, or how
to access Windows Sharpoint Services?

Thank you for your help and, again, sorry for the duplicate post.

Ozzie
 
S

Stefan B Rusynko

WSS requires a Windows 2003 Server (or host running one)

Under the FP SE you can use Access as a Database and ASP (VBscript) to access it
For very limited functionality you can use the FP Database Results Wizard
(server based site running under IIS)
- more complex solutions require hand coding the ASP code

See FP Help on Database or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfp2k2/html/fp_dbpower.asp
For your calendar see http://office.microsoft.com/en-us/assistance/ha010429311033.aspx
For login thru a DB see http://support.microsoft.com/default.aspx?scid=321439



|I should never ask a question the answer to which I am bound not to fully
| understand. It's not that you use terms I'm not familiar with. It is just
| that I don't know how to implement, say, a custom ASP.NET. I do have Access.
| Should an Access db be placed in the website to store the data??
|
| In lieu of all that, can you either recommend a thrid-party template, or how
| to access Windows Sharpoint Services?
|
| Thank you for your help and, again, sorry for the duplicate post.
|
| Ozzie
|
| "Jim Buyens" wrote:
|
| > The "classic" approach for these jobs is to write some custom ASP.NET or ASP
| > code, and store the data in an Access or SQL Server database.
| >
| > Depending on your requirements, Windows SharePoint Services might also be a
| > good fit.
| >
| > Otherwise, perhaps you can find a third-party product or template that does
| > what you want.
| >
| > Jim Buyens
| > Microsoft MVP
| > http://www.interlacken.com
| > Author of:
| > *----------------------------------------------------
| > |\---------------------------------------------------
| > || Microsoft Windows SharePoint Services Inside Out
| > || Microsoft Office FrontPage 2003 Inside Out
| > ||---------------------------------------------------
| > || Web Database Development Step by Step .NET Edition
| > || Microsoft FrontPage Version 2002 Inside Out
| > || Faster Smarter Beginning Programming
| > || (All from Microsoft Press)
| > |/---------------------------------------------------
| > *----------------------------------------------------
| >
| >
| >
| > "Ozzie845" wrote:
| >
| > > I need to post a spreadsheet that designated users can access and enter new
| > > data that will be saved when user logs off. I also need to do the same with a
| > > calendar - one that users can share.
| > >
| > > Assuming the users are using XP Pro SP2, Office with Web Extensins, and
| > > Office 2003, how is this possible? I've been able to post an interactive
| > > spreadsheet that users can manipulate but the data entered is not saved and
| > > hence, lost once they logoff.
| > >
| > > By the way, we do not have Office Server, if that's of any significance.
| > >
| > > Any help is most appreciated.
 
O

Ozzie845

Stefan,

Thank you. I'll be checking out the links you sent. This process involves a
lot more work and software savvy than I had anticipated. Fortunatelly I have
all the necessary software and applications, just need the time and head to
pull it all together.

Oz
 
Top