On Thursday 29 May 2003 4:21 pm, Jenda Krynicky wrote: > From: Bob Showalter <[EMAIL PROTECTED]> > > > Gary Stainburn wrote: > > > At the moment we have a membership database written in access on a > > > windows box. One person is responsible for keeping this up to date > > > and then distributing the updated file for others to use - e.g. for > > > mailshots. > > > > > > Now, with growing membership numbers, two people in seperate > > > locations need to update the file, and more people are needing read > > > access to it. > > > > > > Ideally, I would like to put some sort of web front end on it, > > > hosted on one of my existing web servers - running standard > > > RH7.3+errata. > > > > > > I'm not bothered how the data is stored on my server (my database of > > > choice is PostgreSQL anyway) > > > > Excellent choice! > > > > > as I'm only going to be doing simple > > > insert/updates and selects. > > > > > > The main thing I want to be able to do - if possible - is still > > > allow the file to be available as the existing .mdb so people can > > > continue to use it with existing MS Office mailing list type > > > documents. > > > > 1. There is an ODBC driver for PostgreSQL available, so the MS > > products could use an ODBC data source for the mailing list. > > > > 2. You can easily export the PostgreSQL data to a variety of formats, > > from simple text-delimited to Excel worksheets (using > > Spreadsheet::WriteExcel) that could be mailing list data sources.
This may well be work looking at. > > > > 3. You could write some code in the Access database to populate its > > table from the PostgreSQL database using ODBC. > > Another (maybe better) option is to link the PostgreSQL tables into > Access. So all views, forms, reports & script in Access may access > directly the database. > > In Access its under > File\Get External Data\Link Tables > then you just select the ODBC DSN, the tables and off you go. > > Of course this would assume all the users are able to connect to the > database via ODBC. The problem I have is that I don't know all of the users yet, nor do I know their setups. Also, I'm not too keen on the idea of an unencrypted ODBC session going over the internet. Maybe the spreadsheet option is the one I need to look at. Thanks all. Gary > > Jenda > ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== > When it comes to wine, women and song, wizards are allowed > to get drunk and croon as much as they like. > -- Terry Pratchett in Sourcery -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
