Results 1 to 12 of 12

Access 2007 form needs to be able to data entry from the web

  1. #1
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6

    Access 2007 form needs to be able to data entry from the web


    Without any backend server, how can I create a data entry from for users to enter from any web browser? Some of my research says it cannot be done in this version, other research says to open Objects>Pages, and 2007 doesn't have this option. We have multiple versions of Access on our network, so need the earliest version to have this capability.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,664
    Are you talking about using the public Internet or just your local LAN?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    42,638
    Don't know what you mean by "open Objects>Pages". Only thing I can find refers to asp.net coding web pages. Review https://msdn.microsoft.com/en-us/library/6c3yckfw.aspx

    How do you network?
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  4. #4
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6
    We'd like to keep it on the Local LAN. Here's instructions I found, but I don't have the options in Access 2007 noted:
    1. Open your file in Access. Click the Navigation Pane on the left side of the window to open a list
    of the database components.
    2. Click the arrow next to "All Access Objects" to open a drop-down menu. Click the type of
    Access object that you want to convert; for example, select "Tables" to make a Web page from table data.
    3. Right-click the component that you want to convert to a Web page.
    4. Click "Export."
    5. Click "HTML Document" to open the "Export - HTML Document" dialog box.6. Click "Browse" and then navigate to a location to save the Web page.
    7. Click "OK" to create the Web page.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,664
    I'm not sure about a browser application as MS has deprecated that feature. On your local LAN you can make a shared application in MS Access that anyone on the LAN with MS Access could use for data entry.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  6. #6
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6
    We have a domain, if that is what you mean by your question: How do you network?

  7. #7
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6
    That answers most of my research where I came up with the same answer...no longer available with Access 2007. Not all users will have MS Access, so if that is a requirement, we will have to purchase several more licenses, and 2016 Home and Business do not come with Access, I will have to research whether it is available as a stand alone product now.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,664
    Several versions of access included a free runtime version. I believe ac2007 was one of them.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,664
    Here's a couple of links on implementing a successful Multi-User MS Access system:

    http://www.accessmvp.com/TWickerath/.../multiuser.htm
    http://www.fmsinc.com/microsoftaccess/databasesplitter/
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  10. #10
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6
    Thanks, I had started working on the database splitter, but your link is much more detailed! However, it appears it still will not allow the use of data entry without the program on the local machine. Or am I not thoroughly understanding the information?
    "With a split database design, you'll need to distribute the front-end database to each user. By residing on their local machine, the performance of your application will improve. However, this adds an extra level of complexity when your application changes."

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    42,638
    As RuralGuy noted, MS provides a freebie Access run-time app for users who don't have full Access app. I've never used it but my understanding is this allows data input but not design capabilities. Even install it for users with older Access and everyone can run the latest version of your db.

    Thanks for the clarification on creating pages. I've never built a web db.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  12. #12
    AccessWebpage is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    6
    I think you've steered me down the only path I have. Thanks. Closing the thread.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-09-2014, 06:16 PM
  2. Replies: 7
    Last Post: 02-08-2014, 11:31 AM
  3. Replies: 1
    Last Post: 10-28-2012, 01:54 PM
  4. Replies: 2
    Last Post: 05-11-2011, 08:06 AM
  5. Simultaneous Data Entry for Access 2007
    By matt.smith in forum Access
    Replies: 1
    Last Post: 05-27-2010, 02:22 PM

Posting Permissions

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