Access, Access 2000, Access 2003, Access 2003 forms, Access 2007, Access 2007 forms, Access 2007 functions, Access control, Access Database, Access forms, Access Points, Access query, Access Tables, Clustering, CSV, Database administration, Database connectivity, Database design, Database issues, Database management, Database Management Systems, Database migration, DB2, DB2 administration, DB2 Universal Database, DB2/400, DBA, DBMS, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, INSERT statement, JDBC, JOIN statement, Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access forms, Microsoft Access subforms, MySQL, MySQL Database, ODBC, QMF, Query optimization, SQL queries, Sybase, Triggers VIEW ALL TAGS
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 them).
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...
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...