When you are running a line of business application in Ms Access there may be a need to record the time at which an entry was made. For example an application designed to record attendance and time management in your office may need to record the time when an user logged into the MIS system. Now this possible with the help of the Now() function in Ms Access which essentially marks the data along with the specific time in which a record entry was made into the database.
Importance of Now() function
The Now() function can give you the exact time at which an insert operation was made into the database by adding a timestamp next to the record. As opposed to the Date() function that can just place the date of the entry, the Now() function can show the time to the last second. The function can be swiftly inserted into a VBA code if needed and does not have any associated parameters that need to be passed. If you are creating an application to work on Ms Access you can even modify the output provided by the Now() function to meet your requirement by using the Format() function in VBA.
Adding the Now() function to a table
- Launch the Ms Access application and open the specific table on which you wish to record the time and date
- Next select the table and move it into Design view
- Now select the column that you wish to keep recording timestamps and go to its topmost cell and add a name such “Record Time and Date”
- Next go to the Field properties and insert Now() in the bottom screen provided for the default value box
- Save your settings
Once you have made the changes, you need to check whether the function is working by inserting a new record into the specific table.
The MDB storage file in Ms Access is highly vulnerable to errors
The Ms Access database uses a MDB file to store its entire data and therein lays the susceptibility of the application from myriad flaws. While some advanced users and professional programmers can consider splitting up the database, most people do not. For example a shop owner running an Access database for inventory management is unlikely to consider splitting the database. Now when the MDB file gets corrupted, the entire data which included details about every product in the store can vanish. Thus irrespective of the business application your are using Ms Access for, you should always keep a mdb repair tool like DataNumen Access Repair around to deal with Access issues. This class leading program has the dexterity to draw out all Access elements including indexes and relationships in perfect shape. Moreover it can effectively locate MDB files that got misplaced when an Access database crash occurred. It is equally effective on ACCDE files and its rate of recovery is best amongst its peers.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit www.datanumen.com