Solved

Connecting to Access Backend Hosted on Sharepoint OneDrive

Posted on 2014-04-06
3
1,999 Views
Last Modified: 2014-04-06
Is it possible to connect to a MS Access database backend that is hosted on a Sharepoint OneDrive without downloading it to a local drive? I suspect not, but am just introducing myself to Sharepoint...

Any input is welcome!

MV
0
Comment
Question by:Michael Vasilevsky
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 34

Accepted Solution

by:
ste5an earned 500 total points
ID: 39981486
No, not really.

The download function primarily focuses on getting a rich user interface. Thus you need the front-end locally.

The point is to use either Sharepoint lists or using linked tables to SQL Server. So that you use shared data.
0
 
LVL 10

Author Comment

by:Michael Vasilevsky
ID: 39981493
That's what I thought - just wanted to confirm.
Thx!
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39981495
I started writing my answer but then I saw this written by Albert D. Kallal, written so well I deleted my own answer:

Simply placing the access database on a SharePoint site will NOT allow you to linked tables in that acccDB file.  In fact placing an access database on a web server will NOT allow you to link to the tables.  Linking to an access database back end mdb or accDB file ONLY works if the back end is placed in a STANDARD windows folder.

However what you can do is send the tables from access up to SharePoint, and in this scenario you'll not be placing the mdb or accDB file on SharePoint but MIGRATING the data from the accDB file to what are called SharePoint lists. So if you do this, then you CAN LINK to those tables on SharePoint, but you will NOT be linking to the mdb or accdb file anymore.

Last but not least, in access 2010 you can also use Access Web services and publish your tables to SharePoint site. Again this will allow you to link a standard Access front end to these data table and ALSO allows you to build web forms.

So, just keep in mind the BIG difference between uploading your data tables SharePoint and that of simply placing or saving the mdb/accDB file on the server.

So:
Place/save mdb/accDB file on SharePoint = no linking from Access front ends
(this includes uploading the mdb – uploading is NOT same as exporting the data tables to SharePoint)

Upsize/upload tables to SharePoint lists = yes, you can link to these tables from Access.
(this means you are exporting or publishing the TABLES to SharePoint and NOT the accDB file). If you do this, then as noted you can link to the data which will now be in SharePoint and NOT in the accDB/mdb file anymore.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question