Exceeding maximum record locks in Access
i have written code to import information from several text files into a linked table. It works fine for a while, but eventually I always get an error about exceeding the maximum allowed locks. I do not want to change the registry – i would rather just not have any locks (because I don’t need [...]

Answer Question   |  August 26, 2010  4:17 PM
Access, Access Records, INSERT statement, Windows XP

How to Set Active Period in a Table
There is a table of multiYears record. Transaction date should be between Active Period. If any time I want to change/edit previous year record, first, i have to set that year as Active period. I have to select active period through a Form by dropdown Combo box option. When I select any year, this should [...]

Answer Question   |  June 1, 2010  4:46 AM
Access 2003, Access Records, Microsoft Access

Date a specific record in Microsoft Access
I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I receive a [...]

Answer Question   |  April 9, 2009  1:38 PM
Access Database, Access Records, Microsoft Access