i want to know how to write a log everytime database changed, create a new log file every month/log deleted , Am I must write the code every
Code:
rs.update
rs.delete
or is there other way??


sometimes my acces file sudenlly gets so big, more than 2 MB for less than 20 record on 4 tables
and getting really sloww
when I open it on M acces, then klik database utilities > compact and repair databases, i'ts size reduced to 194KB, can we use something in vb to call this function??