Forum Discussion
Access Database Deployed to Sharepoint
This client is heading down the wrong path with this plan, and it's up to you to steer them back in a safe direction and away from SharePoint at all.
First, all production Access relational database applications need to be split before deployment. I will assume that, as an Access consultant, you know the importance of splitting the application into Front End and Back End and avoid rehearsing all of that. Mentioning SharePoint this way, though, suggests you need to be sure to explain the problem to your client.
Second, each user MUST have their own personal copy of the Front End on their own computer, regardless of where the Back End is stored. A successful Access relational database application does not allow multiple users to share a single Front End accdb.
Third, I can't imagine successfully deploying a Back End accdb to a SharePoint library. I've never heard of anyone doing so. The Back End could not be shared by simultaneous users that way, which defeats the whole purpose of putting the application in SharePoint for all users.
You could use SharePoint lists for the Back End for this Access application, but that doesn't sound like the client is thinking about that.
This client is heading down the wrong path with this plan, and it's up to you to steer them back in a safe direction and away from SharePoint at all.
First, all production Access relational database applications need to be split before deployment. I will assume that, as an Access consultant, you know the importance of splitting the application into Front End and Back End and avoid rehearsing all of that. Mentioning SharePoint this way, though, suggests you need to be sure to explain the problem to your client.
Second, each user MUST have their own personal copy of the Front End on their own computer, regardless of where the Back End is stored. A successful Access relational database application does not allow multiple users to share a single Front End accdb.
Third, I can't imagine successfully deploying a Back End accdb to a SharePoint library. I've never heard of anyone doing so. The Back End could not be shared by simultaneous users that way, which defeats the whole purpose of putting the application in SharePoint for all users.
You could use SharePoint lists for the Back End for this Access application, but that doesn't sound like the client is thinking about that.
Thank you. The customer and I are now on the same page and Sharepoint will not be a part of the solution.
