Change Management system

R

Razor

Hi,

I'm trying to develop a Change Management system in Access
that will track "successful changes" to a master table
against "submitted changes" on several fields.

We download the master table twice a month. Some changes
would have gone through between downloads and others
wouldn't have gone through. We need to report on these
successful and failed changes.

Since the master table takes feeds from upstream tables,
the system also needs to check for changes that have gone
through but have reverted to their old value ever since.

We also need to track history on submitted and successful
changes.

I currently have a system that consists of 15 queries that
I run in serial order.

Is there a better way or a third-party software that would
perform change management on this master table?

Thanks,

Razor
 
Top