One less reason to open Microsoft Access... My reading log is now in Notes.
Category IBM/Lotus
About the only reason I use Microsoft Access any more is to keep my reading log updated. That's the database I've had for over nine years that lists the books I've read. I originally built it back in 1996 as a training exercise to help me learn PC software (I was just coming out of the mainframe world), and it's pretty much just moved from Access version to Access version each time I upgraded.
I figured it was about time to convert the database over to a tool that's much easier for me to modify and tweak... Notes! :-) A quick LotusScript agent allowed me to move over all the data using ODBC. I added some views to give me the type of reporting I wanted, and I was good to go. It also gave me an opportunity to fix a data design problem I made on the original database. My Author field was a single value, which really messed things up when there were multiple authors for a book. In Notes, I just made it a multi-value field, updated the records affected, and now I have the design I need for proper lists by author.
Notes is such a great tool to work with. :-)
About the only reason I use Microsoft Access any more is to keep my reading log updated. That's the database I've had for over nine years that lists the books I've read. I originally built it back in 1996 as a training exercise to help me learn PC software (I was just coming out of the mainframe world), and it's pretty much just moved from Access version to Access version each time I upgraded.
I figured it was about time to convert the database over to a tool that's much easier for me to modify and tweak... Notes! :-) A quick LotusScript agent allowed me to move over all the data using ODBC. I added some views to give me the type of reporting I wanted, and I was good to go. It also gave me an opportunity to fix a data design problem I made on the original database. My Author field was a single value, which really messed things up when there were multiple authors for a book. In Notes, I just made it a multi-value field, updated the records affected, and now I have the design I need for proper lists by author.
Notes is such a great tool to work with. :-)
| Permalink |
Comments
Posted by Duffbert At 08:18:41 On 14/03/2005 | - Website - |
1326 at last count... Every book I've read from January 1996 through the present.
Posted by Duffbert At 07:46:56 On 15/03/2005 | - Website - |
Posted by Duffbert At 14:43:57 On 15/03/2005 | - Website - |
Posted by Kitty At 04:19:09 On 22/03/2005 | - Website - |
-rich
Posted by Richard Schwartz At 22:59:48 On 14/03/2005 | - Website - |
Posted by Bud Hartley At 14:03:02 On 15/03/2005 | - Website - |
Posted by Philip Storry At 06:08:06 On 14/03/2005 | - Website - |
I sent a copy of the database to Kitty just to prove that it's not all everyone seems to think it is. If she comes back with glowing praise (which will lead me to question her taste!), then I'll consider throwing it out to OpenNTF "as is" so everyone can have at it...
Really, everyone... it's a five minute db that they'd have you do as a "hello world" app in a beginning Notes dev course...
Posted by Duffbert At 07:58:39 On 22/03/2005 | - Website - |
Posted by Gregg Eldred At 07:37:43 On 15/03/2005 | - Website - |