Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have been working on building a database for the local Kiwanis Club. In Access 2003 (2000 format).

    The club has a website. The secretary would like to be able to build something that would pull information from the Access database and place it on the website. The members would be able to go on the site, click on a link to a particular member, and then download data about that particular member. This would include…in addition to the name… the address, business, the member’s status in the club, when joined, etc.

    The link to the member would include a small thumbnail picture, to help newer members make the identification between names and faces. This photo could be embedded in the database, I suppose, but since Access works with bitmap images, this would increase the size of the database substantially I believe.

    Can anyone suggest the best way to go about this? I know that the website was built with Front Page, but beyond that I’m not familiar with building websites, or how to link stuff to them.

    One approach I can think of would be to do a mail merge into Word but there may be a far better solution.

    Any suggestions would be appreciated.

    Tom

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    How up-to-date should the information be? You could copy the database to the web server periodically, as well as a folder with the pictures. An ASP page could then retrieve and display data from the database, and use the path/filename of the picture to create an image link.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='THWatson' post='789670' date='18-Aug-2009 19:46']... Can anyone suggest the best way to go about this? I know that the website was built with Front Page, but beyond that I’m not familiar with building websites, or how to link stuff to them. ...[/quote]
    Depending on the version of Front Page, there are some rudimentary database capabilities that can link to an Access DB - but the DB has to be on the website server, or be able to linked to from the server. We run a rather sophisticated website that provides somewhat similar capabilities using ASP and .NET - but it was a major development project. Two concerns I would envision - the first is security - in this day and age putting personal info on a website is tantamount to giving your identity away, and second, you will have an issue keeping the web version current with the master database, and users will want to be able to submit updates to the web site. We solve issue number one by restricting the site to authorized users, and we built a complex process to allow the submission of updates from the website.
    Wendell

  4. #4
    4 Star Lounger
    Join Date
    Oct 2003
    Location
    Guelph, Ontario, Canada
    Posts
    428
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, Hans and Wendell. My concern, also, had to do with security.

    Tom

Posting Permissions

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