×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem connecting Access Databases to Website

Problem connecting Access Databases to Website

Problem connecting Access Databases to Website

(OP)
About six months ago I had to change my Server for my Old Boys Association Website to the 1&1
Ever since then when I try to open any page containing an Access Database I get the following error


Database Results Error
The database connection named 'oldboys2.mdb' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root

I have been in touch with 1&1 on countless occasions but have not been able to solve the problem
The site worked perfectly OK with our previous server
I have tried building a new page through a different Website but still get the same response
When I view the main page with a fault through Fron Page I get the following error report

This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.

Unfortunately my knowledge on this subject is very limited, ie I have tried to learn it by reading various books, which I find difficult to understand

from an ignorant SOG61

RE: Problem connecting Access Databases to Website

Try a dsn-less connection instead of depending on global.asa to attach to your website.

RE: Problem connecting Access Databases to Website

(OP)
XWB

Thanks for the response, I found out what instruction to add but in my ignorance I was not sure where it should be added so I added it to one of the pages that was not working, no change, I then moved the instruction to global.asa without any luck, I then tried it in both places still no change. Hope I have done this correctly.
Unfortunatley my knowledge on this is very limited
Regards  SOG61

RE: Problem connecting Access Databases to Website

global.asa is a bit of a pain.  The system only looks at global.asa which is at root level: not the one on your website.  As a result, nothing will work whatever you do to global.asa.

Try this first.  Replace

zzz with the name of your database
YYY with the key field
XXX with the table

CODE

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>DB Test</title>
</head>
<body>
<%
dim conn, mdbpath, connstr, sqlQuery
mdbpath = Server.MapPath("zzz.mdb")
sqlQuery = "select * from XXX"
'
' This is the same for all the DBs
set conn = Server.CreateObject("ADODB.Connection")
connstr = "Driver={Microsoft Access Driver (*.mdb)};"
connstr = connstr & "DBQ=" & mdbpath & ";"
conn.Open connstr
set rs = conn.Execute (sqlQuery)
%>
<ul>
<%
while not rs.eof
%>
<li><%=rs("YYY")%>
<%
    rs.MoveNext
wend
conn.Close
%>
</body>
</html>
Save it as Test.asp (note the uppercase T).  Download it and run it as test.asp

If this doesn't work, i.e. it says "page not found" you have a Unix server which does not support access.  You probably have to try another server.  Unix is case sensitive, windows is not.  In Unix, Test.asp and test.asp are two different files.  On Windows, they are the same file.

If it works, this will list all the records in the database.  If it doesn't, then check

- has the database been downloaded?
- is the relative path for the database correct?

Assuming it works, would it be possible to check whether your global.asa has been uploaded.  It is just a long shot.    Your global.asa may be the top level one but if it does not exist, then your web page won't be able to find it.

That is all I can think of right now.

RE: Problem connecting Access Databases to Website

(OP)
Dear xwb
Many thanks for the advice, I have loaded the file as mentioned and I get the message - 'Page not found' as you also mentioned
I have had a look at my Web Server details, I am with 1&1 and have Business Pro Package, which says it supports Access + 2 x MSSQL Databases and that the Server is Linux.
I upgraded to the Business Pro package as an attempt to cure this problem, but to date all it has done is cost me more money and almost drive me round the bend.
I will continue fiddling in the hope of getting somewhere.
The problem with 1&1 is that get a response from a Technician, and when you reply you get the response from someone else and they go off on different paths, but never seem to answer the actual question
Regards  SOG61

RE: Problem connecting Access Databases to Website

I'm not sure if Linux supports access but just in case it does, you are probably using some form of Unix ODBC.  Anyway there can be several things that don't work.  Try this: put it in a file called now.asp and upload it to your server and run it.  If it works, it will tell you the time, if it doesn't then you have to ask your provider to enable asp.

CODE

<html>
<head><title>ASP Check</title></head>
<body>
<p>ASP working - <b>
<%= Time %>
</b></p>
</body></html>
If that works, the next step is to find out whether it supports vbscript.  Frontpage generates the client side in Javascript but the server side is always vbscript.  There may be a way of changing it but I don't know what it is.  Put this in vbstest.asp

CODE

<%@LANGUAGE="VBSCRIPT"%>
<html>
<head><title>VBScript Test</title>
<body><p>
<%
for i=0 to 10
   Response.Write "Working " & cstr(i)& "<br/>"
next
%>
</p></body>
</html>
You should get 10 items saying working.  If that doesn't work try the same thing in javascript, otherwise skip this bit.

CODE

<%@LANGUAGE="JAVASCRIPT"%>
<html>
<head><title>JavaScript Test</title>
<body><p>
<%
for (i = 0; i < 10; ++i)
   Response.Write ("Working " + cstr(i) + "<br/>")
%>
</p></body>
</html>
If JavaScript works, then you have to ask 1&1 to put you on to a server that supports vbscript or find a way in frontpage of regenerating everything in javascript.

If you are past the vbscript bit, try a simple query.  Run up Test.asp in my first posting.  Do you get any results back from it?  If you don't, check the mdb filename.  Unix is case sensitive so make sure that if you have typed everything in lowercase on your pc, that it is still in lowercase in test.asp.  If that still doesn't work, try changing the database filename to uppercase in the asp file.

If all that works, then your server may not be front page enabled.  Just ask 1&1 if it is frontpage enabled.  If it isn't and they can't do it, then you will have to rewrite the queries as dsn-less connections.  It isn't as daunting as it sounds.  See how you get on - if it needs rewriting, I can give you a template.

RE: Problem connecting Access Databases to Website

(OP)
xwb
Sorry to have to come back to you again, queried the asp activation with 1&1, but made the faullt of asking them about the error report, so they checked the link and told me that they get a different error, needless to say no suggestion of how to amend, also ignored the asp question.
Referring back to your previous piece about Test.asp, I am wondering if I entered the correct details, I note you said Key field to be put in YYY, not sure what I should have put in there (sorry my ignorance again). The response from 1&1 re error report was different to mine, they got:

Microsoft VBScript compilation  error '800a0400'
Expected statement
/LM/W3SVC/40315680/ROOT/global.asa, line 28
<%
^

While I get the following on my Computer at home:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Please try the following:
Open the www.odwa.co.uk home page, and then look for links to the information you want.

Click the  Refresh button, or try again later.
Click  Search to look for information on the Internet.  
You can also see a list of related sites.
HTTP 500 - Internal server error
Internet Explorer

My Computer at work brings up the same error as 1&1 get.

Seems weird to me as I cannot rely on the error reports at home, incidentally they were the same on all computers before we started trying to solve it.

SOG61

RE: Problem connecting Access Databases to Website

When I click on "old boys", I get

CODE

<% Set demoConn = Server.CreateObject("ADODB.Connection") demoFilePath = "C:\NewWebsites\odwa2006\fpdb\oldboys2.mdb" demoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & demoFilePath & ";" %>

TIME: <% =Time() %>

DATA: <% =Application("oldboys2.mdb_ConnectionString") %>
which suggests that it is not recognized.

1) Make sure the file has the extension .asp.  The system will not pick up asp files if they end with htm.
2) Your demofilepath should be relative to your website location.  Do not use absolute filenames.

I don't get the error that you get.

RE: Problem connecting Access Databases to Website

(OP)
xwb

Thanks again for your assistance, one of the links that I have been having the main problem with is:

http://www.odwa.co.uk/oldboy_search/oldboysdb1955-59.asp

The main page of the site opens, but when I click on the 1955-59 section (oldboysdb1955-59.asp) I get the message page can not be displayed, this used to produce the 5 year age span from the database, and other links did similar for the other age groups.

Referring back to your previous piece about Test.asp, I am wondering if I entered the correct details, I note you said Key field to be put in YYY, not sure what I should have put in there (sorry my ignorance again).

Regards  SOG61

RE: Problem connecting Access Databases to Website

YYY can be any field.

OK - I've tried your web page.  Gets error 800A03EA.  Basically moaning about illegal characters.  This is most likely something to do with the table or database names.
A good ref for these errors is http://www.computerperformance.co.uk/Logon/code/code_800A03EA.htm
 Check that

1) there are no spaces
2) there are no - (hyphens).  If you have to use a hyphen, replace it with an underscore

Alternatively, could you post the first 24 lines of global.asa.

RE: Problem connecting Access Databases to Website

(OP)
xwb

Many thanks once again for your perseverance with me, if only 1&1 would show similar interest, I still haven't got an answer to my message of yesterday morning about asp being enabled.

first 36 lines of global.asa follows:

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Application_OnStart
    '==FrontPage Generated - startspan==
    Dim FrontPage_UrlVars(2)
    '--Project Data Connection
        Application("Database1_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=htdocs/forms/oldboys2.mdb;UID=u40315680;PWD=fed2well"
        FrontPage_UrlVars(0) = "Database1_ConnectionString"
        Application("Database1_ConnectionTimeout") = 15
        Application("Database1_CommandTimeout") = 30
        Application("Database1_CursorLocation") = 3
        Application("Database1_RuntimeUserName") = "u40315680"
        Application("Database1_RuntimePassword") = "fed2well"
    '--Project Data Connection
        Application("Sample_ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/FPNWIND.MDB"
        FrontPage_UrlVars(1) = "Sample_ConnectionString"
        Application("Sample_ConnectionTimeout") = 15
        Application("Sample_CommandTimeout") = 30
        Application("Sample_CursorLocation") = 3
        Application("Sample_RuntimeUserName") = ""
        Application("Sample_RuntimePassword") = ""
    '--
    Application("FrontPage_UrlVars") = FrontPage_UrlVars
    '==FrontPage Generated - endspan==
Sub FrontPage_ConvertFromODBC
    On Error Resume Next
    if Len(Application("ASP_OS")) > 0 then exit sub
    str = "_ConnectionString"
    slen = Len(str)
    set oKnown = Server.CreateObject("Scripting.Dictionary")
    oKnown.Add "DRIVER",""
    oKnown.Add "DBQ",""
    oKnown.Add "SERVER",""
    oKnown.Add "DATABASE",""
    oKnown.Add "UID",""
    oKnown.Add "PWD",""
    Application.Lock

Incidentally I still get the Unable to display page error for the same link, is this because the actual fault ison this computer, seems weird to me. Thanks again

SOG61

RE: Problem connecting Access Databases to Website

You need to change your global.asa and upload it again.  There is an end sub missing.

CODE

       Application("Sample_RuntimePassword") = ""
    '--
    Application("FrontPage_UrlVars") = FrontPage_UrlVars
    '==FrontPage Generated - endspan==
end sub
Sub FrontPage_ConvertFromODBC
    On Error Resume Next
    if Len(Application("ASP_OS")) > 0 then exit sub

RE: Problem connecting Access Databases to Website

Just as a matter of interest, which version of frontpage are you using?  In the global.asa that frontpage creates for me (both 2000 and XP), the next sub is Session_OnStart, followed by FrontPage_StartSession.  I've never seen Fontpage_ConvertFromODBC.

RE: Problem connecting Access Databases to Website

(OP)
Dear xwb

Thanks again, I thing we might be getting somewhere now, having changed the global.asa as you mention, and visiting the site I now get the message:

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.

So I assume I need to try and get some sense out of 1&1

I am using Front Page 2003

Regards  SOG61

RE: Problem connecting Access Databases to Website

I'm just wondering whether something happened to your global.asa.  Is it the same size as when it did work?

Try something - create a new website using front page.  Use the database wizard to generate something similar to oldboysdb1955-59.asp.  Exit front page.  Compare the global.asa generated with the one you posted to your website.  The bits in Application_onStart will be different but is the stuff after the first end sub the same?

I don't have FrontPage2003 so I can't check whether the first routine after Application_onStart is Sub FrontPage_ConvertFrom ODBC.

If it isn't, create another global.asa with

a) All the code up to the first end sub from the  old global.asa
b) All the code after the first end sub from the new global.asa

A bit like Terry Wogan in the BBC advert after he has removed his shirt.  Then try uploading this global.asa and see what you get.

RE: Problem connecting Access Databases to Website

(OP)
Dear xwb
On printing out a new global.asa and comparing it with the existing one, at a quick glance it look like a whole section has been duplicated in the one I am using, 3 and a bit pages against 2 and a bit on the new one.
I will back up both files and then try concocting the two.
I am also checking out an older Computer which still has Front Page 2000 running on it for some reason, although I was getting the problem then as well.
Regards  SOG61

RE: Problem connecting Access Databases to Website

(OP)
Dear xwb

I have deleted the global file and before changing it I found an old version dated May 2002, uploaded that, and EUREKA the pages work again after over six months

Thanks a million for your excellent help

Kindest regards  SOG61

RE: Problem connecting Access Databases to Website

There is still the problem when clicking on oldboys.  I think if you just change the extension from oldboys.htm to oldboys.asp, that should fix it.

RE: Problem connecting Access Databases to Website

(OP)
xwb
Thanks for spotting that, I thought I had checked it all, even the picture database links on the home page work OK.

Tried changing title to oldboys.asp and it just stops the whole page loading and I get the Page cannot be displayed error back, but as soon as I try one of the other page Old Boys links that I did not change the page opens ok as oldboys.htm, so have changed it back.
Just printing out a page that does work OK to compare with the one that doesn't to see if anything funny has slipped in, although to the best of my knowledge these pages should not have changed.
Pity about this because I was so pleased, I keep going to the site to make sure it is still OK. Have already had a few congratulations, to pass on to you
Regards SOG61

RE: Problem connecting Access Databases to Website

(OP)
xwb
I have compared the printout and can't see anything obvious, but of course it does differ as the Old Boys section is also part of a search option.
Re your other suggestion, when I use the link

http://www.odwa.co.uk/oldboy_search/oldboys.asp

I get the HTTP 500 error, the page cannot be displayed

where as

http://www.odwa.co.uk/oldboy_search/oldboys.htm

is needed to get main page up to go to the other searches

Regards  SOG61

RE: Problem connecting Access Databases to Website

You have to rename the file as well and upload it.

RE: Problem connecting Access Databases to Website

(OP)
xwb

Yes I changed and loaded the file as oldboys.asp, and also changed the link in the home page to oldboys.asp, and as soon as I do that the page only loads with an error report as my example shows.
As soon as I change it back to oldboys.htm the rest of the page works again, so I have changed the actual site back to htm so that it works, but left the file there so that my example shows you the end result.
Sorry if I misled you but I thought I did it as you intended, just loaded it again and it immediately shuts off the page again so have changed it back as I told a few members that have been asking about getting it repaired that it is now working again
Regards  SOG1

RE: Problem connecting Access Databases to Website

(OP)
xwb
To save messing members up again I have made the suggested change to the old boys link on the Committee Page:

http://www.odwa.co.uk/committee/committee.htm

and when you go to the Old Boys link at the top I get the page missing report, but the oldboys.asp file is still loaded
Regards  SOG61

RE: Problem connecting Access Databases to Website

Sorry I didn't reply earlier - I was out Morris Dancing last night.

Anyway, the file looks pretty messed up.  Looks like 3 files merged in one.
1) Open the file in notepad
2) Delete everything from the top until the third <html>

You're right - it should be an HTM file not an asp file.  It is just that some spurious bits of 2 other files got merged on top of it.

RE: Problem connecting Access Databases to Website

(OP)
xwb

Thanks again, the extra bits were things that 1&1 told me to add, but they didn't explain where to put them very well, file loads OK again, but the one page still does not open and search.
I have copied the file that doesn't work, oldboysdball.asp to see if you can see an error in there for me.
Trust you enjoyed your evening, I have a friend here in Kent who has been a Morris Dancer for many years.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_LCID = 2057 %>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Old Dartechs</title>
</head>

<body background="../images/odwa_small_background.gif">

<h1 align="center">Old Dartechs' &amp; Wilmingtonians' Association<br>
<small><font color="#0000FF">Old Boys Database</font></small></h1>

<h3 ALIGN="center"><a href="JavaScript:;" onclick="window.top.close();"">Click
here to exit database</a></h3>

<hr>

<div align="center">
  <center>
  <table style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
    <tbody>
      <!--webbot bot="DatabaseRegionStart" s-columnnames="LastUpdated" s-columntypes="202" s-dataconnection="oldboys2.mdb" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="get_last_update" s-displaycolumns="LastUpdated" s-criteria s-order s-sql="SELECT * FROM get_last_update" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM get_last_update"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="oldboys2.mdb"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&LastUpdated=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="18806" --><tr>
        <td>
        <h4 align="center">
        <!--webbot bot="DatabaseResultColumn" s-columnnames="LastUpdated" s-column="LastUpdated" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LastUpdated&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"LastUpdated")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28680" --></h4>
        </td>
      </tr>
      <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
  </table>
  </center>
</div>
<div align="center"><center>

<table BORDER="1" CELLSPACING="1" BORDERCOLOR="#0f5e00" CELLPADDING="2" WIDTH="421">
  <tr>
    <td WIDTH="16%" HEIGHT="17"><p
    ALIGN="LEFT"><b><font face="MS Sans Serif" size="1">Position</font></b></td>
    <td WIDTH="84%" HEIGHT="17"><font FACE="MS Sans Serif" SIZE="1" COLOR="#000000"><p
    ALIGN="LEFT">&lt;blank&gt; = pupil, <strong>Ag</strong> = Agricultural College<br>
    <b>S</b> = staff, <b>G</b> = Governor, <b>Pta </b>= PTA, <b>H</b> = Headmaster</font></td>
  </tr>
  <tr>
    <td WIDTH="16%" HEIGHT="43"><p
    ALIGN="LEFT"><b><font face="MS Sans Serif" size="1">DB Info</font></b></td>
    <td WIDTH="84%" HEIGHT="43"><p
    ALIGN="LEFT"><font face="MS Sans Serif" size="1" color="#000000"><b>y</b> = Full
    contact details known<br>
      <b>n</b> = No current contact
    detail known<br>
      <b>p</b>= Partial contact detail known<br>
    <b>d</b>= Oldboy is deceased</font></td>
  </tr>
  <tr>
    <td WIDTH="16%" HEIGHT="29"><font FACE="MS Sans Serif" SIZE="1"><b><p
    ALIGN="LEFT">e-mail</b></font></td>
    <td WIDTH="84%" HEIGHT="29"><p
    ALIGN="LEFT"><b><font face="MS Sans Serif" size="1">on file</font></b><font FACE="MS Sans Serif" SIZE="1" COLOR="#000000"> = e-mail
    address known<br>
      <b>n/a </b>= No e-mail address known</font></td>
  </tr>
</table>
</center></div>

<p ALIGN="LEFT"><a target="_blank" href="oldboysdball_help.htm">For Help on search
click here</a></p>
<form BOTID="2" METHOD="POST" ACTION="oldboysdball.asp">
  <table BORDER="0">
    <tr>
      <td><b>Family Name</b></td>
      <td>
      <input TYPE="TEXT" NAME="Name1" VALUE="<%=Request("Name1")%>" size="20"></td>
    </tr>
    <tr>
      <td><b>Given Name</b></td>
      <td>
      <input TYPE="TEXT" NAME="ChristianName1" VALUE="<%=Request("ChristianName1")%>" size="20"></td>
    </tr>
    <tr>
      <td><b>Start Date</b></td>
      <td>
      <input TYPE="TEXT" NAME="Sdate" VALUE="<%=Request("Sdate")%>" size="20"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>
      <h4>All fields are optional and partial entries are permitted</h4>
      </td>
    </tr>
  </table>
  <p><input TYPE="Submit"></p>
</form>
<table width="100%" border="1">
  <thead>
    <tr>
      <td><b>Given<br>
      Name</b></td>
      <td><b>Family<br>
      Name</b></td>
      <td align="center"><b>Start<br>
      Date</b></td>
      <td align="center"><b>Leave<br>
      Date</b></td>
      <td align="center"><b>Email</b></td>
      <td align="center"><b>Position</b></td>
      <td align="center"><b>DB<br>
      Info</b></td>
      <td align="center"><b>Last<br>
      Updated</b></td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-columntypes="202,202,202,202,202,202,202,135" s-dataconnection="oldboys2.mdb" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="oldboys_select" s-displaycolumns="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-criteria="[Name1] CNT {Name1} + [ChristianName1] CNT {ChristianName1} + [Sdate] CNT {Sdate} +" s-order s-sql="SELECT * FROM oldboys_select WHERE (Name1 LIKE '%::Name1::%' AND ChristianName1 LIKE '%::ChristianName1::%' AND Sdate LIKE '%::Sdate::%')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Name1=&amp;ChristianName1=&amp;Sdate=" s-norecordsfound="No records returned." i-maxrecords="500" i-groupsize="50" botid="2" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM oldboys_select WHERE (Name1 LIKE '%::Name1::%' AND ChristianName1 LIKE '%::ChristianName1::%' AND Sdate LIKE '%::Sdate::%')"
fp_sDefault="Name1=&ChristianName1=&Sdate="
fp_sNoRecords="<tr><td colspan=8 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="oldboys2.mdb"
fp_iMaxRecords=500
fp_iCommandType=1
fp_iPageSize=50
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ChristianName1=202&Name1=202&Sdate=202&Ldate=202&Email1=202&Position=202&DBInfo=202&LastUpdate=135&"
fp_iDisplayCols=8
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14662" --><tr>
      <td bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="ChristianName1" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;ChristianName1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_Field(fp_rs,"ChristianName1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="39613" --></td>
      <td bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="Name1" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Name1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_Field(fp_rs,"Name1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4066" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="Sdate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Sdate&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Sdate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8066" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="Ldate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Ldate&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Ldate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="7618" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="Email1" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Email1&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_Field(fp_rs,"Email1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12419" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="Position" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Position&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"Position")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16979" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="DBInfo" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;DBInfo&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_Field(fp_rs,"DBInfo")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10569" --></td>
      <td align="center" bgcolor="#FFFF00">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="ChristianName1,Name1,Sdate,Ldate,Email1,Position,DBInfo,LastUpdate" s-column="LastUpdate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LastUpdate&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"LastUpdate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27820" --></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="50" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;  |&lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;   &lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;   &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;|  &quot;&gt;  [1/50]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>

<hr>

<h3 ALIGN="center"><a href="JavaScript:;" onclick="window.top.close();"">Click
here to exit database</a></h3>

</body>

</html>

Kindest Regards  SOG61

RE: Problem connecting Access Databases to Website

It is quite difficult to tell with so much autogenerated stuff.  I'll load it into MSE and have a look.  May take some time.  LOoks like a lot of code.

RE: Problem connecting Access Databases to Website

(OP)
xwb
Thanks again, I am very thankful that you have got me as far a you have, at least now most of the site is working I feel more like working to get everything up to date

I should imagine that if there was an error in there it would be in the early part. I spotted this bit in the middle and I wondered if that was something to do with it

The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");

All the best SOG61



RE: Problem connecting Access Databases to Website

I don't really know what is wrong with it.  I can't load it into frontpage2000 because it keeps on modifying the script.  That is one of the annoying bits of frontpage.  Gets even worse if you use VML.  One thing you could try

Open the script in frontpage make a minor mod (eg delete the h in html and put it back) then save the script.  What frontpage will do is regenerate the code.  Upload this and see what happens.

Another way of checking it is to look for a program called either mse.exe or mse7.exe.  This program may or may not exist on your system.  If it doesn't exist, open up frontpage, Tools/Macro/Microsoft Script Editor and it will get installed for you.  Close Frontpage and try opening your script in the script editor.  When I try this, it moans that there is a quote missing.  Just wondering if you get the same problem.

RE: Problem connecting Access Databases to Website

(OP)
xwb
Deleted one letter and saved, replaced letter as you suggested and saved file again, and loaded back to the web.
Found mse7.exe and opened file OK.

Went back to check the Website and EUREKA the page works OK, so once again many thanks for your perseverance with me and a job well done.

Kindest regards  SOG61

and good luck with the Dancing

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close