I was able to figure it out.  My query was selecting only one record, but it did not have the primary key in the query.  I did not know the primary key for the table so I linked the table into MS Access.  In the table setup in MS Access it indicated that the row id was the primary key.  I added the primary key to my query even though I was not using it and now everything worked find.

I would love to learn how to utilize Access (or anything) to update my ACA info.  Can you point me in the right direction?  (I'm not too familiar with Access)

Thanks for any info!!

Leslie - From a big picture standpoint many of the fields and records in Sage 300 CRE can be updated externally using the ODBC driver.  The most common applications used are Microsoft Access, MS Query and Office Connector Write.  Plain old Excel is also common although it can't write directly back to Sage by itself and normally requires a link back through Access to do the trick.  Our company uses the Access and Excel write backs quite a bit. We do not use the payroll module however I checked the data dictionary and the vast majority of fields in both of the ACA related data tables are marked as "replacable", which means they can be updated externally.  In addition, both tables are marked "ODBC creatable" which means new records can be created and bulk added as well.  So assuming you have the proper security level and know what you're doing, it's a great idea.  We use Access dash boards all the time to update those huge tables where you have to scroll through multiple screens to get to the right place.  The good news is that it's not horribly hard to learn, the bad news is that you really should have a good working knowledge of how the ODBC system works before you try it.  There isn't an "undo" feature with write backs and even though the system restricts what can be updated, you need to have a good understanding of how the data all fits together.  Not to scare you off - we absolutely love them, but don't jump in without getting some basic instruction.

If you're a member of TUG and plan on attending the 2024 conference this June in Miami, we teach write backs in the Beginning and Intermediate ODBC workshops (I'm one of the volunteer instructors).  We also cover them occasionally on the monthly TUG webinars.  If you're not a TUG member, feel free to reach out and I'll try to point you in the right direction. 

Mike - That was a wonderful answer and I appreciate it!  I am a TUG member but am unable to attend the conference in June  .  I used Access years ago to write back to Payroll but I definitely am in need of an update & refresher!!  I will watch the TUG calendar for a webinar and also reach out to them to see if one is planned.  Thanks so much!