MS Access | Foster Solutions (FSI)

Create TXT settings file for VBA apps

June 21, 2014 by doug

It’s very useful and easy to use a text file as a settings file for VBA applications. The below code is a function that will open a file called adm_settings.txt in the directory of the application file and loop through it to see if it can find the passed setting. If it does, it will …

MS Access Form Error when editing SQL Server tables

May 5, 2013 by doug

I have found a frustrating write conflict error while building MS Access forms with linked SQL Server tables. There are issues with not having a Timestamp (RowVersion) field, but I finally stumbled across the culprit that was affected several forms. If there is a bit field with null values, you can’t edit the record. You …