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

[DavidFray]

Hello,

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,
David.

[EasyTrieve]

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

[DavidFray]

Windows 10, LibreOffice 5.2.3.3.
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