Simple indeed. That's is one of the beauties of eCritera.net, you get all
these
features for one low monthly fee ... instead of having to learn programming
yourself. Its a matter of how valuable your own time is.
Nobody mentioned in this newsgroup yet, but you're going to have to learn
the CDONTS API in order to do what you're talking about.
Cheers,
"Raphael Gluck" <iwish i could tell you @alas blame the spammers> wrote in
message news:OHK3muLbDHA.2368@TK2MSFTNGP09.phx.gbl...[color=blue]
> thanks Jason for that
> Certainly something to read up on, though i guess at the moment i am just
> looking for something simple
>
> But thanks for taking the time to help me
>
> Raphael
> "jason" <jason@catamaranco.com> wrote in message
> news:umvmyhLbDHA.3360@tk2msftngp13.phx.gbl...[color=green]
> > I think you need to distinguish between whether you wish to recieve an[/color]
> email[color=green]
> > notification if a new user is added to your database...OR....
> >
> > If you actually need to create an AUDIT trail of the changes made to[/color][/color]
your[color=blue][color=green]
> > products/inventory/items etc by the administrator in your online admin
> > section with regards:
> >
> > 1. EDITS
> > 2. INSERTIONS
> > 3. DELETES.
> >
> > In this situation, you could:
> >
> > 1. Create duplicate audit tables of your primary tables: eg: Primary:
> > Inventory table and Audit: Audit table:
> >
> > The audit table would contain all the fields in the primary table PLUS:
> > AuditType (eg: edit), AuditDate, AuditPerson (eg Administrator).
> >
> > Thus: If the adminstatror 'edits' the inventory table it automatically
> > updates the audit table and inserts all the same data plus: EDIT,
> > 27/05/2003, Administrator.
> >
> > You could then generate a daily report to view all the different changes[/color]
> to[color=green]
> > the system and trigger other events based on this.
> >
> > Future challenges could include trying to do automatic email[/color][/color]
notifications[color=blue][color=green]
> > to your customers that new inventory has been added. You then run into
> > problems with limiit restrictions imposed on your host eg: 800 emails[/color][/color]
per[color=blue][color=green]
> > day via CDO or aspEmail.
> >
> > You could buy a list sever - but more complex and/or expensive.
> >
> > You could buy the product called Access Emailer but this only works[/color]
> locally[color=green]
> > off your drive. You would then need to figure a way to sync the offline[/color]
> and[color=green]
> > online acess databases to allow you to leverage the local Access[/color][/color]
Emailer.[color=blue][color=green]
> >
> > These are actually problems I am grappling with and compouned by fact[/color][/color]
that[color=blue][color=green]
> > my engine local database is a different format: Act! which means I have[/color][/color]
to[color=blue][color=green]
> > consider user restrictions and the possibility of using other add-ons[/color]
> which[color=green]
> > have limited programming api potential.
> >
> > Read more on audit trails here for access 2000:
> >[/color]
>[/color]
http://www.google.com/search?hl=en&i...rail+for+acces[color=blue][color=green]
> > s+2000
> >
> > Hth
> > Jason
> >
> > When the administrator updates the inventory table it also updates the[/color]
> audit[color=green]
> > able
> > "Raphael Gluck" <iwish i could tell you @alas blame the spammers> wrote[/color][/color]
in[color=blue][color=green]
> > message news:#l0uSsKbDHA.2308@TK2MSFTNGP12.phx.gbl...[color=darkred]
> > > Hi,
> > >
> > > Is it possible for one to program one's pages as such that when a[/color]
> > database[color=darkred]
> > > table is updated over the web, via a form, that an e-mail confirmation[/color][/color]
> is[color=green][color=darkred]
> > > sent to a specified address, notifying the update has taken place?
> > > If so is there a tutorial out there that is easy to understand and
> > > implement?
> > >
> > > Thanks so much
> > >
> > > Raphael
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
