Doing that yields with the same exact code the error message, "Current Recordset does not support updating". I can safely say that I have been setting the mode to "Read/Write" since the start and have played around with the lock type, cursor location, and open method.
Create parameters End With Set rs Data as New ADODB. Open cmd Proc,, ad Open Static,ad Lock Batch Optimistic '...
Hi, My code is working just fine on my computer and I can update the access from my excel.
Scans your site and returns information about your SSL implementation and certificate.
Helpful for debugging and validating your SSL configuration.
Mainly the advice from Microsoft and others is to make sure the mode on the connection string is set to "Read Write", as the default is "Read Only" and to make sure to set the lock type to either optimistic or pessimistic.