Interesting Problem...

H

Hendy

I would like to have an online database that works with a e-commerc
website. I am going to have all the inventory set at 0's. When th
first order is made I would like it to start an email to be compose
with the product name and number. I want the email sent out at 4pm t
one address everyday. Is there anyway to do with working with Excel an
with SQL/Access
 
J

Jamie Collins

Hendy said:
I would like to have an online database that works with a e-commerce
website. I am going to have all the inventory set at 0's.

When the
first order is made I would like it to start an email to be composed
with the product name and number. I want the email sent out at 4pm to
one address everyday. Is there anyway to do with working with Excel and
with SQL/Access?
Click to expand...

Do you mean Jet? I don't think Jet supports triggers, which is how you
would do it with a 'proper' database such as SQL Server. With Jet
(.xls, .mdb, etc), I think you'd have to poll the database (i.e. query
at regular intervals) to detect a change.

Jamie.

--
 
Top