-
Be & fe
I'm relatively unfamiliar with most of Access, as well as the concept of a back end and front end. But I did some searching and had a usability question.
We're in an office where not everyone can be on the local shared drive, and even if they could it would only allow for one person to be in the database at one time. So, can I set up the BE database on sharepoint, and give everyone their own FE that links back to it online, so it's accessible anywhere?
-
First you should invest in a good textbook on the version of Access you are using; available at any big box bookstore or Amazon. A multiuser, distributed database is not something one should guess about....or rely exclusively on google....
setting up a single shared BE file at a LAN location that all can link to is the simplist, and most manageable solution. Publishing the BE into Sharepoint Lists - and linking the FEs to sharepoint is also a viable solution - assuming Sharepoint and all the FEs are on the same LAN. The advantage of the Sharepoint approach is that the data can also be used by other Sharepoint services such as InfoPath. The downside is that Sharepoint itself is a big product, generally managed by someone not having the database as their first priority.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules