1 / 9

Access Services – Better than Marmite?

Access Services – Better than Marmite?. Ian Woodgate Ian.woodgate@pointbeyond.com. The Marmite Issue. I love Access because I can maintain databases myself I can distribute and share my database I can “get at” all the data Its familiar and on my desktop I hate Access because

mattox
Download Presentation

Access Services – Better than Marmite?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Services – Better than Marmite? Ian Woodgate Ian.woodgate@pointbeyond.com

  2. The Marmite Issue • I love Access because • I can maintain databases myself • I can distribute and share my database • I can “get at” all the data • Its familiar and on my desktop • I hate Access because • Users maintain databases themselves (and design badly, get stuck, or leave) • Users distribute and share the databases • The data is insecure • I have to deploy/manage Access clients and other components • It doesn’t scale well

  3. True Stories… Fred left the company on bad terms. We don’t know the password to the sales database -large utilities company Our figures don’t match theirs. We keep two copies of the database. A database was left on a train…

  4. Agenda • Building a solution from scratch • Summary – a better flavour of Access?

  5. Let’s take a look • Freedom of information requests • Simplified! • Going to use • UI Macros • Data Macros • Reports • Other goodies! • Under the bonnet

  6. A better flavour of Access? • Yes • Design can be controlled • Permissions can be controlled • Data is stored centrally and backed up (I hope) • Scalability improved • But • Need web databases (or hybrid approach) • Still need to plan security • Bad design is still supported • Users can still get stuck or leave • No way to package and deploy upgrades • Feels like v1…

  7. Review • Reasons behind the Marmite issue • Building an Access Services application • UI Macros • Data Macros • Custom Data Types • Reporting • Navigation • Publish to SharePoint • Under the bonnet • A better flavour of Access

  8. Final Thought – Composite Applications • Time and cost vs flexibility

  9. Thank You • Ian.Woodgate@pointbeyond.com • @ianwoodgate • Ask the experts session 4:40pm #SPSUKATE • User group meeting Southampton University 6:30pm Thursday www.suguk.org

More Related