|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new Expression Web |
Is Your Database Corrupt ?
Access
Unlimited News - 2008 Jan - April
See all newsletters
| Produced by Garry Robinson from Sydney, Australia.
|
| Australian
Readers
~ Access Development/Office Automation
Advertisement If you need help with an Access database such as upgrading to Access 2007, my experienced developers can help you. Otherwise if you experience spreadsheet meltdown, we are very good at using Access to feed Excel templates. So if you need help, call (02) 9665 2871 in Australia or email me. http://www.vb123.com.au/professionals/ Garry Robinson, Office Access MVP award winner. |
|
--- 29/04/2008 ------------------------------------------------------------------------------------------ |
||
|
Hooking Access upto DB2 |
||
|
Here is an interesting article on hooking Access up to DB2.
|
||
|
--- 24/04/2008 ------------------------------------------------------------------------------------------ |
||
|
Conditional Formatting |
||
|
In this article Tom Wickerath, Access MVP, explains how to setup conditional formatting in an Access database. This visual cue can be a very useful if used wisely. For example I use conditional formatting to highlight invoices that are outstanding for a month.
|
||
|
--- 23/04/2008 ------------------------------------------------------------------------------------------ |
||
|
Lists tutorial in Excel 2003 |
||
|
Here is a tutorial on managing "databases" in Excel. Interesting that one of the important efforts in Access 2007 was to mimic the data filtering in Excel.
|
||
|
--- 2/04/2008 ------------------------------------------------------------------------------------------ |
||
|
Integrating Access with Sharepoint Server |
||
|
This Microsoft technet article focuses on how to get Access to talk to sharepoint.
|
||
|
--- 12/03/2008 ------------------------------------------------------------------------------------------ |
||
|
ThickToast gets a mention in the BaseCamp blog |
||
|
I have mentioned before that we run the collaboration part of our consultancy business using BaseCamp. Well the tools behind this is called ThickToast and bits of this are now for sale and yep, its Access based.
|
||
|
--- 5/03/2008 ------------------------------------------------------------------------------------------ |
||
|
Access Protection and Security |
||
|
If you are still using Access 2000, 2002, 2003 or even Access 97, have you considered my book on Access security. Read the 15 5 star reviews at Amazon.
|
||
|
--- 5/03/2008 ------------------------------------------------------------------------------------------ |
||
|
Displaying Subtotals and a Grand Total on a Form |
||
|
In this detailed article at vb123.com, Tom Wickerath shows you how to explain how to include textboxes to display subtotals from the subform as well as a grand total field.
|
||
|
--- 23/02/2008 ------------------------------------------------------------------------------------------ |
||
|
Getting Rid of Replication Fields |
||
|
Recently I was called out to help on a database that was running really slow. One of the things I came across early in the investigation was that the database at one stage used Access replication technology. So I set about removing the replication fields. I have described this in an updated article on index fields. Note: In case you didn't know it, replication technology was dropped in the version of Jet used for the Access 2007 ACCDB databases. In my view, replication was always way too ambitious for a database that thrives on local networks. |
||
|
--- 15/02/2008 ------------------------------------------------------------------------------------------ |
||
|
Symptoms of a Corrupt Database |
||
|
For a few years now we have been referring people with corrupt databases to Wayne Phillips website EverythingAccess.com . In the link related to this note you can find out the identifying symptoms of a corrupt database.
|
||
|
--- 14/02/2008 ------------------------------------------------------------------------------------------ |
||
|
Macro Security in Access 2007 |
||
|
If you are an Access consultant, you will now be beginning to experience customers who are opening databases in Access 2007. When they do the first thing the are going to run into is Macro Security. To fix that you need your customers to setup a Trusted Location for the database that they opening. My article for MSDN tells you all about this. By the way, this has to be set for every PC. |
||
|
--- 14/02/2008 ------------------------------------------------------------------------------------------ |
||
|
Export from Access to an RSS Feed |
||
|
If your boss or client mentions that they would like you to create an RSS feed from your database, I would suggest that you take a good look at this page. The description is generic but isn't far off what you will need to write code in vba with a record set. This newsletter is written as an RSS feed to the following location. http://www.vb123.com/news/rss1.xml If you need help publishing from a database to an RSS 2.0 feed, contact Garry as we have been deploying RSS in our solutions for quite a while now. |
||
|
--- 12/02/2008 ------------------------------------------------------------------------------------------ |
||
|
Danny takes on bitmasks |
||
|
Querying data through bitmasks is a black art, Danny Lesandrini explains it in this article at Database Journal. "Let me begin by revealing that I'm not an expert with bitmasks. However, this fact should bring a little comfort to the uninitiated because it means that anyone can implement multiple selections using a bitmask field and operators. Odds are, you've been using them for years, but simply didn't notice it. If you've ever set the properties of a message box using Intellisense, then you've used bitmasks. " Read on |
||
|
--- 2/02/2008 ------------------------------------------------------------------------------------------ |
||
|
We run our Access consulting business using Basecamp from 37 Signals |
||
|
We tie a lot of our Access consultancy business together using a collaboration tool called Basecamp from 37Signals. Read more about BaseCamp here or join up to our new ThickToast newsletter http://www.thicktoast.com where you can read about Garry's thoughts on BaseCamp and other online providers that help our business. |
||
|
--- 24/01/2008 ------------------------------------------------------------------------------------------ |
||
|
Want To Improve The Performance and Reliability Of Your Access Application |
||
|
If performance and reliability are proving a problem with your Access database, Tom Wickerath, an Microsoft Access MVP provides a number of detailed tips about what you can do in a new article for vb123.com
|
||
|
--- 23/01/2008 ------------------------------------------------------------------------------------------ |
||
|
Repair Damaged Access Databases |
||
|
vb123.com offers an online repair system for Access databases. The system is setup so that your data is encrypted before it is transmitted and in most cases, you should be able to recover a corrupt database in less than 30 minutes elapsed time. "I know that it works because we use it from time to time." Garry
|
||
|
--- 18/01/2008 ------------------------------------------------------------------------------------------ |
||
|
VBA Lives on and on |
||
|
Just in case you were wondering, Microsoft have categorically denied that VBA is on the way out in Office Access 2009. Note: You can find this sort of news in our Max Out newsletter delivered once a week at http://vb123.com/news |
||
|
--- 11/01/2008 ------------------------------------------------------------------------------------------ |
||
|
How we use Basecamp from 37Signals to run our software business |
||
|
A year ago I decided that it was time to crank the business up a bit and start using more contractors. When the work starting rolling in thanks to my more pro active marketing, so did the emails and files and the time sheets came in different forms. Quickly I felt like I was losing touch with my clients and projects and the Inbox took far too long to organize. Here is the story about how we used BaseCamp to help out...
|
||
|
--- 8/01/2008 ------------------------------------------------------------------------------------------ |
||
|
Bill Gates Last Day at Microsoft |
||
|
Funny video taking the Cheese out of Bill Gates. Takes a while to download.
|
||
|
--- 31/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Read the latest Access Unlimited newsletter online |
||
|
Greetings to you all from Sydney Australia. Have a great New Year and enjoy the newsletter. Garry Robinson Access MVP and Editor of vb123.com and vb123.blogspot.com |
||
|
--- 31/12/2007 ------------------------------------------------------------------------------------------ |
||
|
More than a Niche Solution ~ Great Advice For Serious Access Developers |
||
|
After reading Gary's last article on MSAccess and IT departments I was compelled to write this article. Why do IT departments hate MSAccess, here are a few reasons from my experience : |
||
|
--- 28/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Garry's Access blog |
||
|
My blog rolls on with posts in December on Access (Read Jet/MDB ) Vulnerability Small Business For Dummies Converting to Access 2003 CurrentDb.Properties("AppTitle") Office 2007 Service Pack 1 Jeff Conrad talks Access 2007 Renaming a query Save Change SQL Server Table Scripts Unnecessary Indexes |
||
|
--- 20/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Weekly Access Unlimited Email Newsletter ~ Extra Content |
||
|
Here you can get the standard MS Access content plus content from Garry's Blog all in the same newsletter.
|
||
|
--- 20/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Weekly Access Unlimited Email Newsletter ~ Maximum Content |
||
|
If you want to see a lot of Access content from a number of different blogs including our Extra Content, then sign up here.
|
||
|
--- 18/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Simple DB from Amazon |
||
|
Watch this Amazon tool (and others as they come online) as online databases that are easy to use are definitely important technology for (Access) database developers. All we really need are linked tables to one of these and Access developers will be off and racing with the most versatile front-end on the planet. Here is a sample that works with Excel 2007 and VB.Net 2008 http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1125&categoryID=148 |
||
|
--- 12/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Office 2007 Upgrade |
||
|
Here are details on Service Pack 1 for Office 2007
|
||
|
--- 28/12/2007 ------------------------------------------------------------------------------------------ |
||
|
ACCDE Formats, watch out for the service pack |
||
|
Tony Toews has a post on the making of compiled databases with Access 2007 service pack 1. The fact that they will NOT open in Access 2007 (no service pack) is going to be a concern.
|
||
|
--- 12/12/2007 ------------------------------------------------------------------------------------------ |
||
|
New Hot Fixes for The Jet Engine Released |
||
|
If you are having problems with errors in Access 2002/2003, you may want to review this new version of Jet Engine.
|
||
|
--- 31/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Life In The Clouds |
||
|
An interesting list of New applications that run on the net and not on your computer.
|
||
|
--- 1/11/2006 ------------------------------------------------------------------------------------------ |
||
|
Read the last Access Unlimited Newsletter |
||
|
Read the last newsletter online. |
||
| The Workbench
Advertisement Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download Datamining/Graphs Explore your data with this versatile graphing and data mining shareware tool. Now in Access 2007. Read More |
|
Garry Robinson - Software Consultant and Author Microsoft Office Access MVP
|
