Results 1 to 3 of 3
  1. #1
    Pro1981 is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2015
    Posts
    1

    Simple search for locally stored database

    What Id like to do is create a website or something similar so that other people on the network can search the database without having to load up access as some people will struggle with this.
    Ideally what I wanted was a webpage with a search facility that connected to the database, however Im unable to install anything on the computers or network.
    I'd be happy for just the text or the form to display as a result.


    As a second option is there a way I can just publish say the form so people can either enter their search criteria or select from a drop down box or even both?
    Is this something that can be easily done or have I bitten off more than I can chew?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Quote Originally Posted by Pro1981 View Post
    What Id like to do is create a website or something similar so that other people on the network can search the database without having to load up access as some people will struggle with this.
    Ideally what I wanted was a webpage with a search facility that connected to the database, however Im unable to install anything on the computers or network.
    I'd be happy for just the text or the form to display as a result.
    As a second option is there a way I can just publish say the form so people can either enter their search criteria or select from a drop down box or even both?
    Is this something that can be easily done or have I bitten off more than I can chew?
    It's not easy. I build our company database using Access (believe it or not)

    you have to make strings that have HTML within the strings - then write them to a file outside of access.

    You can use visual studio to create a web app with databases - that is what that is designed for.

    Alternatively you can use Access' built in web app. New Access document -> Web App (depending on your access version).

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What version(s) of Access do you have access to and what is the file extension of the Back End file?. The easiest thing may be to publish static data as .HTML

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

Similar Threads

  1. Creating web application locally on my computer
    By masoud_sedighy in forum Access
    Replies: 1
    Last Post: 07-08-2014, 01:39 PM
  2. Database stored on server read-only
    By GGCR in forum Access
    Replies: 2
    Last Post: 05-23-2014, 09:42 AM
  3. Replies: 8
    Last Post: 05-25-2012, 03:52 AM
  4. Replies: 1
    Last Post: 12-06-2010, 08:38 PM
  5. Change database where data is stored with a dropdown box
    By le_carrington in forum Programming
    Replies: 5
    Last Post: 11-25-2010, 11:45 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
  •  
Other Forums: Microsoft Office Forums