Password database - can I substitute Excel for Access?

[biztips]

Okay, I have a customer who wants me to add password-protected areas to
his site, created with FP2003. He owns a construction company, and
wants customers to be able to log with a user name and password to a
special area that will have schedules, photos, files related to that
particular job.

Have never done this before, so was following Microsoft's advice at
http://support.microsoft.com/default.aspx?scid=kb;en-us;825498
on "How to create a password-protected Web page by using FrontPage
2003, Active Server Pages, and an Access database"

However... the company owner does not HAVE Access and wants to use
Excel for the database instead. I'm not sure it will work in this case
- will it?

HELP! Pretty please...

Diana

 

[Andrew Murray]

Do *you* have MS Access? The client doesn't really need it if you get a
"user management" type ASP script then the script can
create/write/delete/amend records and eliminates the need for Access at all,
and then the client can add their users/passwords etc through a webpage
interface.

Frontpage even creates the DB for you using the Results Wizard features.
When you choose to do a new database connection through the wizard, you can
choose *.xls as the data source file.

 

[Thomas A. Rowe]

FP can create the Access database for you, the owner doesn't need to have Access unless he want to
actually open the database. FYI: The site must be hosted on a Windows IIS web server, not
Unix/Linux.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Eco]

I've similar problem that has some info to let the customer to view the
status of project. The source of status info is come from Excel worksheet.
We find that we can't simply export excel sheet to webpage because there
will have many row of records which is hardly to be viewed on screen. It's
better to have some function to filter the page or has button to go next
page.

How can I let our user to update excel and then update it on webpage easily?
Is it possible that we don't need use/go through Access? Can we implement
this?

 

[Stefan B Rusynko]

Although not recommended you can use Excel as a Data source
See http://support.microsoft.com/default.aspx?scid=268948

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've similar problem that has some info to let the customer to view the
| status of project. The source of status info is come from Excel worksheet.
| We find that we can't simply export excel sheet to webpage because there
| will have many row of records which is hardly to be viewed on screen. It's
| better to have some function to filter the page or has button to go next
| page.
|
| How can I let our user to update excel and then update it on webpage easily?
| Is it possible that we don't need use/go through Access? Can we implement
| this?
|
|
| "Thomas A. Rowe" <[email protected]> ¦b¶l¥ó
| ¤¤¼¶¼g...
| > FP can create the Access database for you, the owner doesn't need to have
| Access unless he want to
| > actually open the database. FYI: The site must be hosted on a Windows IIS
| web server, not
| > Unix/Linux.
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > Okay, I have a customer who wants me to add password-protected areas to
| > > his site, created with FP2003. He owns a construction company, and
| > > wants customers to be able to log with a user name and password to a
| > > special area that will have schedules, photos, files related to that
| > > particular job.
| > >
| > > Have never done this before, so was following Microsoft's advice at
| > > http://support.microsoft.com/default.aspx?scid=kb;en-us;825498
| > > on "How to create a password-protected Web page by using FrontPage
| > > 2003, Active Server Pages, and an Access database"
| > >
| > > However... the company owner does not HAVE Access and wants to use
| > > Excel for the database instead. I'm not sure it will work in this case
| > > - will it?
| > >
| > > HELP! Pretty please...
| > >
| > > Diana
| > >
| >
| >
|
|

 

[Thomas A. Rowe]

Excel is single user file format whereas Access is a multi-user file format, so it better to use on
the web, and you will have less problems.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Eco]

If using Access, can I use it without SQL? I mean let our user to input data
on access and publish it on web page.
The view of info is very simple. Just want to let the customer viewing on
web anywhere through IE. So I want to do it as simple for user as possible.

Then here are the steps to
A. Create webpage
1. create / design access database
2. create data connection to access database in Frontpage
3. design the webpage for viewable
4. post the webpage on IIS which support ASP.

B. For user
1. Input / update data on access database

C. For customer
1. goto specified URLto view the webpage.

Is it correct?

 

[Thomas A. Rowe]

If all a site visitor will be doing is viewing the content, then you can save as HTML from Excel and
upload the page to the web site.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================