Running VB code from table access
Posted on 2004-09-21
I am looking at creating a new database from scratch in access for the backend of a web application. I have done a bit of database design in the past and know that if your users are working with "forms" that you have created you can create VB code that runs when the users access the forms or do particular things.
Now because my users are coming in over the web (using asp) they wont be interfacing with forms, they will be directly interfacing with the tables. What I am wanting to know is if there is any way of running VB from within access when a user opens a "table" and focus on a particular record. For example, i could be a products table and every time a user access a particular record it runs some VB that runs a counter.
The reason for this is that i am trying to make my web application as efficient as possible. and i would prefer the database to run some off the code its self rather than creating a million line of code to do it from a web page.
Thanks in advance Anthony