How to create a column that auto detects an update to another exi.

[Guest]

I need to create a column in an existing database which will automatically
detect if another column in the base is modified/updated by adding a code or
flag of some type.

The database has 7 columns now and 2.8 million records.

size 1.5 gigs

 

[John Vinson]

I need to create a column in an existing database which will automatically
detect if another column in the base is modified/updated by adding a code or
flag of some type.

The database has 7 columns now and 2.8 million records.

size 1.5 gigs

Since an Access database is limited to 2 GByte, you should seriously
consider moving this application to SQL/Server (which has table
Triggers which would let you do this).

To do it in Access you must ensure that the ONLY way that a record can
be updated is through a Form; Tables don't have any usable events. In
the Form's BeforeUpdate event you could insert a value into a newly
added field in your table; one common way is to use a Date/Time field
and set it to Now() to timestamp the change. But this will add 2.8
million records * 8 bytes for a Date/Time = 22.4 MByte to an already
very large database!


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps