Results 1 to 5 of 5
Jun 2, 2003, 01:12 #1
Email search matches to registered users (MS Access/ASP)
I am about 60% through a development project using ASP and MS Access.
I have a user registration/management system sorted out, as well as a search system.
I want registered users to be able to store a set of search criteria, and to be emailed when a new entry is made into the database that meets their requirements.
Can this be done in Access?
Or will I have to put all the matching/emailing code into an ASP page that is run once a day?
Many thanks for any pointers.
Jun 2, 2003, 10:03 #2
Sounds like a job for a stored procedure. Which is now supported by Access (as of 2000). Not something I've got much experience in though.
Also, don't forget your global.asa file. You can cheat things like these often, by having them run every time a session is started by a user. It makes it sporadic as to when the script will run, but if you have a decent number of users a day then you know that every time someone visits the site your script will run.
Jun 4, 2003, 01:36 #3
I really didn't know that Access 2000+ supported stored procedures.
Thanks for the pointer, it gives me something to go on.
Jun 4, 2003, 04:20 #4
- Join Date
- Nov 1999
- Mechanicsburg, PA
- 105 Post(s)
- 1 Thread(s)
Jun 4, 2003, 04:48 #5
Accepted, but seems close enough.
If I can write a macro in Access to do what I need, I will be happy with that.