How to import Access database files to SharePoint Access app?

Question

I am trying to move an Access application with 2 database files into a SharePoint Access app. I created the Access app but can't get the database files to be uploaded to it? I want both the Access app and the database files to be located in the SharePoint site so it can be accessed from any external PC  using the browser. After searching can't find any solution to this problem.

Answer 1

hi stanley,

to better understand the situation, i'd like to confirm the following things:

1.do you use sharepoint online or on-premises sharepoint server?

2.do the access application created directly in desktop version? is it related to on-premises sharepoint server or sharepoint online?

3.could you let us know how do you crate the access applications and add it to sharepoint online?

4.the screenshot for the error message about "can't get the database files to be uploaded to it".

to post a picture, click use rich formatting>insert/edit media  in the thread page.

moreover, here is an article for your reference:upload an access app to a site.

best regards,

tim

Answer 2

hi stanley,

it is not feasible to import access database files directly to a sharepoint online access app. you can consider the following two workarounds first

workaround1:

open access 2013 or 2016 client->select custom web app -> set web location as your team site url and click create -> next to create a table from an existing data source, select access. see the screenshot below.


on the next page, browser to your local access database and click ok-> on the import objects window, select all and ok. then all objects will be imported to sharepoint online. then a new access app will be created.

workaround2:

import access database as sharepoint lists. refer to: http://sharepoint.rackspace.com/sharepoint-2013-how-to-publish-an-access-database 

third party link disclaimer

disclaimer: microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the download you receive from the third-party linked sites or any support related to the download or the downloaded technology. if you need support relating to the third party technology, please contact the manufacturer directly.

thanks,

sky

Answer 3

Thank you Sky for your suggestions, however I was unable to move the Access application. The application was split into 2 database files that work together. Your samples seem to convert individual tables and does not seem to address the problem of moving the whole 2 file application which run the application.

Answer 4

Please keep in mind that the 2 files make up a database application and are not just tables. The Access database is split into 2 files (DBESys.mdb -the objects and DBEData.mdb - the data)

Answer 5

to better understand the situation, i'd like to confirm the following things:

1.do you use sharepoint online or on-premises sharepoint server?

a site was created for me at https://haw***oimt.sharepoint.com/sites/dot-ocr-dbe.

2.do the access application created directly in desktop version? is it related to on-premises sharepoint server or sharepoint online?

we have a access desktop database application which is split in to 2 files (dbedata.mdb & dbesys.mdb). which is located on a shared local drive. i would like to move the access application to the online sharepoint site.

3.could you let us know how do you crate the access applications and add it to sharepoint online?\

i created access app named dba database.

but don't know how to upload the 2 access application files (dbedata.mdb & dbesys.mdb) to it.

4.the screenshot for the error message about "can't get the database files to be uploaded to it".

there is no error message.

i want to upload the access application with the 2 files to the online accesss app so i can access the

the application on any non company computer using my browser to connect to the sharepoint sitehttps://haw***oimt.sharepoint.com/sites/dot-ocr-dbeand run the access app.

however i cannot find instructions on how to upload the access application to the online access app.