Sorry for not blogging lately (as is if anyone actually comes here – actually quite a few do). I have been busy, busy on a project in Europe while working evenings back in North America. I actually like this double-time working but it kinda means I have zero family life (except through the magic of Skype). It looks like I will be here until the end of August then it’ll be home to my 2 cats, 2 dogs, 2 Grandkids, Son, Wife at home and to a soon to be born new Grandbaby at Daughter and Son-In-Law’s house.
But why am I doing this to myself? Greed mostly :-). But also it’s an opportunity to do a major project using Access 2010, SharePoint 2010 and Access Services. And it’s going very well on all fronts.
The first thing I have to point out is that this is a perfect Access Services application:
- The Project involves a large number of related tables but not a huge amount of data. It’s a classic situation where a spreadsheet just can’t handle the business process (in fact multiple spreadsheets ended up being used with limited success).
- There is a small group of administrating staff who will use a Hybrid app as the core
- There will up to 50 occasional consumers who will view the data in the Browser only
I must say that this is the first time I have intensely developed Web-only Access objects in an app and I am actually enjoying it in ways I did not anticipate.
In the end it looks like the client is very pleased with what I have accomplished in the two weeks so far (a response that we Access developers understand – yes?). BUT as usual once it was shown to a VP he started talking about using the app in this other department and that other department and so on and so on and away we go again ……… It looks like I may have t learn how to “scale” and Access Services app now. But remember, if I move the data to SQL then I lose the Browser-only interface, but on the other hand I may need to do that to accommodate mu;ltiple departments.
Aaagggghhh !! At least they pay well and once I get their business figured out the project WILL move back home with me for remote development and support.
I will keep you posted on my successes and failures.
Hoping all in the Northern Hemisphere are having a great summer…. I wish I was …. but money is better than sunlight I guess.