Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-12-2019, 03:28 AM   #1
chuckcoleman
Newly Registered User
 
Join Date: Aug 2010
Location: Chicago Illinois suburb
Posts: 195
Thanks: 9
Thanked 7 Times in 3 Posts
chuckcoleman is on a distinguished road
Updates to front-end and impact with SharePoint tables

Hi, I've developed a database and split it into a front-end and back-end databases. I then from the front-end exported the data to a SharePoint list. The reason for this is that there are three remote locations plus a main-office location for this application. It is my understanding that the front-end, (which grew in size after I exported the back-end tables to SharePoint), actually contains a copy of the tables that are now on SharePoint. If this is correct, my question is when I add functionality to the front-end or fix bugs and distribute a new front-end, the new front-ends tables will be out of sync with the tables in the SharePoint lists, so what happens. I think my hope is that the data from the SharePoint lists are downloaded to the new front-end copy of the tables vs. the new front-end, outdated tables overwriting/updating the SharePoint tables. In the past I always split the database and when I made changes to the front-end, since the tables were linked to the back-end, either on the same local machine or on a server shared folder, things worked great. In this case with SharePoint lists, I just don't have any experience, but I'm sure I'll learn.

Advice?

chuckcoleman is offline   Reply With Quote
Old 04-12-2019, 04:07 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 889 Times in 872 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Updates to front-end and impact with SharePoint tables

Hi. You should be fine. Access syncs the data at a regular interval. You can also force a sync manually by right clicking on a linked list and selecting Refresh all Lists.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 04-12-2019, 04:11 AM   #3
chuckcoleman
Newly Registered User
 
Join Date: Aug 2010
Location: Chicago Illinois suburb
Posts: 195
Thanks: 9
Thanked 7 Times in 3 Posts
chuckcoleman is on a distinguished road
Re: Updates to front-end and impact with SharePoint tables

Hey, theDBguy,

I just want to make sure when I give the client a new front-end with, not sure what they are but I'll call them hidden SharePoint tables, the local/front-end tables will be out of date with the SharePoint tables and I want to make sure the SharePoint tables aren't overwritten with old data.

Your thoughts?

Also, do you know where there is some documentation on using Access with SharePoint lists that addresses things like this?

I always appreciate your help.

Chuck

chuckcoleman is offline   Reply With Quote
Old 04-12-2019, 04:25 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,662
Thanks: 38
Thanked 889 Times in 872 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Updates to front-end and impact with SharePoint tables

Hi Chuck. As I was saying earlier, you should be fine. The first thing Access should do when you open the FE is connect to SP and sync the data. I recommend you manually refresh the data just before you deploy it to your users. I’ll to post any links on the subject when I get in the office later.

Sent from phone...

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Front-end updater on SharePoint Online? CNorway General 3 05-24-2018 11:57 AM
database front-end on your pc back-end in sharepoint chris1976 General 9 02-22-2017 04:21 AM
[SOLVED] best way to deploy a Front- End , Sharepoint is backend scopes456 Theory and practice of database design 1 11-18-2015 12:13 AM
[SOLVED] Front end updates and distribution to users bugleboy General 13 01-30-2014 09:33 AM




All times are GMT -8. The time now is 02:08 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World