Every few months, the Microsoft Access engineering team receives a high priority e-mail from someone in our worldwide sales org. It’s always the same root issue: an IT department is frustrated with the proliferation of Access databases and the manageability headaches that ensue. Recently, we talked with the CTO of a British company who compared databases to feral cats wreaking havoc on his organization’s work.
We find that this focus on manageability is nearly universal among customers we talk to, both large and small. Organizations want to empower users in business units to do self-serve development of apps that improve efficiency and reduce costs. But empowerment creates headaches. Data must be secured so that only the right people can access it. It must be backed up so that hardware failure is minimally disruptive. And there must only be one copy of the data, so that all parts of the organization make consistent decisions.
This release, we have a number of exciting things to announce about managing databases with Access. First, let’s talk about some new tools for managing desktop databases:
- Microsoft Office 2013 Discovery and Risk Assessment allows you to scan an organization’s network shares and SharePoint document libraries to find Access databases. You can scan on demand or on a routine basis, and incorporate the discovery results into a master inventory. Once files are inventoried, they can be evaluated for complexity, financial impact, risk, and errors. Check it out here.
- Microsoft Office 2013 Audit and Control Management Server contains a set of database management tools that allow you to audit databases and understand the changes being made to them. Check out the tools here.
You might also like
Managing Databasesby openshoppc
Although all the database administrative options can be done through PHP scripts, I strongly suggest installing a copy of PHPMyAdmin on your server. It is an excellent free set of scripts that will provide you with an administrative interface for your MySQL database(s). You can add, remove, edit, backup and view your databases using this and it is especially useful when troubleshooting your databases.
Two things.by Durable
One: I have minimalist tendencies, so not relying on unseen farmers is a comforting thought.
Two: Competence is sexy! The garden produced. It produced ORGANICALLY.
let me repeat... Competence is sexy!
I don't care if it's gardening, or managing databases, or laying asphalt or cleaning the house. If you do it well, and especially if I can see the results, that's zexy!
ZEXY! I say. I proclaim it to the world. Let me gaze upon your work products people. ;-)
Database Marketing: Analyzing and Managing Customers (International Series in Quantitative Marketing)
Shielding names of police, prosecutors in online tax records divides lawmakers — WRAL.com
Paul Stam, R-Wake, said counties would spend millions of dollars managing databases where some names were out in the open and others weren't. "This idea that you can have two different sets of records electronically – one at the courthouse and the ..
Managing and Mining Graph Data (Advances in Database Systems)
Microsoft Access 2010 Quick Reference Guide - Learning Access Part 5: Creating, Managing & Using Database Macros (301)
Single Detail Page Misc (EC Technologies)
Managing and Using MySQL (2nd Edition)
Book (O'Reilly Media)
Oracle 11g(1Z0-052) Exam Free
Mobile Application (4C Infotech)