|I'm curious, Raffi, why you insist on programming for Access. It's a long obsolete, inefficient database management system with extremely limited capabilities. Once upon a time it was a viable platform for many small business applications because SQL Server was so incredibly expensive. So long as the user count remained below about 5, it was relatively reliable, though prone to corruption if locking was improperly implemented.
But now the free version of SQL server offers capabilities that are orders of magnitude greater than Access ever had, and supports much larger databases. Why in the world would anyone still use Access?
By the way, Access, as part of the MS Office suite, was designed to be programmed using Basic - VBA, to be specific. Using any other language will involve workarounds and compromise. If you really want to build a product that has any hope for widespread acceptance by businesses of any size, Access is definitely the wrong way to go.
Will Rogers never met me.