Access vba current recordset does not support updating Sexy online chat without restriction
When I create a DSN connection to SQL Server using the wizard, I am able to link it to a view.In this case, Access recognizes it as an editable table.Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.Its components include: Active X Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).
This achieves the same effect as using count(distinct Reports To).
But if I use a DSN-less connection to a view using vba code (Method 1 from https://support.microsoft.com/en-us/kb/892490), it is linked as a table that is NOT updatable.
I don't know why there is a difference, but how can I make a connection to a view in SQL Server (either as a table or a query in Access) and have it be updatable?
[Licensed To]Microsoft is providing free developer extensions and runtime Access so you can create an Access 2007 application and give it to users who do not have Access 2007.
(In previous versions, this was an additional commercial product.) There are many other little improvements as well.