Post Data to a Access Database

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How do I get my page footer (included in all pages in a layout table) to be the same width on all pages (full-width)? How do I get my page footer (included via web component in all pages which uses a layout table and cell) to have the same width on all pages. ie. the full page width? Some pages have large tables in them, and the footer only goes across part of the bottom of the page. I used 100% Table column width and "auto-scale cells with table' is turned on for the one cell in the layout table in the footer page. Tag: Post Data to a Access Database Tag: 33503
  - 2
    - Web Page Form Display I made a web form and on it towards the top there is the following: [FrontPage Save Results Component] How can I remove that? Also is it possible to edit the form confirmation screen to return to a different page then the form again? TIA. -Randy- Tag: Post Data to a Access Database Tag: 33502
  - 3
    - Search form error: Service is not running. I created a search form in Frontpage by inserting component and followed the step by step instruction on the help document. But everytime I tried to use the search form, it says "service is not running". Please advise. I recalculated all the hyperlinks. Thanks! Tag: Post Data to a Access Database Tag: 33489
  - 4
    - Cursor or Pointer in MS FRontpage 2003 There is probably a easy fix to this to which I am not aware of, since I have not used Frontpage 2003 before. When editing webpages, I CANNOT see the cursor on the page in design view. If I click on a text..It is like I am typing a blank area without being able to see where my cursor actually is. Is there a way to turn it back to a normal way where i can see the pointer. Please email me at sunny@infousanet.com if you have a solution. Thanks! Sunny Tag: Post Data to a Access Database Tag: 33487
  - 5
    - Screenshots, How to? I'm trying to trake a screenshot of one of FP pages that I'm working on. How can I do this? Thanks Tag: Post Data to a Access Database Tag: 33486
  - 6
    - Jump Links Can someone tell me how to link a topic at the top of a page to the actual written description of the topic farther down on the page? I believe they call this a "jump link?" Thanks so much, Janet Tag: Post Data to a Access Database Tag: 33484
  - 7
    - Changing the automatic confirmation page Does anyone know how to change remove the automatic confirmation that FP puts into the code upon creating a form submission to a database? I would like the confirmation to be a page I created. Below is the code that is the problem. FP_FormConfirmation "text/html; charset=windows-1252",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "post.asp",_ "Return to the form." When I edit this code it messes up my database connection. There must be a way to get rid of this automatic page and redirect to the desired page but I am not a coder. Any ideas? Tag: Post Data to a Access Database Tag: 33476
  - 8
    - FrontPage 2002 I would like to add music to my webpage, but would like my readers to have the opportunity to click on the music themselves and not have it start when they click on the page. Thanks for your help Dom dombb64@ptd.net Tag: Post Data to a Access Database Tag: 33475
  - 9
    - How can I easily get all pages to use the included Banner page background colour? (do I have to use a table?) I am using an Include (Insert | Web component | Included Content | Page ) to add a banner to every page in my site. When I change the background colour on my banner.html page it does not propagate to all other pages. It will propagate if I create a table in my Banner page though and change the cell formatting background colour. How can I easily get all pages to use the included Banner page background colour? Tag: Post Data to a Access Database Tag: 33472
  - 10
    - I need advice I am currently trying to design a web for a realesate company. I would like to be able to click on each agent and see a list of property they have listed. and also click on view all properties and see a list of all properties on a seperate page by themsleves without the agent. What is the best possible way to get this done without having to go in and manually list the home next to each agent and again on the view all properties. Thank You Tag: Post Data to a Access Database Tag: 33470
  - 11
    - Dynamic html Does FP 2003 offer Dynamic html? and if so will it work in Internet Explorer? Once I apply it should it be visible to all? and if not then what could the problem be? thanks for all your help!! Tag: Post Data to a Access Database Tag: 33468
  - 12
    - FrontPage 2003 - Enter Key Exits Form Using FrontPage 2003, I created a form using a combination of text boxes, drop-down boxes and check boxes. All works great except when you hit an Enter Key within any text box, the form immediately ends storing the data as if the form had been completed . The text boxes are optional comment areas within a survey so making them required (validation) is not really an option. Even if I make the last field required entry, all previous answers (long survey - 50+ questions) are lost when the person returns to the form. Can the enter key be disabled within the form? Any other suggestions? Thanks, Neal Tag: Post Data to a Access Database Tag: 33454
  - 13
    - ASP update error This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3F7A4.B9781DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Now I know this code works on IIS5.0, trying it on a Windows2003 server = (IIS6) I get this lovely error which I can not trace, I think it's = something either on IIS6 or the server but any suggestions welcome.... On loading the update page I get the error... Database Results Wizard Error The operation failed. If this continues, please contact your server = administrator. The SQL code is UPDATE t_deeds_main SET deed_no=3D'::deed_no::' WHERE = id=3D::id:: As I say, works fine on IIS5, and I can view asp pages OK on IIS6 but = adding a custom query just throws it. Any help appreciated. Setup:- FP2003, IIS6, SQL2000SP2 (SQL and IIS on separate boxes). ------=_NextPart_000_0008_01C3F7A4.B9781DE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""> <DIV><FONT face=3DArial size=3D2>Now I know this code works on IIS5.0, = trying it on=20 a Windows2003 server (IIS6) I get this lovely error which I can not = trace, I=20 think it's something either on IIS6 or the server but any suggestions=20 welcome....<BR><BR>On loading the update page I get the=20 error...<BR><BR><STRONG>Database Results Wizard Error<BR>The operation = failed.=20 If this continues, please contact your server=20 administrator.</STRONG></FONT></DIV> <DIV><STRONG><FONT face=3DArial size=3D2></FONT></STRONG> </DIV> <DIV><FONT face=3DArial size=3D2>The SQL code is <STRONG>UPDATE = t_deeds_main SET=20 deed_no=3D'::deed_no::' WHERE id=3D::id::</STRONG></FONT></DIV> <DIV><STRONG><FONT face=3DArial size=3D2></FONT></STRONG> </DIV> <DIV><FONT face=3DArial size=3D2>As I say, works fine on IIS5, and I can = view asp=20 pages OK on IIS6 but adding a custom query just throws it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any help appreciated.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Setup:- FP2003, IIS6, SQL2000SP2 (SQL = and IIS on=20 separate boxes).</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3F7A4.B9781DE0-- Tag: Post Data to a Access Database Tag: 33447
  - 14
    - Frontpage and MSGraph? Dear all, I'm building a web application (IIS & .asp) with Frontpage and an Access data base. So far so good, thanks to the wizards, but on one page I would like to present some data from the Access data base in a simple graph. To add the graph on the page is easy in Frontpage but how do I customize the appearance and, most important of all, how do I feed data to the graph? I have searched the Knowledge base but there seems to be very little information available. I'm not an expert in VB hence I need examples to understand how it works. I would be grateful if anybody could give some help on this or perhaps direct me to some informative sources. Is there maybe a better solution with another application? Best regards, Peter Stalberg (peter.stalberg@swedishclub.com) Tag: Post Data to a Access Database Tag: 33446
  - 15
    - Password Protected pages Hello, I am running IIS 6.0 W2k3 and using FP 2002 an created a logon web with password database from the article below. When I go to test the web all I see is code. Why? ASP is enabled on the server but the original web was created on a disc and then published to the server. Anyhow why the code and not the test? Thanks Joe http://support.microsoft.com/default.aspx? kbid=825498&product=fp2003 Tag: Post Data to a Access Database Tag: 33436
  - 16
    - Banner Ad Manager Help! I used the Banner Ad Manager on my website homepage to show some of my paintings. It show up in FrontPage but not on the internet. The page is blank on my internet site. Do any of you know what I can do to make it show? BTW, it WAS showing fine until I updated some 'critical updates' from windows. :( Thanks for your help. Tag: Post Data to a Access Database Tag: 33435
  - 17
    - PHP How do I program in PHP using fp2002? Ho I just change htm to php? Thanks in Advance Tag: Post Data to a Access Database Tag: 33434
  - 18
    - makeing button change on mouse over I have buttons that act funny and are not consistant. When you mouse over it changes when you click it follows a link. but sometimes it doesnt show the picture you click it again then the picture comes back. click it a few more times and the picture isnt there reclick it or click another button and the picture comes back. radomly happens to any button function init() { if (!document.getElementById) return var imgOriginSrc; var imgTemp = new Array(); var imgarr = document.getElementsByTagName('img'); for (var i = 0; i < imgarr.length; i++) { if (imgarr[i].getAttribute('hsrc')) { imgTemp[i] = new Image(); imgTemp[i].src = imgarr[i].getAttribute('hsrc'); imgarr[i].onmouseover = function() { imgOriginSrc = this.getAttribute('src'); this.setAttribute('src',this.getAttribute ('hsrc')) } imgarr[i].onmouseout = function() { this.setAttribute('src',imgOriginSrc) } } } } onload=init; </script> <a href="index.htm"> <img border="0" src="webimage/button1.jpg" hsrc="webimage/button1a.jpg" align="left" width="120" height="28"></a><p> </p> <p> <a href="news.htm"> <img border="0" src="webimage/button2.jpg" hsrc="webimage/button2a.jpg" align="left" width="120" height="28"></a></p> <p> </p> <p> <a href="raceschedule.htm"> <img border="0" src="webimage/button3.jpg" hsrc="webimage/button3a.jpg" align="left" width="120" height="28"></a></p> <p> </p> <p> <a href="directions.htm"> <img border="0" src="webimage/button4.jpg" hsrc="webimage/button4a.jpg" align="left" width="120" height="28"></a></p> <p> </p> <p> <a href="joinwrcrw.htm"> <img border="0" src="webimage/button5.jpg" hsrc="webimage/button5a.jpg" align="left" width="120" height="28"></a></p> <p> </p> <p> >-----Original Message----- >What are some tricks for making your web site faster >. > Tag: Post Data to a Access Database Tag: 33433
  - 19
    - Deleting a File Path that goes Nowhere??? Ok, I'm as new as they come... installed FP2002 and instead of reading the book I purchased, I had to jump right in the fray. And a fight it's been ever since. I accidently created a page and have no idea how to delete it. I created several WRONG file paths and I don't know how to delete those either. So, as a matter of principle, I just thought I would uninstall FP and reinstall and thought they would go away. NOT. Could someone please help. I'm on a mission... so aggravated that I can't make these things go away??? Thanks for your time and consideration. After I solve this problem I intend to be more careful. Not a very forgiving program. I WILL read the book. Be safe and prosperous! Melody Tag: Post Data to a Access Database Tag: 33430
  - 20
    - Printing form From Web Site Hi, This is the closest newsgroup to the topic I am looking for so I hope someone can help with these TWO problems. My father-in law has asked if I could step into a pre-existing web site and make needed modifications since the business that was doing it did a very poor job. I am definitely an amateur with FrontPage but I do know some HTML and programming. Anyway PROBLEM 1 ------------------ When some of the forms are printed from the web site (just plain form, print, fill it out with pen, mail back, nothing fancy) it always prints 2 pages even though there is nothing on the second page. Plenty of space on the bottom of the page. Any suggestions? PROBLEM 2 ------------------ On one of the forms the text does not wrap as it should when the form is printed. This form prints one page but the text is truncated on the right side. It does not word wrap. I looked at the code, it was originally written with FrontPage 5. I have FrontPage 2002. I do not see any problem with the code. Could it be a setting on my computer? Any suggestions? Here is a code snip from one of the paragraphs that does not word-wrap: <p> <font size="3"><b>In accordance with the Board of Examiners of Electrical Contractors, the 10-hr. 2005 Code Update cannot be provided for until after January 1st, 2005, when the final edition of the new Code will be available for all contractors and inspectors.</b></font> </p> Thanks in advance L. Tag: Post Data to a Access Database Tag: 33428
  - 21
    - asp from relational access db I have this problem,creating an asp from access in frontpage table1(personel) ID CODE SURNAME 1 smi01 smith 2 abc02 abconal table2 (review) ID CODE REVEIWER 1 smi01 abco2 ***Query*** table1 table2 table1_1 CODE -------CODE SURNAME REVEIWER---CODE SURNAME SELECT reveiw.code, personel.surname, reveiw.reveiwer, personel_1.surname FROM personel INNER JOIN (reveiw INNER JOIN personel AS personel_1 ON reveiw.reveiwer = personel_1.code) ON personel.code = reveiw.code; query result desired CODE SURNAME REVEIWER SURNAME(of reviewer) smi01 smith abc02 abconal but I am getting CODE SURNAME REVEIWER-CODE SURNAME(of reviewer) smi01 abconal abc02 abconal as the surname field appears twice! Any help would be great Tag: Post Data to a Access Database Tag: 33425
  - 22
    - Launch and Edit button on the tool bar Trying to learn Frontpage. I have designed the template in Fireworks. Now I am trying to adapt it for FrontPage. I cannot seem to locate the Launch and Edit button. This is supposed to create a Fireworks image so it can be worked with in FrontPage. Tag: Post Data to a Access Database Tag: 33423
  - 23
    - Hyperlink to Access? Does it take a great deal of programming knowledge to create a hyperlink in a Front Page html file that transfers control to Access, so Access reports can be run? I don't have the programming knowhow to do the more complex code involved in integrating the two together, and the wizards in both programs (DRW/Data Access Pages) don't go far enough for what our company wants. Would this require a plug in? Thank you. Tag: Post Data to a Access Database Tag: 33419
  - 24
    - banner ad is there any way to make a banner ad manager in fp 2003? i remember i could in 2000, but i upgraded and now it seems i can't find this feature. Tag: Post Data to a Access Database Tag: 33418
  - 25
    - The Only Font is the Default Font That's exaggerating a bit, but other than a small selection of fonts, when I change the font on FrontPage 2002 into a new font, it automatically becomes the default font. The strange thing is that if I set the default font to one of these usually-undisplayed fonts, they display fine (of course, all others become that one default). If I preview it in the browser it looks fine, and the fonts are installed.... Tag: Post Data to a Access Database Tag: 33416
- Next
  - 1
    - can't publish anymore - FrontPage 2000 version 4 Hi there! I edit and re-publish my site every month. I never had any problem until today. When publishing, I get the following message: This FTP server doesn't support folder names that contain spaces. Rename the source web's folder corresponding to "microsoft frontpage" and any other folders that have spaces in their names and try again... I don't understand...which spaces? I've checked the folder and their is no name with spaces. Please help Thanks daniel Tag: Post Data to a Access Database Tag: 33414
  - 2
    - eliminating top margin on Netscape When I preview my page in Netscape, it always shows a top margin of about 15 pixels. This does not show up when I preview in IE with page option set to zero top margin. Does anyone know how to get rid of this top margin in Netscape? Thanks. Tag: Post Data to a Access Database Tag: 33413
  - 3
    - Hit counter Hello: I have mde my first web site with front page. after publishing it everything works fine except... the hit counter. the counter reads 1 all the time. it never advances and i have tried from logging on from several different ip addresses but it still never advances. the address to my space is an http address but the adress i was given to publish my page to is and ftp address. My ISP has a section where i needed to activate front page extensions and i have done that. they tell me it should work fine and the problem is on my end. can anyone shed some light on my problem? Thanx Luke Tag: Post Data to a Access Database Tag: 33411
  - 4
    - FREE WEB SERVER SERVICE? HI! IN ORDER TO PUBLISH A WEBSITE THROUGH FRONTPAGE, YOU NEED TO HAVE A WEB SERVER SERVICE AM I CORRECT? ANYWAY, ARE THERE ANY ABSOULTLY FREE SERVICES OUT THERE I CAN USE? THANKS! Tag: Post Data to a Access Database Tag: 33410
  - 5
    - Link bar icon When a user drags the web page address to their browsers links bar, it displays the title of the page and the Explorer icon. On some pages (as with http://www.bloomberg.com for example) the icon is specific. Anyone know how to make FrontPage 2002 do this ?? Thanks Tag: Post Data to a Access Database Tag: 33401
  - 6
    - E-mailing form results...Still%*@$ I'm still having problems with e-mailing my form results. Listed below are some entries from Otlk2003& FP Server Extensions: Front Page Server Extensions: Web Servers's e-mail address: craigwarmy@bendcable.com Contact address: craigwarmy@bendcable.com SMTP server: HOME Mail encoding: use default encoding Character set: use default encoding Outlook 2003 Internet E-mail Settings(POP3) Incoming Mail Server:pop-server.bendcable.com Outgoing mail server(SMTP):smtp-server.bendcable.com Are these entries correct? TIA --Craig Tag: Post Data to a Access Database Tag: 33400
  - 7
    - Hosing Server Hello, The company which hosts my website claims that my active server pages are hosing his server. I have had these pages for 4 years pretty much as they were written. I didn't write them but added criteria and changed the output format, but a while ago. I have had them on several servers and was never told of a problem This recenlt company has never reported a problem, but now claims they had to quarantine my site to protect the other site on the server. I have been having trouble that I know if since they upgraded from Win2000 to Win2003. There is no logic to the claim that my pages are the problem. It seems the problem must be with Win2003 or the configuration. Here is page that is run most frequently. It is run from a form on another ASP. I am hoping someone will look at it and see if there is a problem which can be identified to cause problems on the server. Thanks in advance. <% SortBy = Request.Form("SortBy") SortMess = "" If SortBy = "DateLoading" then SortOrder = "DateLoading, OriginState, OriginCity, DestinationState, DestinationCity " SortMess = "Sorted by Load Date/ Origin State/ Destination State" ElseIf SortBy = "OriginState" then SortOrder = "OriginState, OriginCity, DestinationState, DestinationCity, DateLoading" SortMess = "Sorted by Origin State/ Destination State/ Load Date" ElseIf SortBy = "DestinationState" then SortOrder = "DestinationState, DestinationCity, OriginState, OriginCity, DateLoading" SortMess = "Sorted by Destination State/ Origin State/ Load Date" End If Set rs = Server.CreateObject("ADODB.RecordSet") q = "SELECT LoadID, OriginCity, OriginState, DestinationCity, " &_ "DestinationState, DateLoading, TrailerLength, TrailerType, comments, Recurring FROM Loads WHERE (Recurring = False) AND (1=1)" dateavail = Request.Form("dateavail") if dateavail <> "" then if NOT IsDate(dateavail) then Session("mess") = "The date you entered for the Date Loading is not formatted properly. Please enter it again." Response.Redirect "searchloads.asp" else q = q & " AND (DateLoading = #" & dateavail & "#)" end if else q = q & " AND (DateLoading >= #" & date() & "#)" end if originstate = Request.Form("originstate") if originstate <> "" then q = q & " AND (OriginState LIKE '%" & originstate & "%')" end if destinationstate = Request.Form("destinationstate") if destinationstate <> "" then q = q & " AND (DestinationState LIKE '%" & destinationstate & "%')" end if trailertype = Request.Form("trailertype") q = q & " AND (TrailerType LIKE '%" & trailertype & "%')" q = q & " Order by " & SortOrder rs.Open q, "DSN=TruckLoadsDev;" %> <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <title>Search Loads - Matching Records</title> <meta name="Microsoft Border" content="tb"> </head> <body bgcolor="#FFFFFF" link="#000080" vlink="#800080" alink="#000080" background="../images/trucksbg3.jpg"> <table width="800" cellpadding="2" align="LEFT" valign="TOP"> <tr>  <td width="125" align="LEFT" valign="TOP"> </td>  <td align="LEFT" valign="TOP"><table border="0" width="100%"> <tr> <td width="100%" align="left"><font size="4"><strong>Search Loads - Matching Records</strong></font></td> </tr> </table> <p><%if NOT rs.EOF then%><b><font size="2" color="#800000">Records matching the parameters you specified are listed below. To see the details or contact the Company which owns the load, click on the Origin  for that load.</font></b></p> <p><a href="../asp/searchloads.asp"><strong>Search Again</strong></a></p> <div align="left"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="100%"><b><% Response.Write SortMess %></b></td> </tr> </table> </div> <table border="0" width="800"> <tr> <td width="155" valign="top" align="left" bgcolor="#9999FF"><strong><font size="2">Origin State,  City</font></strong></td> <td width="165" valign="top" align="left" bgcolor="#9999FF"><strong><font size="2"> Destination State, City</font></strong></td> <td width="128" valign="top" align="left" bgcolor="#9999FF"><strong><font size="2">Trailer Type</font></strong></td> <td width="78" valign="top" align="left" bgcolor="#9999FF"><strong><font size="2">Date Loading</font></strong></td> <td width="242" valign="top" align="left" bgcolor="#9999FF"><strong><font size="2">Comment</font></strong></td> </tr> <%while NOT rs.EOF Datel = "" Recur = "" if rs("Recurring") = False then DateL = rs("DateLoading") else Recur = "Recurring" End If if rs("TrailerLength") = 0 then tLength = "" else tlength = rs("TrailerLength") End If %> <tr> <td width="155" valign="top" align="left" bgcolor="#FFFFFF"><a target="_blank" href="loaddetails.asp?loadid=<%=rs("LoadID")%>"><font size="2"><%Response.Write rs("OriginState") & ", " & rs("OriginCity")%></font></a> </td> <td width="165" valign="top" align="left" bgcolor="#FFFFFF"><font size="2"><%=rs("DestinationState") & ", " & rs("DestinationCity")%></font> </td> <td width="128" valign="top" align="left" bgcolor="#FFFFFF"><font size="2"><%=tlength & " " & rs("TrailerType")%></font> </td> <td width="78" valign="top" align="left" bgcolor="#FFFFFF"><font size="2"><%=DateL%></font> </td> <td width="242" valign="top" align="left" bgcolor="#FFFFFF"><font size="2"><%=rs("Comments")%>            </font> </td> </tr> <tr> <% rs.MoveNext wend%> </tr> </table> <p><strong><a href="../asp/searchloads.asp">Search Again</a> <br> </strong></p> <p><%else%></p> <p><strong><font size="4"><font color="#FF0000">No Loads matched your query.</font>   <a href="../asp/searchloads.asp">Try again</a></font></strong></p> <p><%end if%> <p> </td> </tr> <tr> <td width="150" align="LEFT" valign="TOP"></td> <td align="LEFT" valign="TOP"><strong><a href="../TruckTrackingLog/Def_NoLinks.htm" target="_blank">Try our free Truck Tracking Program<br> (written for Microsoft access)</a></strong></td> </tr> </table> <p> <img src="http://www.stattrax.com/cgi/stattrax.cgi?account=3333&page=513" width="1" height="1"> </body> </html> Tag: Post Data to a Access Database Tag: 33396
  - 8
    - Database Locking up Hello, I have a Access Db on a website. I have a procedure of FTP'ing a database (clientDB.mdb) to the site then running an active server page to transfer the data to the main database (Truckloads.mdb). After the transfer I close the ftp program (wsFTP Pro v8.01). Next I run the ASP. A couple weeks ago the company which hosts my site, upgraded from Win2000 to Win2003. Immediately there were problems. The active server pages stopped working intermittantly. I discovered that there was an .ldb file ( Truckloads.ldb) in the Database directory which was causing the problem. The company said that they tracked the problem to coincide with the time I ran the ftp program and my asp. Since I transferred clientDB.ldb, I don't get the connection. Nothing changed on my website, but the server software changed, so logically, it would be something in Win2003 or the configuration that is the problem. Does that seem feasible? The company also claimed that my Active server pages were hosing his server. I don't know which pages, but here is the page I run to do the transfer. Is ther something in that which could cause memory problems? I only run it a half dozen times per day. I'll post other code in another thread. Thanks for any help. <%@ Language=VBScript %> <html> <head> <title></title> </head> <body>  <% Response.Write "Uploading data... <br>" Dim DSNConn, DSNClient Dim ServerConn, ServerRst, ClientConn, ClientRst Dim vSQL, ConnErr, fld, fldname DSNConn = "DSN=TruckloadsDev" DSNClient = "DSN=Clientdb" Set ServerConn = server.CreateObject("ADODB.Connection") ServerConn.Open DSNConn Set ClientConn = server.CreateObject("ADODB.Connection") ClientConn.Open DSNClient ServerConn.BeginTrans If UploadTrucks = True then if UploadLoads = true then Response.Write "<br><br>All OK!" ServerConn.CommitTrans%> <form action=ViewData.asp method=post> <input type=submit value="View Revised Data"> </form> <%else Response.Write "<br><br>Due to errors, no uploading has occurred." ServerConn.RollbackTrans end if else Response.Write "<br><br>Due to errors, no uploading has occurred." ServerConn.RollbackTrans end if set ClientRst = nothing set ClientConn = nothing set ServerRst = nothing set ServerConn = nothing %> <p> </p> <% function UploadLoads on error resume next Response.Write "<br> Uploading Loads..." Set ServerRst = server.CreateObject("ADODB.Recordset") Set ClientRst = server.CreateObject("ADODB.Recordset") Set ClientRst = ClientConn.Execute("Select * from LOADS") If ClientConn.Errors.Count = 0 then 'there is a Loads table and it's now open 'Open Loads table on server database vSQL = "Select * from LOADS Where 1=0" ServerRst.Open vSQL, ServerConn, adOpenKeyset, adLockBatchOptimistic, adCmdText If ServerConn.Errors.Count = 0 then'success do until ClientRst.Eof 'loop through records on client db ServerRst.addnew for each fld in Clientrst.Fields 'loop through fields fldname = fld.name if fldname = "ID" or fldname = "posted" or fldname = "archive" or fldname = "delete" then 'do nothing Else serverrst(fldname) = clientrst(fldname) end if next serverrst("Uploaded")=Now() 'ServerRst.addnew arFields, arValues ClientRst.movenext loop ServerRst.UpdateBatch if err.number = 0 then Response.Write "<br>Loads successfully updated!" UploadLoads = True else Response.Write "<br>Error uploading 'Load' information: <br>" & err.number & ", " & err.description UploadLoads = False end if Else 'error opening Loads in Server db Response.write "<br>Error(s) in server database:" for each ConnErr in ServerConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; <br>" next UploadLoads = False end if else 'error opening Loads table in client db if ClientConn.Errors(1).Number = -2147217865 then 'table isn't there Response.Write "<br>No 'Loads' records to upload.<br>" UploadLoads = True else 'Some other error Response.write "<br>Error(s) in client database:" for each ConnErr in ClientConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; <br>" next UploadLoads = False end if end if ServerRst.Close set ServerRst = nothing ClientRst.close set ClientRst = nothing end function function UploadTrucks on error resume next dim i i=0 Response.Write "<br><br> Uploading Trucks..." Set ServerRst = server.CreateObject("ADODB.Recordset") Set ClientRst = server.CreateObject("ADODB.Recordset") Set ClientRst = ClientConn.Execute("Select * from TRUCKS") If ClientConn.Errors.Count = 0 then 'there is a Trucks table and it's now open 'Open Trucks table on server database; return no records to improve speed vSQL = "Select * from Trucks where 1=0" ServerRst.Open vSQL, ServerConn, adOpenKeyset, adLockBatchOptimistic, adCmdText If ServerConn.Errors.Count = 0 then'success do until ClientRst.Eof 'loop through records on client db ServerRst.addnew for each fld in Clientrst.Fields 'loop through fields fldname = fld.name if fldname = "ID" or fldname = "posted" or fldname = "archive" or fldname = "delete" then 'do nothing Else serverrst(fldname) = clientrst(fldname) end if next Serverrst("Uploaded")=Now() 'ServerRst.addnew arFields, arValues ClientRst.movenext loop ServerRst.UpdateBatch if err.number = 0 then UploadTrucks = True Response.Write "<br>Trucks successfully updated!" else Response.write "<br>Error uploading 'Truck' information: <br>" & err.number & ", " & err.description UploadTrucks = False end if Else 'error opening Loads in Server db Response.write "<br>Error(s) in server database:" for each ConnErr in ServerConn.Errors Response.write = UploadTrucks & ConnErr.Number & ", " & ConnErr.Description & "; <br>" next UploadTrucks = False end if else 'error opening Loads table in client db if ClientConn.Errors(1).Number = -2147217865 then 'table isn't there Response.Write "<br>No 'Trucks' records to upload.<br>" UploadTrucks=True else 'Some other error Response.write "<br>Error(s) in client database:" for each ConnErr in ClientConn.Errors Response.write ConnErr.Number & ", " & ConnErr.Description & "; <br>" next UploadTrucks = False end if end if ServerRst.Close set ServerRst = nothing ClientRst.close set ClientRst = nothing end function%> </body> </html> Tag: Post Data to a Access Database Tag: 33395
  - 9
    - Cannot view XML input using XSL style sheet. I'm trying to write an ASP page using XML. When I pull the page up in the browser I get the following: Cannot view XML input using XSL style sheet. How do I fix this? Tag: Post Data to a Access Database Tag: 33393
  - 10
    - preview In preview mode and in preview in browser I can see the dynamic html and page transitions, but I can't see them on the actual site on the net. Any reason why? is this a hosting issue? (using Tripod free)use to work before. thanks Tag: Post Data to a Access Database Tag: 33392
  - 11
    - Knotty problem ? Hello, Wonder whether you could help with this. I have .asp pages in FrontPage linked to an Access database. In the form reflecting the database contents, I have a field called Course Code, for example the value 100. I define a hyperlink on this field towards a Subscription Form that contains a "submit form", i.e. creates a new record in the database. The idea is that when the user clicks on Course Code of the original form, he is redirected to the Inscription Form which automatically displays - in the Course Code field - the course code, in this example : 100. This to avoid that the user will have to retype the Course Code in the Inscription Form. Can this be done without complex programming ? Thanks a lot for your help. Doris, Geneva, Switzerland Tag: Post Data to a Access Database Tag: 33382
  - 12
    - tables Tables or Layout Tables: What is the difference and which one should I use. Thanks Lisa Tag: Post Data to a Access Database Tag: 33381
  - 13
    - Why is the navigation link bar button blank in FP 2003 for the current page I am viewing? Are there a lot of problems with FrontPage 2003 navigation link bar? Often some buttons don't have images or the home page button is missing... Currently, I publish my website like this: Safest procedure that I know (am new though). 1. Save files that are to be included elsewhere 2. Save each .dwt file and propagate the changes. 3. Publish the entire web, overwriting all files, (not just changed ones) Problem: Why does the page I am viewing on a published site either local file system or web server have the current page navigation button blank, i.e. without the button image? I have recreated the nav bar but still have the same problem. Tag: Post Data to a Access Database Tag: 33380
  - 14
    - Problems publishing Frontpage My system crashed and I lost all the source to my website. I then purchased a new PC and recreated the website from scratch. It's not exactly the same, but it's close enough. When I attempt to publish it, it tells me that it cannot rename the folder. Any ideas? Tag: Post Data to a Access Database Tag: 33379
  - 15
    - attaching a dynamic web template to a dynamic web template How do I with dynamic web templates (dwt) have a footer and header on each page in my site AND use other more complex dwt's in my website that have this same footer and header. Don't I have to attach a dwt to a dwt? Tag: Post Data to a Access Database Tag: 33372
  - 16
    - Setting Home Page Link Am creating a web page & want a link on the page to click on to set my page as a Home Page for the viewer. How is this done? Thanks in advance Tag: Post Data to a Access Database Tag: 33370
  - 17
    - How to delete hidden webs? HI, I downloaded a template for front page and somehow it got corrupt in FP2000 program. I have tried deleting the web so I can import it again but but it keeps showing up corrupt in the front page program. How can I can get inot the hidden directorys so I can completely remove this web from my computer so I can strat from scratch again. I paid $90 for this template and would really hate to throw my money out the window. thanks. I'm using FP 2000 Windows 98 512 mb ram Tag: Post Data to a Access Database Tag: 33359
  - 18
    - Page sizes viewed on different monitors Hi I have done 2 websites at home on a 15" monitor. They work and look fine. But once loaded to the net, anyone who views them with a 17" screen gets a blank inch either side of the page. Does anyone know how I can fix this problem? Thanks, I would appreciate some help. Susie Tag: Post Data to a Access Database Tag: 33345
  - 19
    - right click script How do I add sound to a right click script insted of a message. Here what I have for a script it dont let you copy or save as. The message thanks for looking apears. I would like NOT to have a message just a sound something I can record my self. <script LANGUAGE="JavaScript"> function click(){ if (event.button==2){ alert('THANKS FOR LOOKING!'); } } document.onmousedown=click // --> </script> Tag: Post Data to a Access Database Tag: 33344
  - 20
    - Web Site Speed What are some tricks for making your web site faster Tag: Post Data to a Access Database Tag: 33343
  - 21
    - Windows Media not working in Frontpage My media files are not accesssable in the FP2002 program. I can't edit or add any components to the media player in FP.As a matter of fact I recall there was a download availabe to enable the player for use in the FP program. Does anyone know what i need to do? Tag: Post Data to a Access Database Tag: 33342
  - 22
    - Media Player and FrontPage 2002 I had incorporated the Windows Media Player into some of my pages some time ago, but now I am unable to edit the files. I cannot add any new media files to my Frontpage 2002 files. Running XP Home, Office 2002 Pro. What could be the problem. RE-installing the program didn't help. HELP!!!! Tag: Post Data to a Access Database Tag: 33340
  - 23
    - Problems e-mailing form results Iam running FP2000 on Windows Professional. I am trying to e-mail my form results to a specified e-mail address(my own). I am running the app from my local server (http://home/webpage). Is there something outside of FP that needs to be changed so that the e-mail starts to work? In IIS? Tag: Post Data to a Access Database Tag: 33339
  - 24
    - Presentations with Frontpage Does anyone know how to turn a file of frontpage-created html files into a presentation? What I really need is an "auto run" function, so that when the client inserts the disk, the specified page of the presentation just pops open. Tag: Post Data to a Access Database Tag: 33338
  - 25
    - Modify default HTML template Hi there, I dropped my web programming back in 2001 and as such haven't done much since then but I'm getting back into it know. As such, a lot has changed with xhtml, xml, asp, php etc... I'm going to start using Frontpage to organize my site layout and do hyperlink testing but here's my question. I don't like the default HTML that Frontpage creates when you make a new page. It makes: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> but I want to switch out/add some additional tags to make my template: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <link rel="stylesheet" type="text/css" href="FILE NAME GOES HERE" /> <title>Index Page</title> </head> Is there anywhere in Frontpage where I can modify the template? Another quick question as well, is the code that Frontpage generates either HTML 4.01 or XHTML 1.1 strict (as in it follows W3C guidelines)? Thanks. -Duncan Tag: Post Data to a Access Database Tag: 33333

Using FrontPage 2003 and Access 2003 I can view data and
scroll. But how can I edit and/or add additional records
to the database via the web? Is there a template for
FrontPage? Access?

Top

RE: Post Data to a Access Database by harikumh

harikumh
Fri Feb 20 14:54:22 CST 2004

Hi Tom,

You can use the Database Interface Wizard for creating submission page,
results page and database editor page. The following links might be useful
in crated a Database Interface wizard.

http://office.microsoft.com/search/results.aspx?Scope=TC%2CHP%2CHA%2CRC%2CFX
%2CES%2CEP%2CDC%2CXT&Query=database+interface+wizard&CTT=6&Origin=EC01033112
1033

Hope this helps

regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no rights

Top