Results 1 to 2 of 2
  1. #1
    emccalment is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    27

    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?

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    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.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums