vb123.com.au                                                          

   Microsoft Access Protection and Security - Book Links

The Access Protection and Security Driving Instructions

In this chapter, I will simply discuss how I went about finding out information for this book. The resources that I used regularly for this book included

*   The help files from all the versions of Access used in the book. For Access 2000 or later, don’t forget to widen your search by also trying the help within the VBA Environment.

*   I must say that I resolved most of the really complicated and open-ended issues using Google. Of particular value with Google was the Groups tab at the Top of the page as shown in Figure 1-3. Another important thing with Google that I am sure would apply to other search engines was to include very particular words in the search. This usually means doing two searches to find the topic of information. In some cases, when I searched for particular errors, I would simply type in the error description exactly as it appeared in Access. No doubt, there will be other Googles in the future.

http://www.google.com/

*   For insight into programming workgroup security, I turned to the Access Developers Handbook -Enterprise Edition written by Litwin, Getz and Gilbert. Surprisingly my book really doesn’t include much of the detailed programming of Workgroup security demonstrated in this book as that seemed to not be as important as keeping the password crackers at bay.

Click here to find

*   As ever, my source of inspiration for Access programming is the Smart Access magazine and I have certainly learned my trade reading that magazine from cover to cover every time the convict cargo ship arrives in Australia with the mail.

http://www.pinpub.com/

*   Many of the discussions in the book were supported by the many hundreds of accurate articles, white papers and web pages posted by Microsoft on their web site about Microsoft Access. Surprisingly though, as I writing the book, I generally had better luck finding the articles using Google and restricting my search to only use the Microsoft web site.

http://www.microsoft.com/office/access/default.asp

*   This list would not be complete without a list of newsgroups where people might actually answer your Access questions.

http://www.utteraccess.com/forums/access

Microsoft Access newsgroups

Experts Exchange

Apress Forums for questions on books

Glossary of Microsoft Access terms
http://office.microsoft.com/assistance/2002/articles/idxGloss.aspx

Links Since The Book Was Published

The one stop shop for Access 2003 - according to MS
Click Here

Access Administrators Take Note - Office 2003 Service pack 1 is going to have an interesting tool that will analyze all your databases.

Read More at Microsoft

 A quote from this article

Q: What was the greatest learning from this research?

Sigler: The greatest learning we had by far was customers' surprise at how easy it is to deploy Microsoft Office 2003. Prior to that, there was a tremendous amount of fear around the process. Customers lacked information regarding the number of Microsoft Office Access databases they have in their IT environment and what kind of conversion issues they may run into. They didn't know if they could roll out Access 2003 alongside Microsoft Office 2003 without having to manually configure an individual desktop or database for conversion. In actuality, of the more than 100,000 databases we scanned for varying customers, only 1 percent required manual intervention on the desktop for conversion. Most customers expected that figure to be approximately 75 percent.

Now, the interesting thing is that most of that 1 percent is something we call MDE files. These are compiled, secured databases that cannot be converted. Instead, customers have to find the original MDB -- the source -- and convert that. Of the 1 percent of databases requiring intervention, probably 60 percent or 70 percent were MDE files.

Macro Security In Access 2003

How To Avoid An Access 2003 Sandbox Storm by Garry Robinson