Re: Access 2000: Version comparison

Hi Tara,

I've read the other responses. I work for a gov't entity as well and know what
you're going through as far as working with a db designed by somebody else.
Shoot me an email at rudraighATgmailDOTcom and I'll see if I can lend a hand.

Regards,
RD


On Wed, 27 Apr 2005 07:12:13 -0700, "Jobroni"
<Jobroni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Hi there -
>I'll do my best to explain my dilema.
>
>I'm using Access 2000. In this database, there is one table with about 150
>columns of information, and 206 rows. There are numerous queries and
>reports. I've set up input forms for staff to enter data easily. There are
>8 staff members.
>
>My boss wants to ensure that data entered into this database is correct
>right off the bat. She's asking for a program or code to do the following:
>
>- Auto-generate a form immediately after someone has updated the database
>with new data
>- The report should compare the latest backup version of the database with
>the current "live" version
>- The report should take the fields that were updated in the "live" db, add
>them in the report, and do the same from the backup so she can compare the
>old vs. new data
>- If the data is incorrect, she wants this program to automatically
>"reactivate" the latest backup copy as the live version
>
>I need to know if this sort of thing is possible. If so, how long would
>something like this take to do? Should I hire a contractor to custom-build
>this? Is there an existing program out there that can do this?
>
>Any advice or suggestions would be helpful.
>Thanks a million!
>Tara

.

Relevant Pages

  • Re: Divining the full pathname of a file, all logicals translated
    ... compare it to the "current" state when an audit report is run. ... drive name needs to be retained also, unmasked from any logicals. ... The auditors may never see the actual database. ...
    (comp.os.vms)
  • Re: Creating a report entirely through code
    ... I do backup the front-end before making any changes. ... In my case this is a very simple database, ... > thus greatly increase the probability of corruption. ... >>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Divining the full pathname of a file, all logicals translated
    ... What do you use to create a hash code for files in the directory? ... compare it to the "current" state when an audit report is run. ... The auditors may never see the actual database. ...
    (comp.os.vms)
  • Re: how do i get all fields to default to 0 that have no content
    ... because of lack of space I created a database to record the locations of back ... I am assuming that your backup locations are not specific for any ... and you don't have to worry about having one backup batch or ... That report can then be used to update ...
    (microsoft.public.access.tablesdbdesign)
  • Access 2000: Version comparison
    ... My boss wants to ensure that data entered into this database is correct ... - The report should take the fields that were updated in the "live" db, ... and do the same from the backup so she can compare the ...
    (microsoft.public.access.modulesdaovba)
Quantcast