SQL Server 2000 sp3; single instance; used as backend to Access 2002:
I have 20 tables used as a temporary store, each one receiving data
from VB based remote applications that insert new data on a regular
basis.
My current Access apps are used to collate, action and summarise this
data.
The collation process involves checking the new data and adding it to
a single table, and if action is required flag this - this is done in
the "server" Access app. The other Access apps are used to filter and
view the data, reports etc.
Question:
is it possible to do this collation in SQL Server by some automated
task triggered by an event, thereby speeding things up and releiving
the need to be logged on with the "server" Access app ?
The function outline for each of the 20 tables would be:
1. Are there any new records, if so insert them into the central table
2. If the status field=1 of any these new records copy these records
to a 2nd table
3. Repeat
regards,
B Moor