Links

Home
Monthly Meetings
Meeting Agenda
Keep Me Posted
Training
Meeting Downloads
Teresa's Restaurant
Links
Sponsors
Reviews
KB Articles and More
Hotfixes And More
Security Issues
Job Opportunities
Recommended
Bargains
Usability

Great Links -- sites have been recommended by the experts --
plus several links to Microsoft helpful pages.

SITES and HELPFUL RESOURCES
 

Database Design Forum - NEW GROUP on the MSDN Community Website (Jan 2010)
Under the SQL Server group, this forum is focused on the database design. The discussions include Access database design. Several of the authors and editors from Teresa’s upcoming book on database design are among the founding moderators and contributors to the forum; including Doug Yudovich, George Hepworth, Jerry Dennison, and me <g>. 

Cool Free Apps from Microsoft (April 2010)
SQL Server Express 2008 -- provides the essential SQL database features needed for supporting client applications and building Web sites and apps. It comes in three versions: Express, Express with Tools, and Express with Advanced Services. Based on the same database engine as SQL Server, this is an excellent option for SOHO and development. This is an excellent compliment to Access deployments, AND, it is easy purported to be easy to learn and use.

Paint.NET -- an easy to use image and photo editing program that provides the essential image editing features and even includes layers and special effects, plus it supports a wide range of image formats. 

XML Notepad 2007 -- Are you customizing the Ribbon? Perhaps you’re customizing some web apps. If so, you may find that XML Notepad 2007 fulfills your needs. The UI is a tree view pane on the left that provides a color-coded view of classes, tags, and values. This controls the color coded text editor which opens on the right -- and the colors and choose fonts are customizable. It provides user friendly features such as drag and drop, find and replace, incremental search, instant XML schema validation, a built-in XML Diff tool. Check out MSDN for more details and download the free program from

Visual Web Developer 2008 Express Edition
. A powerful, intuitive program for quickly creating Web sites or small applications geared for home users and intermediate-level developers. It’s a remarkable package that provides professional-level features --- your project can range from using basic HTML to advanced ASP.NET pages and even incorporate SQL Server databases. The introductory video gives you a quick tutorial of the main features and some of the most common tasks. Download it and let me know what you think! 

SyncToy 2.0  -- a synchronization tool to help us maintain duplicate copies of files - such as on a laptop, a desktop, network server, and external backup drives. The intuitive UI opens to a screen that prompts you to select a pair of folders which are then designated as the Left Folder and the Right Folder -- talk about user friendly! It offers five synchronization methods, and it can be used as a handy backup tool - you just have to remember to use it!

ZoomIt v4.1 --
a zoom and annotation tool that can be customized to work with YOUR style of doing presentations and working with applications. And, it works with all versions Windows. To learn more or download the files

 Paste as Text -- Free Customizable Tool (April  2010)
PureText, developed by Steve Miller, removes rich formatting from text, including the font and paragraph formatting. It does not modify the actual text, remove or fix new-lines, carriage returns, tabs, or other white-space. It is not intended to fix word-wrap or clean up your paragraphs. It is an easy tool to install and to use it just switch from CTRL+V to Windows+V.  For more information and the download, please visit http://SteveMiller.net/PureText

Windows Live Movie Maker
FREE ... turn photos into movies, create training and documentation for your solutions!   How about using this and doing a demo for the groups? 

Microsoft Releases Free SCCM Dashboard (April  2010)
If you use System Center Configuration Manager, you may find a significant benefit in Microsoft System Center Configuration Manager 2007 Dashboard, now available as a free download. The graphical UI provides easy access to information, is easily customized, and can present data in numerous formats, including charts, graphs and tables. The filters allow quick drill down from high level summaries to specific details. For more information and to download the file 

Virtualization and Hyper-V --- a “green” light for saving time, SPACE, money and more
This is a collection of links to training, information and other resources related to virtualization.

Ever which you could replicate a desktop or other platform to test before deploying at a client’s? That’s just one of the scenarios that can be quickly and easily be solved using Hyper-V. Once you’ve tried it, you may become a bigger Hyper-V advocate than IT!

Data Encryption on the Fly with TrueCrypt  (April  2010)
Free open-source encryption software that is easy to use to provide real-time, transparent data encryption. To learn more and download the documentation and software, visit TrueCrypt.org.


Microsoft Virtualization Training Portal
You can download the server for free, read the white papers, take some tutorials, and put it to work.
Training and exams on virtualization, even free e-learning options
TechNet Videos and other How To's
Go Green AND Save Money with Virtualization
Learn about saving energy and resources with the Hyper-V “Green” Toolbox
FREE Microsoft Hyper-V Server 2008

News books and more about Understanding Microsoft Virtualization Solutions

VIRTUAL HARD DRIVES ...
Microsoft's center for learning, downloads and other resources related to VHD
WINDOWS SERVER 2008 R2
Learn about the features, power, BENEFITS and system requirements. Get the FREE downloads!

Windows 7 --- Learn, Use, Download, Resources
Fast, Simple, Powerful --- an intuitive operating system may sound too good to be true. You owe it to yourself to learn more. This may become your starting point to find all the resources you need to learn, compare, and get ready to install.

SQL Server 2008 SP1

Windows OneCare
All-in-one protection available 24/7. Now that's a package.
The system includes protection from viruses and spyware, as well as a firewall, back-up and recovery, system maintenance and performance enhancements. Download a 90 day free trial from Microsoft or purchase locally.


Microsoft Virtual PC 2007
Learn about VPC, watch the demos, download the files. Get Virtual Hard Disks with preconfigured software.

Free Ebook -  First Look Microsoft Office 2010 (Feb 2010)
14 chapters that introduce some of the new features and benefits of Office 2010. Available in PDF and XPS formats.

Oregon SQL Developers Professional Association
The Oregon SQL Developers (OSQL-d) Professional Association provides opportunities for SQL Server developers, .NET developers, and SQL Server administrators to meet and discuss SQL Server technologies that are of specific interest for developers. Visit their website to learn more.

Regular Expressions  ... parse and manipulate text
Regular expressions help you find a character or pattern and then perform a function. You can use it to edit, replace, extract, or build a string. You can even vary the function based on the value. Microsoft has provided a series of free webcasts view webcasts You might also want to visit RegExLib.com, a site with over 2,200 expressions.

Bumper Cars or Homebound??     Seattle 2008/2009
Training for winter driving conditions could not equip drivers to maintain control of vehicles on streets of ice.  True to my reputation for being conservative <g>, my car stayed parked for 8 days  ...  (save me ...save me, she cried ...)
Seattle chose to use RUBBER BLADES on snow plows and to NOT use salt to melt the ice.
This video is just one example of the results -- as shown on King 5 news. It's like using cars in a combination of bowling, curling and pool.

Top 10 Reasons to use Access WITH Excel (July 2008)
This article explains how to have the best of both worlds and includes demo files and scenarios that make it real in YOUR world.

What's so great about Office Excel PivotTable reports? (August 2008)
Learn about the powerful Microsoft Office Excel 2003 PivotTable(r) feature, which organizes, summarizes, and analyzes your data to reveal its meanings.

SQL Server 2008 Today Trial Software
Download a free, fully functional 180-day trial version of SQL Server 2008 and SQL Server 2008 Feature Pack today. To help make the most of your evaluation, you will receive five e-mails during your evaluation period that, depending on which download option you select, contain resources specifically designed for IT professionals and developers. Before downloading and installing SQL Server 2008 be sure to use the link to evaluate the system requirements – avoid undue complications with your configuration.     

Download SQL Server 2008 Feature Pack
The SQL Server 2008 Feature Pack is a separate download from SQL Server software. This collection of stand-alone install packages is designed to provide additional licensed functionality for SQL Server 2008. It contains 17 new redistributable and backward compatibility components and add-on providers.

Browsing with More of What you Want and Need
Internet Explorer 8
offers better protection, connects to more services, and gives you more options and control. See how IE 8 can improve your experience.

Run IT on a Virtual Hard Disk
Using the power of virtualization, you can now quickly evaluate Microsoft and partner solutions through a series of pre-configured Virtual Hard Disks (VHDs). The Microsoft Virtual Software experience gives you full access to a number of server products on a pre-configured virtual machine. You can download the VHDs and evaluate them for free in your own environment without the need for dedicated servers or complex installations. Download the application of your choice and start evaluating the software for your environment immediately, for free.  

Windows Live SkyDrive - Online File Storage
Microsoft is now offering 5 GB of FREE, password protected, online file storage! Store your photos and other files so that you can retrieve them from anywhere, share them with friends, or share them with the world. Check out your options at

W
indows Live Search
Microsoft has launched a new promotion that enables you to get cash back when you shop online using the Live Search Cashback  site. Simply go to the Live Search Cashback site and search for the products you want. When you purchase one of the Cashback items, you receive an e-mail notification that the purchase has been added to your Cashback total. The total earned is then paid out in cash to you when a minimum balance is reached.

101 Fabulous Freebies (August 2008)
We'd thought we'd throw in something else just for fun. MSN Tech & Gadgets has posted a fun article, listing 101 free finds on the Web right now. Click here to check out the list:

Make a World of Difference with Search and Give
(August 2008)
Search and Give is a free and easy way to give back to any cause that is important to you. Whether the organization close to your heart is a local church, school, food bank, wildlife protection group or an organization searching for a cure-your gift is your choice. You can choose from over 800,000 non-profit organizations and 100,000 U.S. public, private, and parochial K-12 schools. The more you search, the more you give.

Here's how it works. Sign up at www.searchandgive.com and then you can start donating one cent for every search you perform using Windows Live Search. If you've earned tickets playing games on Microsoft's Live Search Club, you can also convert those tickets into donations. Who says playing games doesn't pay?

Product Key – Lost and Found (Sept 2008)
Finally, we have guidance on how to minimize the pain and frustration from loosing a product key. If you’ve lost a produce key in the past, you may have begrudgingly purchased a replacement program. Well, that doesn’t need to be the case, in fact, Microsoft has provided instructions on how to get a replacement key, in KB811224
 
MSDN – Virtual Labs to Test-drive Code samples (Sept 2008)
How many times have you seen a code sample but didn’t try it out because you didn’t have the software configuration or you didn’t want to risk unexpected impact to your system? Now there’s a simple and convenient solution. MSDN provides virtual labs so that you can try out many of the code samples. Better yet, there’s a split window so that people can read the MSDN article in one pane and use a second pane to contain the test environment!

PrimoPDF – The World’s #1 free PDF Creator ... (at least according to them) (Sept 2008)
PrimoPDF offers both a free and professional version that will work with Windows 98 through Windows Vista and can work with over 300 file types. Willie really likes PrimoPDF for client installations because it is remarkably simple and leaves a VERY SMALL footprint. Check it out and let me know what you think.
Recommended by some of our members ;~)

Tips & Tricks – Webcasts and Podcasts from the Experts
Microsoft Webcast Home provides links to valuable resources from the experts. These webcasts and podcasts include great tips, lessons, recommendations and other invaluable tidbits -- and ... it’s FREE!

Access 2003 Solution Center  (July 2008)       
Find the materials and answers that you need for Access 2003. Downloads, articles, tutorials and other reference materials are conveniently listed in an easy to search fashion.

Database Issue Checker (10/10/06)
Access MVP, Allen Browne offer tips and utilities for casual users through expert developers. The Issue Checker can be used during development or to trouble shoot legacy files.

VIRUS AND HACKER ATTACKS (10/10/06)
BBC article
study results showing that a typical PC might suffer from more than 50 attacks per night.

Searching Your Hard Drive (10/10/06)
Advisor Magazine has recently released (made free for download) an excellent article that walks you through and provides the code for three methods to search for a file. “Find Your Data” by Access MVP, Doug Steele, can be downloaded from http://zones.advisor.com/doc/16279

Save As PDF, XPS or PDF or XPS (seeing double??) (10/10/06)
Office 2007 Add-on’s allow users to save files in PDF or XPS formats. As promised in June, Microsoft has posted free add-ons and they are allowing computer makers to strip the XPS functionality from Windows Vista operating systems. Yet another whirlwind to toss around the consumers. But, the key thing is that the add-ons are currently available and they work with Office 2007. There are three separate downloads.
Save as PDF         Save as XPS               Save as PDF or XPS
And, if you want to read more of the story, here’s the article from TechWeb.

Keyboard shortcuts for Microsoft Office (June 2008)
It is sometimes quicker to accomplish tasks with simple keystrokes rather than by using your mouse. Discover how to get a full list of keyboard shortcuts, and learn and practice ways of using your keyboard rather than your mouse.

Expressions in Access (10/10/06)
If you’re like me, it is often easiest to learn from an example. The online help for Access provides several examples of commonly used expressions. Microsoft Assistance 
 

 


SQL Server, Visual Studio, BizTalk Server

*Want some assurances before installing? See footnote ;-}

Free Express Versions
With the launch of SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006, Microsoft has made many Express Versions available for download at no cost. This is a limited time offer, but the license will continue even after the products are no longer free. So ... what are you waiting for???

SQL Server 2005
-- keep up with events, training and add-ins. Even download a trial version.

SQL Server Express 2005 --
powerful and reliable data management yet NO COST! Supports deployement and can be distributed with your applications.

Visual Studio 2005 -- The latest in developer tools that Microsoft has to offer.

Visual Web Developer 2005 Express --  A great tool for getting hooked on web development. The xpress edition is available for no cost!

Visual Basic 2005 Express -- Complete with a drag-and-drop interface! Another no cost download.

C# Express -- One of the preferred languages for building .NET applications.

C++ 2005 Express -- One of the standard languages for building .NET applications.

J# 2005 Express -- One of the standard languages for building .NET applications.

How about a trial version of the REAL THING??
Order the the free 180 trial versions of these products

SQL Server Virtual Labs -- Learn how to use the new features in a hosted training lab!  Unlimited 90 minutes sessions! How cool is this?

SQL Server 2005 Feature Pack -- WOW! New tools and add-ons are already available AND backward compatible. Soooo ... what are you waiting for?

*Footnote and FAQs:

Please note that these postings neither convey nor imply any warranties or guarantees and that individual experiences may vary. It is prudent to have restore points and backups whenever installing software.  (Just protecting my sixes. How did that term come about, anyway??)

Question:
The new Web Development tools are awesome and I want to use them. However, I'm concerned about version conflicts.
Can the Express editions can be installed without corrupting or interfering with prior versions of programs or files?

Response:  All of the Express editions are fully supported and should not cause corruption of other installs. They are designed to be installed along side previous development products. You should only uninstall components used by other development products if you don't want to use them anymore.
The easiest thing to do is just install Visual Web Developer Express Edition.  This will install SQL Express for you to play with.  It is a separate SQL Server instance and won't conflict or automatically upgrade anything.


Question: I've downloaded the .NET Framework 2.0 but they didn't replace .NET Framework 1.1 and the 1.1 Update. Should I delete the 1.1 files?

Response:  The .Net Framework 1.1 should not be uninstalled because it is required by VS 2003. The 2005 .Net framework is designed to work side-by-side with old versions. When you download and install any of the Visual Studio 2005 tools, they will install whatever files are required. Testimonials indicate that Visual Studio 2003 and 2005 have good manners and are playing nicely on the same machines.
 


Conrad Systems Development   --- CSD Tools Version 2.0 (Feb 2006)

You remember Jeff Conrad, one of the newest and closest Access MVPs.  Well, you’ll want to check out Jeff’s latest tool and Access Add-In for documenting your database objects. You can easily export the reports to Word or Excel!  Jeff’s site has lots of great tools, tips and links. Check it out … and tell Jeff that Teresa sent you ;-)
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

DYNAMIC LINK LIBRARY ARTICLE by Mark Liron, MVP (Feb 2006)
Learning more about DLL’s is right in line with several of our topics requested for 2006. Mark’s article explains what DLLs are, what they do and
why you need them. His users’ guide to dynamic link libraries even explains why and how to secure them.
www.updatexp.com/dynamic-link-library.html

Speed Ferret for Access 2003
Good news / Bad news … The good news is that SpeedFerret 4.1 can be used to work with Access 2003 databases. The bad news is that it requires Access 2000 or 2002 also be installed on the particular PC. Please visit Black Moshannon’s site to read the particulars. www.moshannon.com/sfkb0041.html

IdeaBlade Offers Free Copy of DevForce Express
IdeaBlade is pleased to offer DevForce Express absolutely free! DevForce Express is a developer productivity solution for .NET that is fully integrated with Microsoft Visual Studio for developing data-intensive client/server applications. The solution is a "must have" for .NET development. It will improve your productivity and increase application quality from development to deployment. This ensures that you meet the needs of your users, reduce overall costs, and accelerate time-to-market.
   www.ideablade.com/DecFlash/?referrer=msdnDecFlash

Scroll mouse, Scroll (Feb 2006)

Yes, you can have a better mouse trap …   Or at least, take back control and make your mouse scroll …
http://support.microsoft.com/?id=837910

Office 2003 Tips & Tricks (Feb 2006)
Work smarter not harder! Find the latest tips for getting the most of Office 2003. PLUS get a chance to win Office 2003 Professional Edition!! Join a live webcast.
www.microsoft.com/office/greattips/default.mspx

Convert PDF files to editable Word documents!!! WHAAAAHHOOOOO (Feb 2006)
Oh … Yes, I like this. ;-)

http://office.microsoft.com/en-us/marketplace/EM011628581033.aspx

Microsoft Partner Program  (Jan 2006)
As often as we’ve mentioned the benefits of being a MS partner, I wanted to make sure you know where to find out about the program requirements and benefits. The Microsoft Partner Program Guide conveniently puts it all together in a pdf file available at  Or, you can read about the benefits and requirements online.

MSN SPACES!! Including NEW and Improved services and BLOGGING (Jan 2006)
Free free free … free communication services to make e-mail, instant messaging and online sharing easier and more fun! Create your own space …. http://spaces.msn.com

Windows Live and Office Live
(Jan 2006)

Customize, optimize and maximize your computing experience. Windows Live and Office Live help merge virtual and brick offices into a powerful, unified experience.    Sign up for the beta test
Create your own Windows Live home page!   www.live.com
In unveiling these new services, Microsoft is offering a variety of ways to learn and try out the features to see how they will benefit you and your customers. http://ideas.live.com.
Learn more from the November 1st press release.

The Big Kahuna … or rather The Kahuna Beta (Jan 2006)
The image of a warm beach, grass skirts and leis got my attention.
But, this is actually referring to Microsoft’s upcoming version of Hotmail. The use of web-based mail is exploding and to better service that need, Hotmail will be an integral part of Windows Live. You can look forward to enhanced features, better security and easier interfaces. Current Hotmail users can participate in the beta testing and provide feedback to Microsoft. It has already been offered to 200,000 users! (This seems to be a finicky link … you may need to copy and paste it into your browser.)
www2.imagine-msn.com/minisites/mail/default.aspx?locale=en-ca

http://blogs.msdn.com/access
 The OFFICIAL MS Access Blog!

Install Shield 11.5  -- Free Evaluation and Demo Versions
Professional deployments made easy! No waiting for a compatible version because InstallShield 11.5 is current with major updates to Microsoft’s latest releases … Visual Studio 2005, .NET 2.0, SQL Server 2005. Get your free evaluation versions or take a demo without the download.

Business Office Explorer … Developer Version

Mike Hagar's Business Office Explorer, BOE,  is Mike's vision of a tool to provide a controlled environment for both the developer and user. In conjunction with a recent presentation to the PNWADG, Mike has offered developer licenses to qualified PNWADG members. A special portal to Mike's site provides instructions for PNWADG members to obtain the full developer's version. Please go to www.BusinessOfficeSynergy.com/PNWADG.htm  where you can read Mike’s personal expression of thanks and get started using BOE.


Access Error Messages and Record locking  -- Blog posting by Michael Kaplan
At the October 18th meeting, we talked about record and page level locking. Being intimately familiar with JET, Michael explained some of nuances about record locking and then posted a detailed explanation along with some background about warnings and errors.

MVP Sites -- an excellent compendium of sites with Access (and other) code and tips.  Michael Kaplan recommended Dev Ashish's and Randy Birch's sites, among others.

Jeff Conrad, the Access Junkie and Access MVP

Our Guru: Armen Stein's J Street Technology (database driven site)

Pacific Northwest Access Developers Group

Microsoft Access Support Center

Office Development Support Center

How to Guarantee that References Work in Your Application (avoiding disambiguation by Michael Kaplan) (added 5/23/03)

10 Tips for Developing with Outlook

Utter Access Discussion Forum (the number one Access community forum!)

TOOLS and TIPS

Remove Hidden Data from Office Documents

Permanently remove hidden data and collaboration data, such as change tracking and comments, from Office files.

Disable the Close Button (X) on the Access Application Window
We’ve all witnessed someone close Access when they really wanted to just close a form. This KB article explains how to disable the Close Button for Access 2000.

Download Outlook 2003 PST Backup
Create backup copies of your personal Outlook files at regular intervals, in Outlook 2000 and later versions.

Update to
Outlook 2003 Junk Email Filter KB905648 (Dec 2005)
Get more current definitions for Outlook to manage your junk email. PS … Use the automatic update feature to make it easier to stay up to date.

Archiving Outlook Files
Are you protecting and preserving your critical communications by archiving and providing remote storage of your Outlook PST files? Learn how easy and beneficial it is to manage PST files. Microsoft offers free training and guidance 

Download Excel Viewer 2003
Open and copy spreadsheets, from Excel 97 to Excel 2003, without having Excel installed.

Updated 1/9/2006


Copyright© Seattle Access and Data Dynamics Northwest 2001- 2010 
Hosted and Maintained by Teresa Hennig, Access MVP ;-)