Results 1 to 13 of 13
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Clueless on how to get Data (2002)

    Hi,

    I've got a web that has 4 Access Databases that gather data from the pages they are linked to. Presntly in order to get any data, I copy the databases from the web back to my computer, open them and get the data. I know there has to be a simpler way but I can't figure it out. My goal would be to have button that the owner of the web can click that would open a password protected page that contains links to the database and will provide them with a reports. I don't know where to begin. I can create the reports in Access without any problem, but how do I access them from FP?

    Thanks,
    Leesha

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Clueless on how to get Data (2002)

    All the reports I generate on the server are laid out using ASP/VBScript. There might be a way to more easily convert Access reports to something that can run on the server, I just don't know what that would be.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Is there a good resource book on HTML and ASP?

    Thanks!
    Leesha

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    It might help if you explain exactly what you're trying to accomplish. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> "The owner of the web"?? Are you talking about a web page, and internet site, an intranet site, a hosting service or what? Are you trying to present reports on the web? If so, they have to be built in something other than Access.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Hi Charlotte,

    Sorry about the confusion. By owner, I mean the group that I built the website for. It is a physical therapy business that provides various educational programs, therapeutic horseback riding, and other services. Each service has its own page with an area at the bottom for the viewer to request more information, make comments, etc. That information is sotred in individual Access database that are linked to the page. I need to find / learn the easiest way for them to be able to obtain the inquireis made via the website. I also need that part to be private, something only they can do, vs anyone who is viewing the website who may try to view the reports / information.

    I hope that makes more sense.

    Leesha

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Hi Leesha

    I'll put on my database head and my web head for this question. The connection of Access databases to websites is fraught with difficulty and for anybody with a will and a way can find access to data from an Access database. I tried a simple guest book the other month and it was hacked within a few days.

    The database will preferably be kept on the same IIS server as the website unless you can create virtual directories that go to another. Having Access databases connected to a page will mean you will have to place a GUI security layer maybe in the form of javascript authentication at the thin end to prevent bots hacking it.

    If you are to create a back end database, I would sugest you create a static database which is used to provide information one way and create webforms that send emails to the various back office users who can react and send information back to the citizen user.

    This is quite a heady area you are walking into here....I reckon this is too much for a technical forum to do without knowing the deeper technical and functional specification. Saying that Access does create Pages accessible for the web which provides drill down functionality.
    Jerry

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Hi Jerry,

    And to think that since I have a decent understanding of Access, I thought this would be the "easier" way to go. Your post validates the growing conclusion I've been coming to which is that this is way out of my reach AND more work than it is worth. With that being said, what is the easiest and most concise way to gather information on the website and then for the company to obtain the data?

    Thanks,
    Leesha

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Hi Leesha

    I am hazarding a guess but your company appears to be within the small to medium range (guessing from the type).

    We use eforms to collect data. The beauty of eforms is that the citizen user is interacting with the web interface and does not necessarily need to know "how" the data is sent or how it is directed. We have a mixture some is sent in the form of an email ( simple request for information). I run a Customer Relationship Management and the customer portal runs directly to my app server.

    I would go for a mixture, use you Access database skills to deploy one way (db to web only) information about services, or provide a simple search for services. From the individual service pages create an eform where the citizen requests information and the service provide can react and respond with the various items of quotes or literature.

    A lot of my time these days is spent trying to get the business to move away from the idea of overplaying automation (although it has its uses) and try and bring back the requirement for the human to interplay with the IT transaction. So build the business process and citizen interaction and then build you IT requirement...
    Jerry

  9. #9
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    Hi Jerry,

    Yes it is a small company. The purpose of gathering information in a database format is also to store data for future mailings of their classes etc. Thus why I have them using Access for the data collection.

    I'm pretty confused at this point which I'm sure is obvious. I guess my question at this point is whether I should even be using Frontpage?

  10. #10
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I hate Frontpage

    That is my opinion as microsoft HTML sucks....I spent hours last week having to recode a pile of HTML pages generated in MS format because it crashed my sytem. Our guys do it in ASP.NET, which has better methods of security and data driven processes..........but that is a very large and steep learning curve, I bought the book and got to page 153 and then decided I had other priorities to learn <img src=/S/hiding.gif border=0 alt=hiding width=70 height=24> <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Jerry

  11. #11
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clueless on how to get Data (2002)

    LOL! Well I appreciate your honesty. For a newbie at this, building the site was relatively easy, but now.........................OMG. I looked at ASP.net but it was way out of my league. It's not in my time factore at this point. I guess I'll keep struggling with this for a bit.

    Thanks!

  12. #12
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clueless on how to get Data (2002)

    You might want to check out DotNetNuke, although it would require porting your existing website to a new platform. Still, much easier than trying to learn ASP.net on your own...
    -Mark

  13. #13
    4 Star Lounger
    Join Date
    Mar 2004
    Location
    Griffith, New South Wales, Australia
    Posts
    507
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clueless on how to get Data (2002)

    URL corrected by HansV

    Microsoft have just released their beginner's guide to programming site.

    I am going to give this "eight grade" approach a go and see if I can get past Jezza's page 153!!

Posting Permissions

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