Publishing MS Access to Intranet 1

[thomca01]

I need to know the step to publish an Access 2000 db to the Intranet. Is there a straightforward approach other than trying to figure out what the books/help says? Any suggestions would be appreciated.<br>
<br>
I have not used Access fluently, I've used dbase and Foxpro. I do need some suggestions.

 

[DougP]

Well Access has built in wizards for publishing documents<br>
Click &quot;File&quot; then &quot;Save as HTML&quot;<br>
Follow the prompts<br>
If you use Front Page to create your WEB site then Access integrates well with it too.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[thomca01]

Thanks, I've been successful with your suggestion. Now that I am using Front Page for the Web it seems that the Report Title needs to be copied and put on every page. Is that a good idea or would it be faster to go back to Access and change the report and then publish it again?

 

[HLotis]

The Title page is misleading in Access. It only appears once. Instead, cut the Report Does This and the column headers form the Title page. Go down a band to page and expand it to allow for the header and columns you just cut.<br>
Select all info above the Detail band and drag it down 1-2 inches, allowing space at the top for the title and column headeres still on the clipboard. Move the cursor into this band and Paste the indo you cut. Data in this band will be repeated on every page.

 

[thomca01]

After performing all of the beautiful designs that Access gives us; I decided to publish it as a HTML and used FrontPage and MS Word. Web publisher did not generate the actual report with all the attributes that I had given it. So, I decide to try snapshot. It looks exactly the way I designed the report. Now, I'm stuck with how to hook it up to the Internet Browser. I've been reading the Help files, and the web site for developers. <br>
<br>
I would like to know whether anyone has a step by step approach to publishing a MS Access snapshot and have snapshot installed on the user computer it they click on the Report. I do hope this make sense. Any comments is appreciated.

 

[Freckles]

did you ever figure out how automatically install snapshot view when the report is accessed. : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.