Can't modify data in SQL Server 2014 database with ADO/OLEDB connection in Base


I want to distribute in my company a Base form to fill data in a SQL Server base.
I can connect with ADO (integrated authentication or SQL user), list/add/edit tables and list data but I can’t manage data. All option to do so are greyed out as if in read-only mode. Even if I connect with a sysadmin user.
With an ODBC connection, I can edit data but then I must create the ODBC connection on every workstation.

Can somebody help me?

Thank you,

Please further clarify what your os and base versions are. And how exactly are you connecting. thanks

Windows 10, LibreOffice
I use ADO connection mode, and the wizard utility to generate a connection string like Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBNAME;Data Source=SERVERNAME