Step by step help linking live MS Access to DW!!!

[Guest]

Hello,
I just recently took a DW class and am still learning how to use the program. My manager is having me design the company Intranet page in DW, and one of the requests is to have our charts and graphs that were created in MS Access, to appear on one page on our Intranet page.

I know how to hyperlink MS Access tables, but I am having trouble linking "live" charts that will constantly be updated by users. I am having trouble linking multiple Access tables that will appear on one page.
(I keep hearing people talk about connection strings, ODBC etc. and I am not sure what these mean).

Is there a tutorial or book on how to do this with beginner's in mind? Any advice would be greatly appreciated.

Thanks!
- McSushi

[Newsgroup_User · Accepted solution]

McSushi wrote:
> Hello,
> I just recently took a DW class and am still learning how to use the program.
> My manager is having me design the company Intranet page in DW, and one of the
> requests is to have our charts and graphs that were created in MS Access, to
> appear on one page on our Intranet page.
>
> I know how to hyperlink MS Access tables, but I am having trouble linking
> "live" charts that will constantly be updated by users. I am having trouble
> linking multiple Access tables that will appear on one page.
> (I keep hearing people talk about connection strings, ODBC etc. and I am not
> sure what these mean).
>
> Is there a tutorial or book on how to do this with beginner's in mind? Any
> advice would be greatly appreciated.

I have never heard or seen Access charts being used on a webpage.

What I have seen is the use of Dynamic Flash Charts that take the data
from tables or views or stored procedures. If you google for "ASP
dynamic charts" you will find a load of resources that will help you get
to your goal.

Steve

[Newsgroup_User]

I believe Doza is correct. Access stores the data. The interface you
are use to seeing when working with Access interactively will not be
displayed automatically on a web page. You will have to code that.

[Guest]

Thanks!
I will do a search on ASP. I had a gut feeling that that was the route I was supposed to take in trying to figure out how to do this. I was told that I needed to install ColdFusion to figure out how to do it, but I think that will only complicate things.