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.
