473,325 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How to Link Sharepoint list to MS Access

maxamis4
295 Expert 100+
Hello everyone,

I am looking for some help and references. What I would like to do is programmatically refresh my links to SharePoint via VBA. Currently I am prompted every time to enter the password I need to authenticate to SharePoint. This is fine but I would like to do this through the backend if possible. Does anyone have this type of experience doing this type of work?
May 7 '12 #1
6 7418
Narender Sagar
189 100+
what is the SharePoint and Access version are you using..?
In SharePoint 2010 & MS Access 2010, it can be authenticated by domain login itself. Once you are logged on to your domain server, you'll be automatically authenticated to SharePoint 2010. You don't have to authenticate yourself again & again, while refreshing your database.
May 7 '12 #2
maxamis4
295 Expert 100+
Good question,

SharePoint 2010

Office (MS Access) 2007.

I am not on a domain since I am working on a project for a client so it will not be using domain services and requires login because of that.
May 7 '12 #3
NeoPa
32,556 Expert Mod 16PB
This sounds like it breaks down to a networking question fundamentally. I've never used SharePoint (which I've never regretted so far), but I would guess that an (persistent) authenticated network connection to the server it is running on would give you what you need. A common way of achieving such a persistent connection is to set up a network path to a share from that server as a drive letter. Make sure to set "Reconnect at log on".
May 7 '12 #4
maxamis4
295 Expert 100+
NeoPa,

As always you bring an excellent point to the table. A little run down on SharePoint 2010. SharePoint to simplfy things acts like an excel sheet (obviously 2o times more powerful) in the same fashion that you can enter data, have columns, rows, filter, sort, and store data. Same as an MS Access table. You can image the creative folks at microsoft saw this as opportunity to create functional applications in the cloud using sharepoint. My client does not care to invest in a sharepoint developer and knows that natively ms Access can plug into sharepoint. He wants to use Sharepoint as an online cloud storage for his database while maintaining it functional.

Believe me i have tried to talk him out of it but he feels it can be the source to provide a hybrid cloud application with DR capabilities.

That being said Office 2007 has issues connecting to sharepoint 2010. It doesn't seem to be able to establish a connection every time unless you force it to authenticate to 2010 sharepoint services. Not sure why this is but once the credentials are put in then sharepoint link works just fine. I wanted to do this in the backend to leverage the link table relationship to his SharePoint list (linked table). So that is why I inquired about the back end authentication.
May 7 '12 #5
NeoPa
32,556 Expert Mod 16PB
Thanks Maxamis. Unfortunately, while what you say makes sense, I cannot go any further with it due to lack of direct experience with it. I wish you luck nevertheless :-)
May 7 '12 #6
Narender Sagar
189 100+
Maxamis, your client has really chosen good option. SharePoint 2010 along with Access 2010, is really really powerful. I am using it for about two years and I know its potential. Reason are many like : Data is stored centrally on SharePoint lists (tables) which acts as back end and Front end is Access 2010. I can list down so many benefits, of using SharePoint...(But right now, I'll not go into details of it )
However, to answer your question, Pl. follow following steps:Internet Explorer
Local Site (Not internet)
Go to Internet Options->Security
Click on Local Intranet then click on sites and advanced.
Add your SharePoint site to this list then click add then close and OK.
On the same window, click Custom Level and scroll down to the bottom of that list where it says "User Authentication"
Change this to Automatic log on with current user name and password.
External SharePoint Site (Internet Site, not recommended)
Same steps as above, but click on Trusted Sites to add your SharePoint site
Then click on internet to adjust permission levels
You can also check following site :
http://technet.microsoft.com/en-us/l...ffice.13).aspx
May 8 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Sorin Marin | last post by:
Hi Experts, I have some Oracle views linked in an Access database ¬ this is the good part. Now I try to link to an Access query from other database (still Access) but I have no clue how. I'm a bit...
4
by: Balex | last post by:
Hi I have recently helped somebody converting an Access application into an Access (2002) front-end and an Oracle backend. It worked fine, until he decided to install and use Access 2007...
0
kaptaineaux
by: kaptaineaux | last post by:
Hi, What I am trying to do is update a field in list programmatically using a webpart. What I do is I get the context of the site, then all lists of type Events. For each End field that is...
0
by: Chris at Pierce | last post by:
I have a Windows Forms Vb.net program written in vstudio2005 that I would like to have access a MOSS (Microsoft Office Sharepoint Server 2007) List, and have the ability to add records to that...
0
by: barmatt80 | last post by:
I am trying to write a program that the user can select an approval date and using that approval date, it would query a sharepoint list and return that list item that corresponds with that list item....
2
by: servantofone | last post by:
I have a couple tables linked to Sharepoint Lists. All queries on these tables run very slowly. Is there a faster way to access these tables? I'm afraid my users will give up and End Task the...
2
by: ismailc | last post by:
Good day, I need help. I would like to Update a Sharepoint List (Document Library) Folders using Web Services with Javascript. I have searched on Goggle but nothing that updates a document...
0
by: apcalogic | last post by:
I have a Bluetooth enabled Laptop & I have 2 Bluetooth enabled mobiles named as AX1 & AY1 My Laptop display these mobiles in main window of Bluetooth as follows AX1 AY1 I am aware that...
1
Vkas
by: Vkas | last post by:
hi I am Working in Moss ! My target is to populate the share point list using asp.net web Application I had Create a website is Asp.net with a simple form having 3 text field and a button I...
0
by: napstar | last post by:
I would like to know how to customize a list library to show only the user's documents. do sharepoint lists have an event analogous to ASP.NET Page Load event?
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.