Export database data fields to website

[THWatson]

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

 

[dhookom]

This question really has very little to do with Access Forms. You might want to post in a web development forum such as ASP or other.

Duane
Hook'D on Access
MS Access MVP

 

[THWatson]

Duane
I understand. The reason I posted it here was that I wondered if there was a way to push data from Access onto a website.

Tom

 

[dhookom]

You can use FTP to copy your Access database to a web server and update it from a web page. You would need some procedure established to keep your local MDB and the web MDB in sync.

Duane
Hook'D on Access
MS Access MVP

 

[THWatson]

Thanks, Duane. I'll pass it on. I also have concerns about security of the data that I think the secretary needs to consider.

Tom