Monday, July 13, 2009

Rad With Access

Well, been a while since I posted here, got 7 days to build a small app for a company, initially they were thinking of Excel but that was they were used to hammers so all problems are nails. So I offered to do it in Access with the caveat that it was about 14 years or so since I worked with Access last.
So I got it done, just about, there a few things I did not get around to and there have been no complaints since and they were happy with it as it stood.
The code was less than elegant in places because I worked with what I could remember and DAO I could remember but not ADO. It took a while for Access SQL and using parameter queries to come back to me so there are areas that could usefully be revisited in the application to change from using DAO recordsets to using parameter queries.
The remarkable thing is how little Access has really changed over the years, at least for basic applications of that type.

No comments:

Post a Comment

Fantasygrounds Unity: Importing an NPC from a text stat block.

  Fantasygrounds has been my primary VTT of choice for many years now. For most of that time I have been running games using official WoTC ...