SharePoint column permissions in datasheet view, MS Access and web services
Vladi Gubler
Vladi Gubler
November 27, 2012 | Products


We are proud to let you know that Smart List Pro now supports column permissions in Datasheet view, MS Access and in Lists.asmx web service, in addition to the regular list views and forms.

Among other features, Smart List Pro allows you to set permissions to columns both directly and, even better, by grouping them into tabs and setting permissions to the tabs themselves. Just imagine how easier it is to group 50 columns into 5 tabs and set permissions to the tabs themselves, instead of settings permissions to each individual column out of 50!

Now these permissions apply to non-SharePoint forms environments as well.

In Datasheet view, columns with permissions (both direct and through tabs) are presented as Read-only, so you have to modify the values in list forms only, preventing unauthorized access.

In Access (and other applications that use Lists.asmx web service) the columns are also shown as Read-only. Additionally, if a column value has to be Hidden (according to permissions and conditions), the column will appear blank for the specific items if the current user does not have the necessary permissions.

As an added bonus, this new feature also makes several of our custom fields editable in Datasheet, Access and web services. These fields include Connected Field, Color Field, URL Plus Field, Document Link Field and the free AJAX Field. Additionally, some fields that store values in our unique unreadable format (such as Signature Field) are excluded completely to prevent confusion.

Please note that the new functionality applies to Smart List Pro only, it does not work in the free Smart List Lite.



Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to to open a support ticket.


Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!


Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!


There was an error processing your request.
Please contact us for further details.


Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions


Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.


There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.