|
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 site built with
SharePoint Designer |
Is Your Database Corrupt ?
Access Unlimited News - Edition 71
See all newsletters
Independent news for enthusiastic Microsoft Access and Office readers
|
--- 31/10/2006 ------------------------------------------------------------------------------------------ |
|
Backing up Multi-User Databases |
|
To back up an Access database correctly, every user must log off the database. If you back up a database when someone is using it, you risk saving the database in an unstable state. A user may have made changes to data and objects and not saved them, so that when you open the archived database, you may receive a message that states that the database is corrupt. You then will need to use the repair utility and, at best, only a small amount of information will be lost. Unfortunately, you will never be able to determine exactly what that was as any corrupted data is usually unrecoverable. Read more...
|
|
--- 26/10/2006 ------------------------------------------------------------------------------------------ |
|
Access 97 'enabled' MDE databases are vulnerable! |
|
Our initial observations on this file were quite startling because we were able to recover the VBA source code in its entirety, without any reverse engineering at all....
|
|
--- 30/04/2006 ------------------------------------------------------------------------------------------ |
|
New Version of the Workbench For Microsoft Access Released |
|
A new Folder tab makes it much quicker to switch to and compact/backup multiple databases in a folder. To help you test Access forms fit a uniform screen size (like 1024 x 768), there is a blue fixed sized form in the workbench. All you have to do is position your Access Window on the top. . Find out all the improvements to our popular Access management and development tool on this page. |
|
--- 5/09/2006 ------------------------------------------------------------------------------------------ |
|
A variety of articles chosen by Microsoft on Microsoft Access |
|
Here you can check out pages on XML pitfalls to avoid on access forms, database normalisation tips and how to build a page to a disconnected recordset
|
|
--- 28/08/2006 ------------------------------------------------------------------------------------------ |
|
The Access Autoexec Macro |
|
For those of you who started your programming life by using DOS as an operating system, you will probably be quite familiar with the autoexec.bat file, a file used to configure your PC. Though this batch file is almost a history lesson now, Access has a similar starting mechanism called the AutoExec macro. This macro has been around since Access 2 and is still an important foundation for protecting your database. When your database opens, Access first processes the startup options and then looks for and runs the AutoExec macro....
|
|
--- 10/08/2006 ------------------------------------------------------------------------------------------ |
|
Common Table Expressions (CTE) in SQL Server 2005 |
|
SQL Server allows you to setup a query/view as a very temporary table. This article describes this new feature..
|
|
--- 1/11/2006 ------------------------------------------------------------------------------------------ |
|
Read the latest review on the Access Workbench |
|
Here is a sample of the review in the Access Watch newsletter This is my favorite part of the utility, the Favorites screen. I won't give a click-by-click explanation of how to register files, but suffice it to say that it's so intuitive that you really don't need to read the Help file to begin using this tool. Read on.. |
|
--- 29/07/2006 ------------------------------------------------------------------------------------------ |
|
Eat Your Greens - Access VBA Options Explained |
|
This page from FMS describes Option Explict Option Compare Database Option Private Module rather well.. |
|
--- 16/03/2006 ------------------------------------------------------------------------------------------ |
|
MS's Access 2007 Blog - Customer Overview |
|
How you can publish an Access database to SharePoint and many other blogs on Access 2007
|
|
--- 10/03/2006 ------------------------------------------------------------------------------------------ |
|
Repair Damaged Access Databases |
|
vb123.com now offers an online repair system for Access databases. Included in the latest version is the option to only repair tables rather than fix the whole database. This reduces the cost of exercise. The system is setup so that your data is encrypted and in most cases, you should be able to recover a corrupt database in less than 30 minutes elapsed time.
|
|
--- 16/03/2006 ------------------------------------------------------------------------------------------ |
|
MS's Access 2007 Blog - Read about custom ribbons |
|
All the latest discussions of what you will find in Access 2007. This post refers to the custom ribbons in Access 2007. Of particular interest is all the comments..
|
|
--- 11/07/2006 ------------------------------------------------------------------------------------------ |
|
Implement User Preferences in MS Access |
|
Implement User Preferences in MS Access using simple calls to the registry. Another good article from Danny Lesandrini. |
|
--- 4/07/2006 ------------------------------------------------------------------------------------------ |
|
See a good demonstration of what's new in Access 2007 |
|
Find out about the new exciting filtering for Access forms and even more dynamic filtering for Access reports, see the Ribbon in action and find out a bit about SharePoint server and why Access may be the killer ap that makes SharePoint more accessible. There is even some neato Excel import enhancements that could be useful. This demo runs for 25 minutes and will give you a very good idea about the things in Access 2007 that are hard to fathom from the online literature and blogging. I recommend the Demo download (15 megabytes) whilst the other 25 megabyte demo is mainly introduction and conclusion (and a chance to meet Clint Covington). |
|
--- 19/06/2006 ------------------------------------------------------------------------------------------ |
|
Getting More Out Of Access 2003 Help |
|
Ever since I started using Access 2003, the Help system seemed to make my life worse rather than better but like any good Access programmer, I just struggled on. So when I compiled the list of suggestions for the next version of Access 12 months ago, I realized that it wasn’t just me that thought that the Access help had gone backwards rather than forward. So I decided rather just be grumpy about my lot in life, I thought it would be a good idea to investigate the Access help system. In this article, I will discuss different aspects of Access 2003 help and other help resources so that you may better understand how to HELP yourself with Access. For the rest of you that are still developing away in earlier versions of Microsoft Access, I hope that some of the advice will assist you to get more out of your own Access help. |
|
--- 13/06/2006 ------------------------------------------------------------------------------------------ |
|
Is Hiding Databases A Good Idea? |
|
In case you missed my previous discussions on Access 2007 security, Workgroup security (otherwise knows as User Level Security) will not be supported in the new ACCDB file format. This led me to think about other credible alternatives and one that springs to mind is Windows File Security. One protection idea that I discussed a while ago with a friendly chap called Bill was hiding files in Windows Folders. Read and blog on this topic using the link.
|
|
--- 30/05/2006 ------------------------------------------------------------------------------------------ |
|
Load subforms dynamically and save on performance |
|
There are many things a developer can do to squeeze an incredible amount of power and performance out of an Access database. The first, and foremost, is to avoid loading data until you need it. One way to do this is through the smart implementation of subforms. By Danny Lesandrini |
|
--- 26/05/2006 ------------------------------------------------------------------------------------------ |
|
Garry's Access Security Book |
|
My book on protecting and securing Access databases received its 12th 5 star review at Amazon USA making it one of the highest rated Access books at Amazon. It looks like it's getting harder and harder to purchase the book so don't delay any more..
one reader recently wrote
"Hi Garry |