+ Reply to Thread
Results 1 to 5 of 5

How to share Microsoft Access' form with external users?

  1. #1
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Question How to share Microsoft Access' form with external users?

    Objective: to create a data entry form that updates access database on the go.

    As the question states, how would I go on about doing this? How would I control whether this external user can see the DB + form, or form fill only?

    I can't seem to find direct tutorial on this. Instead I am redirected to Microsoft forms every time!

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,186

    Re: How to share Microsoft Access' form with external users?

    create a new blank db.
    export your form to this db.
    I would also export the table & query that may go with it. (with test data only)

    Now you can send the form example.

    but If you want users to actually use the form for data in/out, then do the same but instead of example data,
    use the external LINK to the actual table.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,799

    Re: How to share Microsoft Access' form with external users?

    Or use the "Split database" functionality to create a "back end" that holds all the tables and a "front end" that holds queries, forms etc. as well as links to the tables in the back end.
    A copy of the front end can be sent to each user and so long as they're networked they can use that to push/pull data to/from the back end.

    BSB

  4. #4
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Re: How to share Microsoft Access' form with external users?

    Quote Originally Posted by BadlySpelledBuoy View Post
    Or use the "Split database" functionality to create a "back end" that holds all the tables and a "front end" that holds queries, forms etc. as well as links to the tables in the back end.
    A copy of the front end can be sent to each user and so long as they're networked they can use that to push/pull data to/from the back end.

    BSB
    If the audience in non-technical, would I be able to hide queries and show only forms to make it easy for them?

  5. #5
    Forum Contributor
    Join Date
    06-20-2021
    Location
    UK
    MS-Off Ver
    2016
    Posts
    126

    Re: How to share Microsoft Access' form with external users?

    Quote Originally Posted by ranman256 View Post
    create a new blank db.
    export your form to this db.
    I would also export the table & query that may go with it. (with test data only)

    Now you can send the form example.

    but If you want users to actually use the form for data in/out, then do the same but instead of example data,
    use the external LINK to the actual table.
    External link? Like a sharepoint link?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Publish or share macros with other users
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2017, 11:44 AM
  2. Replies: 5
    Last Post: 08-12-2015, 05:45 PM
  3. Add Microsoft Access Object Library reference without installed Microsoft Access
    By nichchap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2014, 08:36 AM
  4. REG: User form with access of N number of users
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 01:19 AM
  5. Replies: 1
    Last Post: 10-24-2013, 01:24 PM
  6. How to Share Workbooks between Multiple Users?!?
    By OliveMarie in forum Excel General
    Replies: 3
    Last Post: 10-24-2012, 06:22 PM
  7. how to access an userform for multiple users with "protect and share option"
    By sivdin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2011, 03:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1