Possible to access a MS Access Report via ASP

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
    - Debugging FrontPage add-in under VB help needed! Hi! I develop a FrontPage add-in in Visual Basic 6.0 (under Windows 2000 Pro.). Is anyone who can tell me how can I debug it? Thank you in advance! Cornel Gligan-Ignatescu Tag: Possible to access a MS Access Report via ASP Tag: 39160
  - 2
    - Refresh the page once right after log on to a site Hello, does anyone know if there is a way to that. I have already tried <meta http-equiv="pragma" content="no- cache"> .. but it is not working .. I check the Temp Internet folders .. files are still in the folder. Please advise Tag: Possible to access a MS Access Report via ASP Tag: 39155
  - 3
    - Lost Seach functions?? Hello, Upgraded to Windows Server2003 and IIS6.0. Now I don't have the ability to use the search on my web site? Any Ideas? Brian Tag: Possible to access a MS Access Report via ASP Tag: 39154
  - 4
    - FP '02 CGI & PHP3 extension? Hello, My webpages now clone themselves! I edited the "index.html" page only to find another page, same name, with .cgi extension, then another, same name, with .php3 extension. Why is this happening suddenly? Sometimes I edit online, sometimes, offline, is that the problem? Tag: Possible to access a MS Access Report via ASP Tag: 39152
  - 5
    - FP-No Sound No Animate Hello, I am new to this group. My FP 2002 suddenly will not let any .gif files animate either before in Preview mode or after published. Also, under FILE, PROPERTIES, GENERAL tab, Sound is not highlighted and I have had to add sound thru html. Can anyone help? Thanx. Tag: Possible to access a MS Access Report via ASP Tag: 39151
  - 6
    - link bar properties Using FP 2002. I had my web site set up with link bars on the bottom of most pages. They were working just fine. However, they appear to have "disappeared"...meaning that now they show up as "[Edit the properties for this link bar to display hyperlinks here]" When I try to do this or just erase & do the insert link it keeps coming back to the same thing (edit the properties, etc) When I look at my navigation screen, my pages are all connected....I supposed I can mannually add links, but I'd rather understand what's going on & fix it so that I don't have to mannually change all my individual links everytime I change or add a page....Help.... Thanks! Tag: Possible to access a MS Access Report via ASP Tag: 39150
  - 7
    - Navigation?? Hello, what navigation will do for me?? Cuz I have my site up and everything w/o navigation setup. Does it do me any goods?? Tag: Possible to access a MS Access Report via ASP Tag: 39146
  - 8
    - Link Bar Display Name Problems I've added a new link (Other Service) to my linkbar and can't seem to the correct dispaly name after publishing to my server. I get Service 4 instead. http://www.diningdivine.com/otherserv04.ht I've changed the display name, the title, it says Other Services from the navigation view. Any suggestions Tag: Possible to access a MS Access Report via ASP Tag: 39144
  - 9
    - ImageReady tutorials Can anyone point me to some tutorials for doing rollovers in Imageready 7. The online help stinks and the process is not very intuitive. Thanks. -- Peter Aitken Remove the crap from my email address before using. Tag: Possible to access a MS Access Report via ASP Tag: 39140
  - 10
    - Multiple <body> tags in html Can anyone tell me why FP2002 would be adding multiple <body> tags to my html. The theme that was applied to this website was from pre-FP2000. Any suggestions? Tag: Possible to access a MS Access Report via ASP Tag: 39139
  - 11
    - Missing Page titles Exactly the same thing has happened to me it is driving me nuts. I am using FrontPage 2000 and have a well functioning sit (www.pinstripinguk.com) which has been operating perfectly for a year. I add new pages regularly yet this last week when I add paged to the navigation the content publishes fine and it looks great in preview but the titles do not appear I get the same graphic red X box as mentioned below and no one I know - knows what has caused this and how to fix it the site is using 17Mb and is hosts say there is not a problem at their end !!! Any pointers would be greatly appreciated. I also include Paypal in my website and it functions great. Lynda Tag: Possible to access a MS Access Report via ASP Tag: 39138
  - 12
    - Missing Data Hi, I am updating a web site for a client and am new to Frontpage. The files were originally created using Frontpage version 4. I am using Frontpage version 5. I am using FTP_Pro to download and upload the files. I am also running win XP. When I updated the file, (I was just changing an e-mail address), the new version of the file lost some of its content. The file dropped in size from 14K to 9K. Also the locations which contained pictures before only had a red x in the corner. I seems that the page had lost the link to where the pictures were located. Any ideas on how to overcome this problem. Any hints/suggestions appreciated. Thanks, Sam Tag: Possible to access a MS Access Report via ASP Tag: 39137
  - 13
    - How to post form to next page Page 1 has an input form field with action sending it to Page 2 Page 2 is a frameset with header and main page There is a database results in the Page 2 header frame that needs the Page 1 Form info to do its lookup. Sending to the frames page doesn't get it to the header page does it? I've already been told elsewhere I need to put something in the Page 2 frameset page to send the Page 1 info to the header page or use a javascript to send it to both. I'm really confused.... I have no clue how to do either of these - can someone provide it in detail, 'cause I'm new to this kind of thing and my boss is getting anxious. Thanks Tag: Possible to access a MS Access Report via ASP Tag: 39131
  - 14
    - Passing AutoNumber to another form I am developing a survey using Front page 2003 and SQL server 2000. The first form i collect the client data and upload into a client table. In the second form i collect info. on a set of questions and upload into a response table. In the client table i generate a Autonumber. Now i am trying to get this clientID, and trying to update it to my response table along with responses - and i am stuck. Can you please suggest how to fix this problem. Tag: Possible to access a MS Access Report via ASP Tag: 39128
  - 15
    - An error occurred accessing your Front Page web files. This is the error message I have begun receiving the last few days. I have two websites on my hard drive, they are hosted by two different servers. I get this message on both sites when I try to save new files. I have not tried to publish changes as I don't want to further the problem. Any help would be appreciated. An error occurred accessing your Front Page web files. Authors - if authoring against a web server, please contact the webmaster for this server's site. WebMasters - please see the server's system log for more details. Tag: Possible to access a MS Access Report via ASP Tag: 39122
  - 16
    - ASP - Cannot insert form result to Access DB more than one records Hi: I am trying to come up an ASP page for processing form input and to send form results to an Access database and an email. I have been stuck to the following procedures and simply don't know how to correct it, so kindly review it and give me some advises. ---------- These are some SQL strings to be carried out ---------------- mySQL= "INSERT INTO tb1Users (UID) VALUES ('" & Request.Form("UserName") & "')" mySQL= "INSERT INTO tb1Users (PWD) VALUES ('" & Request.Form("Password") & "')" mySQL= "INSERT INTO tb1Users (ConfirmPWD) VALUES ('" & Request.Form("ConfirmPassword") & "')" ----------------- These are execution and closing connection ------------------------- myConnection.Execute mySQL myConnection.Close Set myConnection = Nothing ---------------------------------------------------------------------------- --------------------- Note: tb1Users = table name. UID = Access DB field name, UserName = Form Field Name At first, I experienced the execution cannot be done by myConnection.Execute my SQL. Now it can be carried out but when I examined the database file, only the first mySQL record will be inserted. For example: If I only listed the first for UID, then the UserName can be inserted. If I listed both UID and PWD, only the last one which in this case is the "password" will be inserted. Can anyone please tell me where seems to be the problem. PS: I also tried the following string statements which will not work at all: (1) INSERT INTO tb1Users (UID, PWD,...) VALUES ('UserName','Password"..) Many thanks in advance!!! Tag: Possible to access a MS Access Report via ASP Tag: 39121
  - 17
    - Publishing I've got an intranet to be set up at work I've heard that you can only use forms if you publish to a server running 'frontpage server extensions', AND you must publish using http The problem is, when I publish to the server it uses ftp. So the forms won't work - BUT I NEED THE FORMS TO WORK " This is very confusing to me " How do i publish it to my server using http Please Hel Simon Tag: Possible to access a MS Access Report via ASP Tag: 39117
  - 18
    - Calendar Hi Y'all I've used the AcitveX components in frontpage to make the calendar But when i've published it it never shows the right date. It keeps saying 24/05/0 Anyone know how to make it show the right date? Tag: Possible to access a MS Access Report via ASP Tag: 39112
  - 19
    - Rollover Photo FrontPage 2003 Placed a rollover photo on Home Page. When I go to our site using my computer, the rollover functions as designed. When I enter web site from another computer, the Photo fails to display and rollover fails. Tag: Possible to access a MS Access Report via ASP Tag: 39107
  - 20
    - how to g3et server to recognize default page created a web gallery in adobe photoshop, which named the file index.html i imported that page into frontpage (2000) and created a home page called home.html when i upload to a server, how do i make sure that the home.html is the default page rather than the index.html being the default page. Tag: Possible to access a MS Access Report via ASP Tag: 39105
  - 21
    - hyperlinks How can I include "Back" hyperlinks in all my pages without taking away the settings I already have? Can I put them at the bottom of every page and not interfere with the hyperlinks I have at the sides and across the bottom of my pages? Tag: Possible to access a MS Access Report via ASP Tag: 39103
  - 22
    - Redirecting urls I have tried to modify the .htaccess file to do a 301 redirect on several of the urls which we have changed on our site. Everything works great except now my FrontPage forms don't work. Is there any way to do url redirects without affecting Front Page and without having to resort to a Meta refresh? Tag: Possible to access a MS Access Report via ASP Tag: 39101
  - 23
    - Interactive Buttons not previewing correctly HELP Hi everyone, I am trying to set up an Intranet site and I am using FP2003. I am using the Interactive Buttons for navigation. I have set up the site using Dynamic Web Templates with Editable regions for easy editing. The problem is that on most of the computers in the office the site looks great when opening in IE6. Everything is formatted properly and the structure is the same for all pages. However, on some of the servers when I bring up the page in my IE6 browser the interactive buttons spread out across the page throwing the all the pages off. What can I do to fix this? I tried putting the buttons in a table and it still stretches the buttons across the page. Any ideas on how to fix? Thanks, Nancy Tag: Possible to access a MS Access Report via ASP Tag: 39100
  - 24
    - turning FP homepage into "index.html" My service provider wants that extra l...index.html rather than index.htm. I tried to get FP to see things my way by changing the name in the "Web site" folder, but index.htm would not comply. After I closed the site (the C: drive version) I forced the ".html" renaming in Windows Explorer, and that worked. However, when I brought the index.html file up in FP it created a new file called index.htm. Anything you can tell me, thanks! Tag: Possible to access a MS Access Report via ASP Tag: 39095
  - 25
    - Newbie needs troubleshooting help. Our intranet is on a Windows NT4.0 Server with IIS 4.0 and all the latest service packs. Our clients are Windows XP with all the latest service packs. We have a basic page created in FrontPage 2000 that has several links to Excel spreadsheets. When the user selects the link it opens the Excel spreadsheet inside IE 6. Everything to this point works fine. When the user is finished making changes to the spreadsheet, the user selects File-.Save As and a prompt comes up asking for the username and password. The heading on the box that comes up says 'Connecting to MM5' MM5 being the Servername. We never had to enter a username and password before. What is weird about the whole thing is that the same user logged into a different pc will not get prompted for a user name and password. The problem shows up on random pc's but once it shows up you must enter the username and password of someone with full rights to the area where the .xls is located every time. I have tried clearing all of the cookies ,deleting all off line content and setting all of the IE security settings as low as they go. I have no idea where to go from here. Any suggestions would be greatly appreciated. Steve Tag: Possible to access a MS Access Report via ASP Tag: 39091
- Next
  - 1
    - client input I have created a site for a car dealer who features classic and specialty cars and wants to be able to input pictures and text info about the cars. Adding new cars and deleting those that have sold. Can this be done using forms. I can't seem to find info specific to this. Maybe a tutorial somewhere. I am using fp2003. Thanks Edward Tag: Possible to access a MS Access Report via ASP Tag: 39088
  - 2
    - ASP Pages in frontpage Hi everyone, I have a few asp pages which include other ASP pages within them. When I open the main ASP page in Frontpage 2003, I do not see the included ASP file's contents in the design view. Please help me resolve this issue so that I can see the page as I would see it in a browser (including the contents of the included ASP file). -- Paras Wadehra You One Stop Entertainment Guide - http://www.paras.2ya.com/ Tag: Possible to access a MS Access Report via ASP Tag: 39086
  - 3
    - Messenger ? Is there a way that you can put a discusion board on your site, Like this one, but in real time (yahoo! messenger type).? If So, can you have it to save all what is sent so you can keep an eye on what is said ? Tag: Possible to access a MS Access Report via ASP Tag: 39080
  - 4
    - Frontpage I'm Designing an Intranet for work. I wanted to add an interactive phonebook to one of the pages. The way I wanted it to work is this : You select the branch from a list in a drop down box. Then you select the employee in another drop down box( the employee names will depend on the results from the first drop down box). Then a list with all the employee details is shown below. Could someone please please please help me with this. I don't know where to start. Thanks Simon Tag: Possible to access a MS Access Report via ASP Tag: 39066
  - 5
    - Why am I getting the message "Class fphover ot found" when I view my web site? It is in the HTML codes? Tag: Possible to access a MS Access Report via ASP Tag: 39064
  - 6
    - Navigation bar button not behaiving! FP 2003, Have a set of left-side navigation buttons and a set of bottom navigation buttons. Each have been assigned the same characteristics that simply switch to different pages on my site. http://www.russpittman.com The home button on the left side bar does not function. It does in Front Page, but when published, will not allow selection. The home button on the bottom of the page works properly. Anyone with an idea or solution? Thanks, R Tag: Possible to access a MS Access Report via ASP Tag: 39063
  - 7
    - Find and Replace I have a bit of text in hundreds of locations on my web. I need to replace it with different text. I can use the find and replace cammand and easily find all the locations for the text. Is there anyway I can replace them all without setting all day clicking "replace all" and then "next document" I've got better things to do with my time. Tag: Possible to access a MS Access Report via ASP Tag: 39062
  - 8
    - Data extraction from HTML source using C++ Anybody knows about C++ sources to extract raw text data from (X)HTML and XML source pages? Aby relevant info is greatly appreciated. Tag: Possible to access a MS Access Report via ASP Tag: 39057
  - 9
    - Disk based web question I am getting ready to make a disk based web site. It is going to be very simple. Question and answers form. then at end of questions and answers I want it to print the results. Now heres my question. I have worked with Forms before in fact I have several web based forms that email the gathered information. What can any of you reccomend as to how I transfer the information input to a printiable form. Is there some easy way of doing this? NONE of the information is going to be stored beyond the print except the hard print copy. I don't need a data base. this is just going to be point and click answers - Print results. Any help welcomed. Thanks in advance. PS. Maybe some of you may know a script I can down load for a small fee or for free. PHP or something, and can post the link. Tag: Possible to access a MS Access Report via ASP Tag: 39053
  - 10
    - not able to update website I have a website that I created in FrontPage 2003. For some reason it won't let me update the left handed side only. I can update the main page portion, but any changes I make on the left stay unchanged after I publish. Any Ideas? Tag: Possible to access a MS Access Report via ASP Tag: 39048
  - 11
    - Hyperlink target to new window from shared borders within a theme I'm trying to insert a hyperlink in a shared border/theme with navigation that will open a new window. The theme seems to overide the hyperlink target frame. This is for a link that is off site and I want to enusre the user stays on my site until they chose to leave Any ideas/suggestions Thanks Miks Tag: Possible to access a MS Access Report via ASP Tag: 39046
  - 12
    - Linking to a secure page This is the first time I have ever run across the. I'm using FP98. The code look OK, and it works perfecting in preview. After I have moved the file to my staging server, you click on the link to the https site, and a new window opens properly, but everytime I receive a "page can not be displayed" error. If I refresh the browser window to the secure site , it works perfectly. I'm guessing that i'm missinga setting in FP or something in the code Help Tag: Possible to access a MS Access Report via ASP Tag: 39045
  - 13
    - Displaying fonts properly How do I get my website (FP 2002) fonts to display properly on computers which the font is not installed? I tried MS WEFT but can't seem to get it to work. Is there a way to have the font download as page loads? Thanks in advance, Mark Tag: Possible to access a MS Access Report via ASP Tag: 39037
  - 14
    - how to use FP Counter I'm confused how to use the Counter included with FP2k. Every time the page comes up it shows [Hit Counter] What do I do to show the counter ? thanx Jeff Tag: Possible to access a MS Access Report via ASP Tag: 39032
  - 15
    - Missing html in browser but present in Frontpage Viewed on some but not all computers, one of my hyperlinks is missing and is also missing from html with "view source" see e.g. at www.canaanchildrenshome.org which is missing the following <td width="19%"> <p><a href="sponsor.htm"><img border="0" src="images/sponsor_a_child2.gif" width="154" height="39"></a> </p> </td> Why is this happening? What can I do to fix? Thanks Tag: Possible to access a MS Access Report via ASP Tag: 39031
  - 16
    - PLEASE HELP - assistance needed for making expandible links I am working on a website for my office - stricly for internal inventory-type purposes. I have weekly Excel Spreadsheets which I incorporate to pages in FrontPage which are already set up to use. However, the 'index' page where these items can be clicked needs some work. I've been instructed to make each link, which expands to show all the weeks in each month and their respective inventory counts, expandible/collapsible or however it should be phrased. Basically I need the link to open to sublinks upon being clicked. I may not be explaining this perfectly, but if my request is clear to anyone who's performed this action before, your assistance will be greatly appreciated. Thanks in advance - and by the way, this looks like a great group! AMH Tag: Possible to access a MS Access Report via ASP Tag: 39028
  - 17
    - Is Buffering Video Doable? I have added a plug-in for viewing an .AVI file and would like to know how I can buffer the playback for the user. The file is about 7 megs and it takes a while even on a fast connection for it to start playing. Is this doable? Thanks Tag: Possible to access a MS Access Report via ASP Tag: 39024
  - 18
    - Absolute Table Position Hello - is there a way to position a table so that it is always in the middle of a page (vertically), no matter what size resolution or browser you use? Thanks Tag: Possible to access a MS Access Report via ASP Tag: 39019
  - 19
    - There is no catalog - message. Tried 183731 After following KB 183731 I still get: There is no catalog. The url listed is: http://www.mydomain.com/_vti_script/disc1_srch.htm0.idq I even tried deleting disc1_srch.htm0.iqd. It gave an error that that file was missing. The index service is running and I can see in the snap-in that pages are being indexed. Do I need to start from scratch? How can I fix this? Thanks, Mike Tag: Possible to access a MS Access Report via ASP Tag: 39018
  - 20
    - Email relaying Hello, I am wondering if this can be done with FP I have posted it before and received a ambiguous answer but it was also not directly posted so here goes. I have a total at this time 5 web sites and I have two servers, one is a few miles away. I want to off-load 3 of these sites to that server (which I have no problem publishing to) The problem that I face is the mail server is Here with me and I cannot get the forms to work over there. (Email that is) I have no problem letting the IP through on my end but how do tell FP to do this or FPSE for that matter? Can I set the server a few miles away to relay or Use my mail server with FP ? Has anyone tried this? I am doing it because of resource depletion over here with me and a very large site launch in September. Thanks very much Joe Tag: Possible to access a MS Access Report via ASP Tag: 39015
  - 21
    - how do i do so that one click open 2 pages in to frames? how do i do so that one click open 2 pages in to frames? Tag: Possible to access a MS Access Report via ASP Tag: 39005
  - 22
    - Discussion Thread. Replies to Discussions appear under the original thead on the Content page. But the previous original or reply does not appear below in the next reply. I would like it to operate like this newsgroup. The entire discussion appearing below the reply. How can I do that? Thanks, Mike Tag: Possible to access a MS Access Report via ASP Tag: 38999
  - 23
    - Link with input attached ? Hello I'm new here and I have a thorny problem (for me anyway!) I need to have a link from a web page to another page on the same intranet. The problem is that the target page needs some input to give the required info back to the user. So I need something like : link to page skip three input fields use input from original page (text input) to call further info from target page (database) I have no idea where to look for guidance or what such a procedure might be called. Any advice or 'pointing me in the right direction' would be greatly appreciated :~) TIA Jenny Tag: Possible to access a MS Access Report via ASP Tag: 38990
  - 24
    - css not showing in preview I am trying to add a backgroung image top left, non- tiling. It's showing in Normal page view (I was so delighted!), but not in preview or browser - help. I'm typing in BODY section <style type="text/css"> body { background: url(GWBGyell.JPG)no-repeat; background-position: top left; } </style> Thanks in advance, Rowena. Tag: Possible to access a MS Access Report via ASP Tag: 38984
  - 25
    - multiplyng link-bars I've volunteered to make some minor changes to a FP 2000 published website. I have FP 2002 on my development machine. I was able to open the website with file/open and publish it back to my machine. I am not able to file/open web the website on the internet. Therefore, I do not have the theme: pvwood111. Is pvwood111 an older MS theme or someone's custom theme? Any recommendations other than contacting the original website author? It is not copyrighted. One more item: Each time I open some of the pages on my machine, the link bars are copied and left on the page. If I open and close the page 4 times, I'll have 4 sets of the same link bar. One is sufficient! Any ideas here also? Thanks, Crow Tag: Possible to access a MS Access Report via ASP Tag: 38973

Hi,
I'm hoping that there is a way to access a MS Access Report using ASP.
I have created several reports in MS Access and I would like them to be
available for our end users to use. My MS Access book indicates that it's
possible, but doesn't give any details on how to do it.

Can anyone collaborate that this is indeed possible? And if so, point
me in the right direction?

TIA
RC-

Re: Possible to access a MS Access Report via ASP by Tom

Tom
Thu May 27 23:56:27 CDT 2004

Check out....

http://www.4guysfromrolla.com/webtech/042600-1.shtml

for an article on what you want.

Best to you.....
Tom Gahagan

"RC-" <r_candee@hotmail.com> wrote in message
news:e%23AJahMREHA.3016@tk2msftngp13.phx.gbl...
> Hi,
> I'm hoping that there is a way to access a MS Access Report using ASP.
> I have created several reports in MS Access and I would like them to be
> available for our end users to use. My MS Access book indicates that it's
> possible, but doesn't give any details on how to do it.
>
> Can anyone collaborate that this is indeed possible? And if so, point
> me in the right direction?
>
> TIA
> RC-
>
>

Re: Possible to access a MS Access Report via ASP by RC-

RC-
Fri May 28 12:06:12 CDT 2004

Thank you Tom!

RC-

"Tom Gahagan" <tgahagan@eThomaston.com> wrote in message
news:ejbMbGNREHA.3988@tk2msftngp13.phx.gbl...
> Check out....
>
> http://www.4guysfromrolla.com/webtech/042600-1.shtml
>
> for an article on what you want.
>
> Best to you.....
> Tom Gahagan
>
> "RC-" <r_candee@hotmail.com> wrote in message
> news:e%23AJahMREHA.3016@tk2msftngp13.phx.gbl...
> > Hi,
> > I'm hoping that there is a way to access a MS Access Report using
ASP.
> > I have created several reports in MS Access and I would like them to be
> > available for our end users to use. My MS Access book indicates that
it's
> > possible, but doesn't give any details on how to do it.
> >
> > Can anyone collaborate that this is indeed possible? And if so,
point
> > me in the right direction?
> >
> > TIA
> > RC-
> >
> >
>
>