Solved

Connecting to Access Backend Hosted on Sharepoint OneDrive

Posted on 2014-04-06
3
1,975 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 33

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

756 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