Implementing Access 2007

[Amanda]

I am using Vista (which could be my problem), and creating a web site, using
Publisher 2007, that contains a list of products, pictures and prices. I
would really like to use either Access or Excel so the information could be
changed easily. Ideally, I would like to be able to make the changes to the
product prices and descriptions and see those changes instantly updated on
the web site. Is that possible?

I don't think the mail merge feature is good enough for what I would like to
do because I think it assumes that everything is in the correct order, and it
may not be. Maybe I'm doing that wrong as well.

I've tried working with the ODBC feature in Access 2007 and I keep getting
errors telling me that I don't have the proper software installed. (It's
been about a month since I've played with this, I was getting pretty
frustrated and had to stop working on it for a while.) Any direction or
advice would be greatly appreciated. Thank you.

 

[DavidF]

This is beyond the scope of Publisher webs. Publisher produces static pages.
Look to ASP.NET, PHP or some other database solution for this kind of
dynamic functionality. Perhaps post a question in an Access group as to how
to integrate a Access database in this manner and a solution.

DavidF

 

[Amanda]

That's what I was afraid of...thank you for answering so quickly.