In addition to a thorough discussion on SQL Server security vs. Access security, data conversion, upsizing, etc., the book covers the differences among MDWs, MDEs, ADPs and ADEs beautifully and it addresses scenarios for when to use stored procedures, server functions, views, etc and with great attention to detail. The chapters ADO vs. DAO and on T-SQL are well written too. Later the book even goes into simplifying building multi-tier apps with Access as front end, VB-based COM+ components in the middle and of course, SQL Server sitting in the back. And just when you think the last chapter will be a letdown as many last chapters are, it wows you with an incredible amount of insight into how to optimize, backup and perform other settings in SQL Server.
If you are a serious Access developer like me, and are timid about moving full force into SQL Server, then this is the book for you! I recommend it highly!
Covers Access 97, 2000, 2002, and 2003
Microsoft Access is the most popular desktop database in the world today and its very popularity means that its security measures can be easily compromised. Real World Microsoft Access Database Protection and Security takes a different approach than all the other Access books in the market by focusing from the start on all the issues that will help protect your database. It approaches protection and security from a task-by-task perspective and provides details that when put together will make your database more secure.
This book will help you to keep your staff from looking at your salary tables, stop your customers from looking at the design of your software that you distribute, and help you decide which security options are worth doing and which are generally a waste of your time.p>
Garry writes from a very experienced developer's point of view and he discusses in detail how to program all types of security issues including hiding tables as system tables, producing databases that password cracker software cannot easily crack, backing-up databases, menus, queries, and even user surveillance.
Real World Microsoft Access Database Protection and Security has an IT manager's overview on all topics so that managers can assess the risk of different strategies. Where the topics are at an administrator's level, the book provides a visual step-by-step guide to implementing and undoing the settings.
One Amazon.com reader says...
"This book is exactly what it proports to be. It covers all the Access versions being used in the development world - 97 to 2003. It does not spend half to 2/3 of the book on basic Access tables, querries, reports or vb code that developers already know, but from the first page to the last covers security and protection. A must have for any Access developer or power user."
Customer Reviews:
Excellent Resource.......2007-02-28
Gary Robinson is a master at Access security and this book proves it! This is one of the books that stays on the shelf close to me when I am developing. It has great resources for setting up different types of security and he provides forms and code to help you develop security based on your needs. I highly recommend this for developers, especially those who are just designing more complex databases and need a good background on security. He is such a great resource that I subscribe to his newsletter now! I can only hope that he writes another book soon! A+
Real Security for Access.......2007-01-04
All of the other reviews pretty much say it all, but I wanted to place a more recent review in the list. Although I have just started using some of the basics Gary clearly discusses, I am anxious to get to the rest. Being able to secure Access has always been in the back of my mind. Now I know I can tackle the issue and get it done in a consistent manner that I can carry into all my Access projects. Thanks for the good work Garry.
MS Access Database Workgroup Security........2006-05-10
A good book will find the reader. I would like to thank Mr. Robinson for a well written read. Besides all the other things I have in my life to do I was able to finish his work in about two weeks. I have read all the other reviews; there is nothing I can add. I can however tell you that if you are into Access database (and you know if you are) then this book is an imperative. I have had many books on Access database pass my way, nothing compares with Mr. Robinsons' book on security and protection.
Mr. Robinsons' is the first technical book on Access I have ever read from cover to cover with a never ending want to turn the page to see what Mr. Robinson was going to teach me next. I'm going to begin a reread of his work and this time I'm going to use the examples with both Northwind and my own database to incorporate his methods; especially enjoying combining the OS and workgroup security to provide my data a secure base from my clients, friends and enemies.
His book provided me ample margin to take copious notes along with my read, it will prove helpful in preparing for deployment. Mr. Robinson is a professional database administrator and this book is written as from such, you will think like he does at the end of this read and be the better for it. Mr. Robinson is a wonderful dbase admin, author, and now teacher. Again many thanks for his efforts and a heartfelt appreciation for my newly gained knowledge. Should Mr. Robinson ever have a worldwide tour on the subject, sign me up.
All of the reviews are positive, I suggest a review of Mr. Robinsons' Table of Contents and more important, the wonderful Index. A review of these documents will give you better insight into the level of Access database security Mr. Robinson clearly and distinctly explains. Mr. Robinson has the world's attention on this security subject and rightfully deserves it.
The Table of Contents and Index may be found at:
View the table of contents (http://www.vb123.com/get/AccessSecurityBook_TOC.pdf)in PDF format.
View the index file (http://www.vb123.com/get/mapindex.pdf) in PDF format.
Tom Pickett
May 9, 2006
Berea, South Carolina USA
Excellent Resource for MS Access Security.......2005-12-21
This has got to be the best MS Access resource book that I have purchased. Like others, I have found MS Access security hard to understand but with Gary Robinson's help I am now getting a grasp on how I can keep sensitive data secure. The book is aimed at those who are new to security as well as those with experience. Also, the downloable database, with forms and code that you can easily use in your own applications, is a real time saver.
I especially like how he has broken down the overview for each chapter with segments aimed at Developers, DBA's and the IT Managers. In these overviews he explains what in the chapter is important to the reader by their role. The book is arranged so you can easily locate the information you need and not have to go through the whole book to be able to accomplish your security goal. But I recommend that you do read the entire book as it has so much to offer! I am on my second read through.
Definitely the best book for MS Access Security.......2005-10-28
This is the perfect book for MS Access Security since it caters to all levels of users and is extremely easy to follow.
In addition, the author is extremely responsive to any items needing additional clarification. In fact, I actually e-mailed Gary a question and he responded back to me with a solution within the same day.
This book is a must buy for customers interested in MS Access Security.
Book Description
Announcing an all-new Self-Paced Training Kit designed to helpmaximize your performance on 70-442, one of the required exams for theMicrosoft Certified IT Professional (MCITP) Database Developercertification. This 2-in-1 kit includes the official Microsoft study guide,plus practice tests on CD to help you assess your skills. It comes packedwith the tools and features exam candidates want most--including in-depth,self-paced training based on final exam content; rigorous,objective-by-objective review; exam tips from expert, exam-certifiedauthors; and customizable testing options. It also provides real-worldscenarios, case study examples, and troubleshooting labs for skills andexpertise that you can apply to the job.Work at your own pace through the lessons and lab exercises. Focusing ondesigning and implementing database solutions in a professional job role,this official study guide covers topics such as designing data accesstechnologies, writing and modifying queries, validating input data andhandling errors, developing a transaction strategy, and optimizingperformance.Then assess yourself using 200+ practice questions on the CD, featuringmultiple, customizable testing options designed to meet your specificneeds. Choose timed or untimed testing mode, generate random tests, orfocus on discrete objectives or chapters. You get detailed explanations forright and wrong answers--including pointers back to the book for furtherstudy. You also get an evaluation version of Microsoft SQL Server 2005software and an exam discount voucher--making this kit an exceptional valueand a great career investment.
Customer Reviews:
Much More Than a Practice for the Test Book.......2007-05-30
This book is the training manual for taking Microsofts 70-442 certification examination on SQL Server 2005. And like other training manuals, it gives an excellent introduction to the exam and provides the information that you'll need to pass the test. It includes sample tests, a time limited version of SQL Server 2005 to help with the examples, all the usual things.
This book, however, goes beyond the normal cram for an exam book in that it provides descriptions and explanations that go well beyond what will be asked on the test. This provides a basic understanding of SQL Server that goes well beyond what will be asked on the test.
For instance Appendix B runs for 70 pages and covers the internal architecture of the SQL Server product with special notes as to its operation on the new multi core CPUs, the use of CLR programming techniques (part of the .NET environment) and a lot more.
This is a book aimed at the expert. The SQL code examples are way above the trivial level. You may find that you'll need another book on SQL programming for the 2005 product to help explain what this book is covering fairly briefly.
Customer Reviews:
An "okay" book but it has numerous errors.......2004-11-01
The pace is very slow for the really basic stuff while more sophisticated techniques, such as correlated sub-queries, are not explained well enough.
There are numerous errors in the book which suggest the authors don't really know Microsoft Access. Clearly, some of the worked problems were only tried on paper and not through Access itself. Significant errors appear in the discussion of data types (pp. 58 - 81), joins (p. 105), calculations with dates (p. 145), null constraints (p. 282) and referential integrity (p. 288). The downloadable example database does not comply with modern database design protocols.
For a much better book, try "SQL Queries for Mere Mortals" by Hernandez & Viescas.
Excellent book to use to TEACH SQL (using Access).......2003-12-15
This is an excellent book to use to teach students SQL in a very inexpensive way -- using Access. Although the book may not be in-depth enough for professionals, the authors do a great job of presenting the material in a very user friendly and systematic way for beginner students.
Use only if desperate to find an SQL book for Access.......2003-11-27
I know the pickings are slim for finding a book to learn SQL using Access, but PLEASE can't someone who knows how to teach and cares about getting their information correct write one? First off, this book has many errors including some statements that work OPPOSITE to the statements. Ex: On page 105 the description for "Nested LEFT and RIGHT OUTER JOINs" reads "In Access, A LEFT JOIN or a RIGHT JOIN can be nested inside an INNER JOIN, but an INNER JOIN cannot be nested inside a LEFT JOIN or a RIGHT JOIN." NO. NO. NO. It works in the opposite way.
The tables to be used in the book tutorials often bear no relationship at all to the fields or to the data and some of the naming produces run errors-- creating a frustrating experience for a student. This was obviously no labor of love for the authors, but a slapdash method to pump out a book. It is a crime that there was no quality assurance on this book. That alone would have caught the worst of it. For shame to all associated with its publication.
I generously gave it two stars just because it is probably better than nothing, but not much better. Again, here's a call to all of you SQL trainers out there: your market is wide open.
Book Description
Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet--but not get in over your head--and Access 2003 for Starters: The Missing Manual is the book to make it happen.
Far more than a skimpy introduction but much less daunting than a weighty tech book, Access 2003 for Starters: The Missing Manual demystifies databases and explains how to design and create them with ease. It delivers everything you need--and nothing you don't--to use Access right away. It's your expert guide to the Access features that are most vital and most useful, and it's your trusted advisor on the more in-depth features that are best saved for developers and programmers.
Access is sophisticated and powerful enough for professional developers but easy and practical enough for everyday users like you. This Missing Manual explains all the major features of Access 2003, including designing and creating databases, organizing and filtering information, and generating effective forms and reports.
Bestselling authors, database designers, and programmers Scott Palmer, Ph.D., and Kate Chase are your guides for putting the world's most popular desktop data management program to work. Their clear explanations, step-by-step instructions, plenty of illustrations, and timesaving advice help you get up to speed quickly and painlessly.
Whether you're just starting out or you know you've been avoiding aspects of the program and missing out on much of what it can do, this friendly, witty book will gently immerse you in Microsoft Access. Keep it handy, as you'll undoubtedly refer to it again and again.
Customer Reviews:
VERY WORTHWHILE.......2006-08-03
If you are new to Access and want to learn how to do things, this book is very helpful. If you are an experienced user and want to become an expert, this book may not have everything you need. We use this manual in conjunction with the Video Professor and between the two, we are now very comfortable with Access.
Wow - exactly what it says!.......2006-04-06
I own a Network Consulting firm which handles IT for Small to Medium businesses. That said, I know zilch about Microsoft Access. Recently a client asked I provide them with a simple inventory managment database. While I actually set them up with an out of box solution, I figured I should learn Access to possibly do our own development.
This book is really fantastic. I own plenty of tech books; some good, and some not so good. I rated this book high for the two things it does really well:
1. It shows you a nice view of what you *can* do in terms of options at each stage of building/working with a database, and explains them.
2. It applies the information with easy to follow, yet not stupidly simple projects.
I went through 130 pages today alone and if the wife wasn't bugging me to death, would probably knock out a chapter or two more before bed.
Great book. The title explains it all.
Great Way To Learn Access.......2005-12-30
The Pogue Press line does it again!! When I looked down at the retail price for this book I couldn't believe my eyes. If you are new to Microsoft Access and want to ramp up quickly on how to use this exciting application, you would be hard-pressed to find a better bargain to get up to speed in no time.
I usually write longer reviews, but for the price that this book is listed at, this would inefficient and a waste of time. If you want to learn how to use Access 2003, stop reading and pick up this book today!!
***** HIGHLY RECOMMENDED
Book Description
This book unlocks the power of Structured Query Language in Microsoft Access. It guides the reader through step-by=step realistic examples of creating databases in Microsoft Access, using SQL script to create table, adding records to tables and retrieving and managing records.
Customer Reviews:
Excellent Access Primer.......2007-09-23
This book is an excellent primer for the SQL novice. It is well organized and offers an excellent exposition of Microsoft's version of the SQL language. There is just on big problem; it is just about impossible to download the book's companion file offered on the Wordware site. This problem is a serious flaw in an otherwise outstanding book.
Another Excellent Amazon Transaction.......2006-11-10
As promised. Easy transaction. This Book is not easily found in bookstores. I saved the price of the book in gas alone!
Book Description
As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly. This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features. A smart collection of insider tips and tricks, Access Hacks covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to:
- work with Access in multi-user environments
- utilize SQL queries
- work with external data and programs
- integrate Access with third-party products
Just imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else. Part of O'Reilly's best-selling Hacks series, Access Hacks is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.
Customer Reviews:
Access Hacks - Rocks!.......2006-11-04
I've only had this book a short time and have found more useful tips in this short book than in most of my other reference books. If you are proficient in Access, This is a must have!
Not bad, but one of the weaker ones.......2006-10-07
I've enjoyed several other Hacks titles - Excel and Word particularly. This one is not quite the same; it's like a combination of interface and SQL hacks. Granted, there are many useful tips and ideas for code - not always bulletproof as another user mentioned, but if you know what to do you'll be able to apply these ideas.
A lot of SQL-based hacks are self-evident to someone who has a solid SQL background; some interface features (such as user system tables, etc) are interesting ideas, but one might wish there were more of them. For instance, there are at least three examples of UNION statement in a query to concatenate SELECT statements... one would think this could be fitted into a single hack.
Most of the form hacks assume that bound forms are being used, so if you populate controls programmatically (DAO or ADO recordsets) much of this won't be applicable. Form design is an important topic, but very few control properties are covered. Multi-user section is pretty pointless - if you work with multi-user access applications, you probably already know most of this.
Certain hacks are duplicated; for instance, the one regarding "cleaner criteria" has basically two identical hacks back to back. Besides that and the UNION statement, there are a few other redundant hacks, retold by different authors.
On the bright side, there are several good ideas, or at least interesting ones that open some doors to making your own hacks. There are some user-interface ideas that are valuable (like the one that highlights the active control). All in all, I do read this book, but use only about 20-30% of it, of which a good deal I either knew already or could figure out on my own.
Poor quality control.......2005-12-26
I rate this two stars, rather than one, because it's likely that most people will find something in the book which will put them onto a new way of doing something.
Unfortunately, the book (which includes "hacks" from seven contributors, as well as the principal author) is wildly uneven in quality. The poor quality varies from the text (it is noted that hack #9 is not an "eloquent" way of handling the problem) to the solutions presented. For instance, the example code in hack #22 turns off warnings -- but then never turns them back on, which could be rather disastrous (not to mention that any code which sets warnings FALSE absolutely needs an error handling routine which ensures these are turned back on). Hack #74, rated medium hard, introduces domain aggregate functions (DSum, DLookup, etc.), but the example code doesn't protect against situations when nothing matches the Where criteria -- so the example code will blow up if the DSum function returns NULL and tries to assign that to the Single variable. Examples relying implicitly on unnormalized tables abound. Would it have been so hard to think up examples that actually used normalized tables? Hack #19, rated medium hard, provides code to move through an overly-long form relying on SendKeys (!) to simulate PageUp and PageDown key presses. Rather than insert page breaks on the form and buttons relying on SendKeys on maneuver between these, why not just transform the long form into tabs on a tab control?
The above is illustrative, rather than an exhaustive list of hacks that are trivial, dumb or even dangerous. While there certainly are some hacks in the book which gave me food for thought, problems like the above which I could detect in other hacks made me wonder what I'll find out the hard way as I try to actually use these new ideas.
OK, But not breaking news..........2005-09-24
If you're new to Access/VBA development, this book will be a good reference. If you've been developing Access apps for a few years, there's not much in here you haven't already figured out for yourself.
Grab bag of handy tips and tricks.......2005-06-26
This is a fine set of 100 tips and tricks that will help you get the most out of Access. It's a good combination of simple tricks, and more advanced coding hacks. Involving everything for networks, to XML, to data crunching ideas. Even if you don't find exactly what you are looking for in terms of a solution you will benefit from seeing how the author approaches the problems.
Look through the table of contents, if you find ten or twenty that are in your areas of Access pain then
Book Description
When an application is part of the Microsoft Office suite, it's sure to be a leader in its field. In the realm of desktop database management, Access is top dog with millions of users. But this is one dog that can bite. Although Access is a powerful, relational tool with the fetching talents of a Labrador, it's not an easy beast to train.
Still, millions of users count on Access for everything from managing parts databases to running Web catalogs to working as a front end to mondo SQL databases. But Access is chockablock with annoyances---report hassles, query conundrums, VBA bugs, arcane error messages, and more.
O'Reilly's Annoyances series offer real-world help, right now, and Fixing Access Annoyances continues tradition. You'll not only squash bugs and workaround Access' limits, but you'll learn how to use Access to the max, whether you're a newbie or a seasoned pro. Coverage includes install/configuration annoyances, building better tables and queries, creating forms that work right, generating reliable and sophisticated reports, pulling in data from a variety of sources, crafting macros and VBA code to customize Access, and much more.
You could grab those other books for help, but do they solve problems from page one? Meet a book of a different stripe. The authors come armed with knowledge of the program's quirks, design hurdles and interface snags. They provide you with battle plans in Fixing Access Annoyances to save you time and bouts of hair pulling.
Stop information from spiraling out of control when working with Access and trying to make this #$@@#$ thing work! Don't let its quirks, bugs, and troublemaking features beat you. Who you gonna call for help? Instead of waiting on the line for tech support or searching for the answer on the Internet with its too many resources to find exactly what you need, take control of databases with Fixing Access Annoyances, your partner on database adventures.
Customer Reviews:
Good for a beginner, nothing new for experienced users.......2006-06-30
I wish I had this book when I began programming Access, it would have saved me a lot of frustration. The writing is easy to follow and it contains a wealth of information I had to either learn through trial and error or lots of searching google groups.
That said, there isn't much of value here for someone with a couple of years Access experience--you've already learned this stuff through trial and error or searching google groups!
I only found one piece of incorrect information--it is possible to create page headers on a subreport by creating a dummy grouping level (=1) and putting your headers there. The book says the only way to do it is by putting the headers on the parent report.
Troubleshoot Access 101.......2006-04-28
Wow what a great idea for a book series!!
I thought I had seen it all, but then when I picked up my first "Annoyances" book I learned there was a whole new niche out there that had yet to be exploited.
For many of us out there, we pick up technical books for a few typical reasons: to learn a new skill or a reference for an existing skill. What about if you already use an application and there is a whole known set of pitfalls and problem areas that you either need to find a workaround for, or you just want to learn about so if the need arises, you know how to deal with these?
Well, enter the "Annoyances" line of books.
'Access Annoyances' by Phil Mitchell is a great companion book for anyone that has a lot of Access books on the shelf or uses Access on a daily basis and needs to read up more on the problems that will be seen at some point. With a layout that takes each problem one at a time, the flow is very good, and the writing style is clear and concise. Unless you are the MOST experienced of Access users/developers, you will be able to pick up something from this book, and it's more likely that you'll pick up a LOT of things.
Some of the O'Reilly prices on books blow me away because they are so low. It's like you are paying x amount and getting xxxxxx in return. If you use Access on a daily basis, you owe it to yourself to pick up a copy of 'Access Annoyances' right away.
***** HIGHEST POSSIBLE RECOMMENDATION
Should be the second book you buy after a reference manual..........2006-03-16
I consider myself fortunate that I converted my last regularly used database off of Access awhile back. While the software served me well in learning about database systems when I first made the move to PCs, I always found myself fighting with things that should have been easier than they were. Now I find out that it wasn't just me. Phil Mitchell and Evan Callahan have put together a great book titled Fixing Access Annoyances. If you spend any time in Access, this ought to be on your bookshelf.
Contents: Access Basics; General Annoyances; Performance, Versions, Security, and Deployment; Data, Tables, and Database Design; Queries; Forms; Reports, Mailing Labels, and Charts; Expressions, Macros, Code Modules, and Custom Controls; Appendix; Glossary; Index
The Annoyances series is set up in such a way that each chapter covers a series of "questions" posed as to why a particular software package behaves in a certain way. The questions range from minor "why does Access always do x" to "my #$@%@ database is corrupted!", and the conversational tone between the questioner and the authors is fun to read. After reading some of these things, you wonder why *anyone* would use Access! Mitchell and Callahan, although experts in Access, maintain a healthy cynicism towards the product's features and foibles, and all it would take is for you to find three to five annoyances that bug you to no end in order for you to think this is the best money you've spent in a long time. They also try and cover a range of things, from beginner to advanced level gripes, so that you should see value wherever you are in the continuum of Access experience.
If I had this book available to me a year ago, I might still be running my reading log database in Access instead of in Notes. I certainly would have experienced far less frustration than I did. After making sure you have a solid Access reference guide on your shelf, this should be your second purchase on the subject...
Books:
- Advanced VBScript for Microsoft Windows Administrators (Pro Other)
- Ajax For Dummies (For Dummies (Computer/Tech))
- Approximation Algorithms
- Artificial Vision for Mobile Robots
- Beginning C ++ Through Game Programming, Second Edition
- Building Automated Trading Systems: With an Introduction to Visual C++.NET 2005 (Financial Market Technology)
- Building Your Business with Google For Dummies
- C# Language Pocket Reference
- CCNP BCMSN Official Exam Certification Guide (4th Edition) (Exam Certification Guide)
- Cisco LAN Switching (CCIE Professional Development series) (CCIE Professional Development)
Books Index
Books Home
Recommended Books
- Introduction to the Mathematical and Statistical Foundations of Econometrics
- History: Fiction or Science
- Accounting: A Direct Approach
- Command & Conquer: Tiberian Sun: Prima's Official Strategy Guide
- Dictionary of Accounting Terms
- In the Company of Cheerful Ladies
- Facing the Lion: Growing Up Maasai on the African Savanna
- Glencoe Computerized Accounting: Student Edition DOS 7.0
- Bottom-Line Training: How to Design and Implement Successful Programs That Boost Profits
- Chill of Fear
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Access Database Design & Programming (3rd Edition)
Integrating Excel and Access
Building Microsoft Access Applications (Bpg Other)
Access Hacks: Tips & Tools for Wrangling Your Data (Hacks)
Programming Microsoft Office Access 2003 (Core Reference)
