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
