Access & Websites

[Khalil Handal]

Hi,
I am new to this, so be patient with me please!
I have a website that lists items, each item has a price. I need to change
the prices between now and then. All item numbers and item prices are in a
database (table).
It takes less time when upsating the table in access than going to every
page in the site and update it manually!

How can this be done?
Is there a tutorial for doing this ?
any help is appritiated

 

[Allen Browne]

See if this does what you need:
Export data to web pages
at:
http://allenbrowne.com/AppOutputHtml.html

It's a free, downloadable Access file, the exports HTML as one long page
(not broken into separate pages as the built-in export does.)

You create the query with the fields you want, sorted as you wish, and enter
a record so the database knows the HTML file name, browser title, heading,
the text you want to show above the price list, and the text to show below
it. You can also specify keywords and page description if you wish.

Works in Access 2000 and later.

The version for Access 2007 supports rich text fields.

Having that that up once, you just click a button to create an HTML page
from your data. You don't need to modify the code, but you can if you wish.
If you just want to read the code instead of downloading the utility, it's
here:
http://allenbrowne.com/AppOutputHtmlCode.html

 

[Albert D. Kallal]

Hi,
I am new to this, so be patient with me please!
I have a website that lists items, each item has a price. I need to change
the prices between now and then. All item numbers and item prices are in a
database (table).
It takes less time when upsating the table in access than going to every
page in the site and update it manually!

How can this be done?
Is there a tutorial for doing this ?
any help is appritiated

As a general development issue it is considered a very bad idea to edit data
directly into a table. The reason for this is that you can't provide a
proper user interface. Furthermore you can't do any kind of data input
verification as to whether the correct kind of data is being entered. Can
you imagine if the accountant asked for a nice table to easily edit his
accouting data. However then all the balances checking, and even what types
of account numbers are legal to be entered are NOT going to be verified for
data input? We had a saying for many many years in the computer industry:

garbage in = garbage out

Having said the above, the fact of wanting to edit some data in MS access
that resides on a website is an entirely different question. The answers is
yes you can use MS access to edit that data **if** the the peoole that run
the web site can allow ms-access to connect to the database system that
holds that data for the web site. That database system might be Oracle, or
MySql, or Sql Server or whatever. so you'll have to talk to the people that
run the website and ask them how their databases set up and run, and do they
allow remote access to that information.

So keep in mind the MS access is not a system that holds the data, but is a
system that lets you build forms, built reports and lets you write some code
that manipulates the data that ms-access has connected to. So, if the people
who run the website can gave you a connection to their database, then you
can likey use MS access to edit that data. in most cases you'll have to be
on the same network or have a network connection direct to the machine that
holds that data for the web site. This type of secure connection is
certainly not something that anybody's going to be able to do, as you can
imagine how crazy it would be if I could edit the tables for pricing on the
web site for ebay or www.amazon.com!

So, keep in mind that MS access itself has absolutely no relationship to a
web based system, is not a web based development tool, and has no ability
for building a web site at this point in time.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)





mail plates data that MS access connects to


to any of that data, but you have to be able to talk to the web people and
ask them where that data resides in what table and in what database system,
and if they give you access to that

 

[Khalil Handal]

Thanks to both of you

See if this does what you need:
Export data to web pages
at:
http://allenbrowne.com/AppOutputHtml.html

It's a free, downloadable Access file, the exports HTML as one long page
(not broken into separate pages as the built-in export does.)

You create the query with the fields you want, sorted as you wish, and
enter a record so the database knows the HTML file name, browser title,
heading, the text you want to show above the price list, and the text to
show below it. You can also specify keywords and page description if you
wish.

Works in Access 2000 and later.

The version for Access 2007 supports rich text fields.

Having that that up once, you just click a button to create an HTML page
from your data. You don't need to modify the code, but you can if you
wish. If you just want to read the code instead of downloading the
utility, it's here:
http://allenbrowne.com/AppOutputHtmlCode.html