Part 1
Part 2
Part 3
Part 4 Feedback Privacy

DataBase Connectivity - The Access Side of things 

There's good news, and there's bad news. The good news is, if you have Access97, it will do almost everything for you. The bad news is, if you don't have Access97, you'll have to do it all yourself. If you don't have Access97, this page won't help you much. Look at part 3 for the step-by-step.

In Access97, it's all very easy:

1. Create your web. 

  a. In Access, select File -> Save as HTML

  b.Select one query you need for your web-page, and click Next. You can go back and do other queries later. It is possible to do several at a time, but let's start off easy, ok? Now, Click Next!

  c.You should now see a  window which looks like figure a). If you want to, you can choose a template for your page, or not. Click browse if you want to pick a template. Then click Next.

  d.The window shown in figure b) will let you choose how you want your data published. We're opting for HTX/IDC. This is a little simpler than using ASP pages... Click Next.

  e.In the windows shown in figure c), enter the Data Source Name that you created earlier. If your database is password protected, you need to supply a  username and password too. All done? Click Next.

  f.Choose where you want the files to be located. Access will create a IDC/HTX pair for each query you have selected to output. 

  g.Answer Yes to the  question about Access creating a homepage. You don't really need it, but it will show you how to link to your IDC files.

Click Finish.

  Click on the image to enlarge.


a) Publish to the Web Wizard


b) Publishing options


c) Data source information