PC Review


Reply
Thread Tools Rate Thread

ASP and database file

 
 
Stitson
Guest
Posts: n/a
 
      10th Aug 2004
Hello,

I am running a fairly simple web site, pages made in FrontPage 98, not
using FP Extensions because the server only handles extensions for FP
2000 and later. I'm happy with this, and don't feel the need the
upgrade.
All pages have the .HTM extension. I use frames. The left frame page
is contents.htm, the main right frame page is home.htm, and the
overall frame page that first opens up, is index.htm.
I'd like to place an Access data file into the web. Users would open
a web page where there are fields for typing in search terms. Data
records containing these search terms would appear in a generated
list, using SQLs. The users do not need to see the contents of the
entire data file, nor add, delete or modify any records.
To create a web page containing data search fields, does it take place
on a form? Should the three HTM pages mentioned above all be
converted to .ASP extension, or can I build the new form page in a
sub-folder giving it the . ASP extension? Where do I place the Acess
data file - in the same folder, or somewhere else? Another complexity
is that the section of the web site where the search terms are input,
and the results are displayed, will be in a password-protected folder.
Is there a reference book that will answer all the above questions,
with VBScript samples?
I hope this is all clear.
Thanks,
Roger Stitson
 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      10th Aug 2004
1. FP2000 extensions do support features/functions in FP98 that require extensions, so there is no
reason not to take advantage of them.

2. To use ASP and Access you site must be hosted on Windows IIS web server. Since you are using
FP98, you will need to do a lot of the ASP coding manually, and if you want to place the ASP content
in a folder, it would need to be a subweb, and you host will have to set up the correct permissions,
since FP98 can not do this for you, which is not the case with FP2000 and up, which can set the
correct permissions.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Stitson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I am running a fairly simple web site, pages made in FrontPage 98, not
> using FP Extensions because the server only handles extensions for FP
> 2000 and later. I'm happy with this, and don't feel the need the
> upgrade.
> All pages have the .HTM extension. I use frames. The left frame page
> is contents.htm, the main right frame page is home.htm, and the
> overall frame page that first opens up, is index.htm.
> I'd like to place an Access data file into the web. Users would open
> a web page where there are fields for typing in search terms. Data
> records containing these search terms would appear in a generated
> list, using SQLs. The users do not need to see the contents of the
> entire data file, nor add, delete or modify any records.
> To create a web page containing data search fields, does it take place
> on a form? Should the three HTM pages mentioned above all be
> converted to .ASP extension, or can I build the new form page in a
> sub-folder giving it the . ASP extension? Where do I place the Acess
> data file - in the same folder, or somewhere else? Another complexity
> is that the section of the web site where the search terms are input,
> and the results are displayed, will be in a password-protected folder.
> Is there a reference book that will answer all the above questions,
> with VBScript samples?
> I hope this is all clear.
> Thanks,
> Roger Stitson



 
Reply With Quote
 
Stitson
Guest
Posts: n/a
 
      11th Aug 2004
OK - thanks. Manual coding not a problem.

- Roger


On Tue, 10 Aug 2004 01:31:11 -0400, "Thomas A. Rowe" <(E-Mail Removed)>
wrote:

>1. FP2000 extensions do support features/functions in FP98 that require extensions, so there is no
>reason not to take advantage of them.
>
>2. To use ASP and Access you site must be hosted on Windows IIS web server. Since you are using
>FP98, you will need to do a lot of the ASP coding manually, and if you want to place the ASP content
>in a folder, it would need to be a subweb, and you host will have to set up the correct permissions,
>since FP98 can not do this for you, which is not the case with FP2000 and up, which can set the
>correct permissions.
>
>--
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
>"Stitson" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> Hello,
>>
>> I am running a fairly simple web site, pages made in FrontPage 98, not
>> using FP Extensions because the server only handles extensions for FP
>> 2000 and later. I'm happy with this, and don't feel the need the
>> upgrade.
>> All pages have the .HTM extension. I use frames. The left frame page
>> is contents.htm, the main right frame page is home.htm, and the
>> overall frame page that first opens up, is index.htm.
>> I'd like to place an Access data file into the web. Users would open
>> a web page where there are fields for typing in search terms. Data
>> records containing these search terms would appear in a generated
>> list, using SQLs. The users do not need to see the contents of the
>> entire data file, nor add, delete or modify any records.
>> To create a web page containing data search fields, does it take place
>> on a form? Should the three HTM pages mentioned above all be
>> converted to .ASP extension, or can I build the new form page in a
>> sub-folder giving it the . ASP extension? Where do I place the Acess
>> data file - in the same folder, or somewhere else? Another complexity
>> is that the section of the web site where the search terms are input,
>> and the results are displayed, will be in a password-protected folder.
>> Is there a reference book that will answer all the above questions,
>> with VBScript samples?
>> I hope this is all clear.
>> Thanks,
>> Roger Stitson

>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The database 'databasename.mdb' needs to be repaired or isn't a Microsoft Access database file Joe M Microsoft Access Security 3 17th Jun 2008 09:55 AM
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file "Location" failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. weird0 Microsoft C# .NET 1 20th Apr 2007 10:04 AM
Any solution for error message "Could not attach file 'App_Data\Database.mdf' as database 'Database'."? ornit_sagy@yahoo.com Microsoft ADO .NET 0 8th Jan 2007 08:34 PM
Any solution for error message "Could not attach file'App_Data\Database.mdf' as database 'Database'."? ornit_sagy@yahoo.com Microsoft ADO .NET 1 8th Jan 2007 08:12 PM
exporting an excel file from database; making changes to excel file and updating the database by importing it back Luis Esteban Valencia Microsoft ASP .NET 1 12th Jan 2005 12:28 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:15 AM.