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.
1. Create your web.
a. In Access, select File -> Save as HTML
b.Select
one query you need for your web-page,
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
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 on the image to enlarge.
a) Publish to the Web Wizard
b) Publishing options
c) Data source information