So I have a SharePoint List and an Access DB... I'm trying to create a one way link from SharePoint to my DB so my SharePoint will update the DB but not the other way around... The purpose of the database is for reporting only. In Access there's only 2 options:
(1) To import the data into a new table - the problem is that this is a one time import and does not refresh so will not see changes that take place in SharePoint
(2) To create a linked table in Access - the problem is that this is a two way link so any changes in access will feed to SharePoint (don't want this to happen).
How do I get around this?? Thanks!!!
4 2577
I haven't as of yet played around with SharePoint, so I'm not sure what a SharePoint list is, but I'm assuming it's a table, probably in SQL Server.
Based on that, if you have development access to SQL, you could create a View to the table with all permissions (Insert, Update, Delete) removed.
If that’s not an option, you could try hiding the Table Link in Access (Right click the table/Properties/Check Hide).
You could then also provide a Query based on the table with the Recordset Type set to Snapshot which would be Visible but Read-Only.
zmbd 5,501
Expert Mod 4TB
J has part of this.
J - In the sharepoint environment, most users do not have any access to the underlying structures, only the the share point lists; thus, your SQL solution is not viable.
The snap shot is a good idea; however, is limited in scope and will not easily update.
MauricioP:
One possible solution and it builds on J's
Link your table.
Either name it USYS_and-your-table-name or set the table property to hidden
For ease of form development:
Temporarily Create a standard select query.
Use this Query to design your form. Once happy with the form set the properties of the form to allow edits/additions/deletions to "No"
Now switch your query to SQL view... copy and paste that SQL into the recordsource property of your form.
delete the query.
Here's the rub, any changes to the Sharepoint side of the sharepoint list are not real time to the queries nor forms...
All,
I also believe it is possible to set the permission of a SharePoint List to Read Only. Thus, those who access the SharePoint List via the DB would have Read Only Access, but others, who update the list via SharePoint, would have read-write. However, if the users are the same, this will also cause problems.
Even Z's solution, although effective as a preventative measure, DB users could still access the linked list directly.
SharePoint is an interesting nut to crack. I have been fortunate enough to not have to use it often.
The problem with this one way update is what happens when someone updates the values in the Access database and then someone else updates the values in the Sharepoint list? Which update takes precedence? If someone can update the Access data separately from the Sharepoint data, eventually you're going to have conflicting updates.
Alas, that's a question only you can answer as you know best how you want to use the data. To accomplish this "one way data feed", you run VBA code that imports the data before anything that would present the data to the user.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: phill86 |
last post by:
Hi,
I have an access 2010 database that I want to convert to an SQL Server database and I need to know if the data macros in access will still work in the SQL database or will i have to create...
|
by: Yaasir |
last post by:
today is my 1st time of seeing this site and i must say that it's luvly.
i discotered this site today in my search for help as to how to create an executable file of a database i created in access...
|
by: beacon |
last post by:
Hi everybody,
My title may not exactly describe my issue, so please forgive my lack of creativity today.
I've got a database that was created in Access 2003 that I've opened in Access 2010. I...
|
by: SHSEMA |
last post by:
I want to create a stacked column chart in MS Access 2010. I have created a basic column chart using the create design and adding a chart from the menu bar. i have selected the 2 data series that i...
|
by: Jo Ann Dullum |
last post by:
I have a table in Sharepoint 2010 that users have submitted proposals into. I have a link to it in my Access 2010 database. The link works perfectly on my XP laptop but not on my Windows 7 desktop....
|
by: jdks2006 |
last post by:
I work with a company who is needing to use Access 2010 to receipt in checks for paid invoices. Our issue came when our auditor found we had duplicate receipt numbers using serial numbered receipt...
|
by: hamaxula |
last post by:
Hello,
I have a continues form, which contains Items, for example my items are like this: B-1,B-2,B-3....etc, i want when i entered B-1 in the first row, automatically write input B-2, B-3 in the...
|
by: manashRanjanDas |
last post by:
Hi,
need a small help in understanding the logic or approach.
1. I have a database (Access 2010), which is getting updated frequently by different people on the intranet by VB application.
2....
|
by: topher23 |
last post by:
A layout provides a grouping method for controls on a form or report. The two default layout types are Tabular (labels in form header, controls in detail), and Stacked (labels to the left, controls...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |