Discussion Locked

Linking ASP page from Access to Intranet

0 helpful
11 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Access Database using Intranet
What I have:
Win2kServer with IIS5.0
Access 2000 with one database.
ASP page that updates the database

What I need:
I need to know how to link the database to the IIS 50

Okay, so thats the basic info. Here is an detail description of what I've done, and what I can't seem to do.

I have an Access database called testing.mdb. Testing.mdb has 3 Tables called Table 1, Table 2, and Table 3. I have a Form that updates the Table 2. Everything worksfine when updating the Table 2 from the local machine, but I would like to have it an Intranet Application. So, using Access, I exported the form called "update Table 2" to an ASP page.

Now if I just open that ASP page from my local machine, it works fine. But I'm having trouble using it from the intranet site. I know I need to link it somehow, but most of my research left me more confused, loss of hair, and upto 2 packs of smokes a day.

What I need is someone to who has done this before so I can quickly get this site going. Its just my pet project, but after spending 2 months learning Access and comming close to what I intened to do, I'm just plain out of energy.

11 replies

by r. a. caluste

what kind of trouble did you encounter when you use it from the intranet site? have you tried accessing it with http://hostmachine/asppage.asp ?
were you able to access the asp locally with http://localhost/asppage.asp or with file://c/path/asppage.asp? unless you REALLY know ASP and will be sticking to your intranet, i suggest you try the Data Access Page of Access. Data Access Pages lets you create data-enabed DHMTL (instead of ASP) pages from Access Tables and Querise. Its pretty simple actually. Since you have starting reading and learning Access, might as well read and learn DAP instead of troubleshooting ASPs.

by junething

Thanks for the quick response. I believe Data Access Pages in Access gets converted into asp pages. I can access it from C:\\path\foldername\*.asp, but not through http://url/*.asp

by medievaldude

Here's the basics of how I setup ASP pages that use a database. First, set up a connection and set open it using the suitable connection string. Does your page error at this point? Next, set up a recordset and open it through the connection usinga query statement that selects all the fields you want to display on the page. Check to make sure you aren't getting any errors at this point. Then set up a table and loop through the recordset to populate the values into the table. If you're able to get that much, you're halfway through. I would suggest setting up your table so that these values are put into tags like >. Finally, set up a "Save Changes" button that submits this form (make sure you've used

by medievaldude

If you choose to do continue with Data Access Pages, as others suggest, that's not what I'm writing about at all. My approach involves ADO (ActiveX Data Objects) through ASP (Active Server Pages). There are a few basic HTML tags involved, and the ASP code (VBscript or Javascript) is minimal as well. But, judging by other responses, this is probably the more difficult to setup. To use ASP you need to either have an IIS server or PWS (personal web server) on your PC. Yesterday I thought I might be helping you towards a solution, but today I'm not so sure. Yes, ASP can work, but in your case, I'm wondering if it's overkill or if your environment is even setup to use it. You might try the advice of the poster below me first due to the simplicity because if you use ASP, you won't be able to use what those Data Access Pages spit out. You'll have to write it from scratch.

by junething

Thanks for the answer, but rcaluste@heritagepark.com.ph's answer worked for me. As always, newbie can't ask the question correctly due to lack of knowlege. Thanks for the input.

by junething

MedievalDude, has the right idea. I can send a sample mdb file with 2 pics where i'm having trouble inputing info. Let me know i should e-mail that or just send me an e-mail junething@hotmail.com

by r. a. caluste

My workstation is a Win2k Server with IIS5.0
I have Access 2000 installed.
I created a Blank Data Access Page, followed the wizard, connected it to my database, and clicked and dragged the fields into my html body, saved both the html file (its not asp, its actually a dhtml with an activeX control for your navigation) and the database in my c:\inetpub\wwwroot.
i go to another workstation, browsed my pc by typing http://myserver/test.htm and i am able to access my database.
I have tried it and it works for me.
I dunno where you get the idea that data access pages saves it in asp. i suggest you read more on the topic. its pretty simple actually. no programming required :)

by r. a. caluste

Btw, a quick trip to MS Data Access Pages Help Page: "A data access page is a special type of Web page that enables you to view and work with data from a database. It might also include data from other sources, such as Microsoft Excel. How you interact with the page depends on what it's used for." If you want the data over an intranet only and you use mostly IE, then I suggest you really don't have to learn asp (you might find out later that debugging it is harder [you have to learn forms and some html tags too ;P])

by r. a. caluste

I forgot to mention. I created the sample database (with two tables) and the data access page and access it over the network in less than 5 minutes :)

by junething

Thanks for the help!!! Thats what I needed. Only problem is that other computer requires Office Web Componets for it to work. Since I got the basic concept and a working model, I should be okay for now, until I get into ASP, hehe, Hope tosee u guys around, cause I'll be asking lot more questions about Access, ASP, and OBDC. Thanks again.

This discussion is closed to new replies.