Solved

Connecting to Access Backend Hosted on Sharepoint OneDrive

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now