Since the amount of rules that I'm programming in my M1G is growing large, I tried to do documentation in the only place available for this purpose: The Notes field in the Account Details. To my suprise I got a limit of 255 characters. This is a a known database limitation of the MS Access Text data type, but the Memo data field does not have this limitation. It would be great of this field is replaced by a Memo data type in the next ElkRP version.
Actually, this change is so trivial that I opened the ElkAccts.mdb in MS Access and changed the data type for the field storing this information (Accounts.Notes). I was able to add more information. But when opening it back in ElkRP, it only displayed the first 255 characters. The other information was not shown, but remained there. In order for this to work the field logic have to be changed in the program too. This would be a greate simple improvement to ElkRP.
Warning: Dont attempt this at home.
Seriously, dont mess with the other tables or fields in the database. They look really ugly. Also, I did proper backup of my original MDB before attempting this.
Actually, this change is so trivial that I opened the ElkAccts.mdb in MS Access and changed the data type for the field storing this information (Accounts.Notes). I was able to add more information. But when opening it back in ElkRP, it only displayed the first 255 characters. The other information was not shown, but remained there. In order for this to work the field logic have to be changed in the program too. This would be a greate simple improvement to ElkRP.
Warning: Dont attempt this at home.

Seriously, dont mess with the other tables or fields in the database. They look really ugly. Also, I did proper backup of my original MDB before attempting this.