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

CiV VII The first 100 hours

First Impressions   I purchased Civ VII from Steam earlier this summer when it was on sale and almost immediately pulled an all-night sessio...