vb123 Welcome To vb123.com.au

"This web site is designed for developers and users of Microsoft Office and in particular Microsoft Access.  There are 200+ articles, newsletters and tips to read and search. Plus there is a popular newsletter called Access Unlimited that 1000's of programmers read.  Naturally  I would encourage you to purchase our knowledge based product called The Toolbox and/or The Access Workbench which will help you manage your Access users and databases. Or give me a call if you are in Australia, I always love chatting about software." 

Garry Robinson - Website Editor and Office Access MVP 


Click here for all the latest information

Smart Access is back: Find out about that great newsletter because we now own the rights to the PDFs and the downloads and have a new content website.

Read about the Smart Access collections on the Microsoft blog

Monthly Access Newsletter
Receive our standard Access content by email once every month or so

Links to pages that will give you an idea about what VB123.com is all about

SharePoint and Access - Getting Started and Motivated

Setting Up Right Click Menus for Access 2007

Use Access 2007 to Get Started in Data Mining

Making Your Own Access 2007 Ribbon

Preparing To Upgrade Access Tables to SQL Server 2005/2008

Searching For Text Anywhere In A Database

Focus on Popular Objects to Speed up an Access 2007 Database

Flexible Normalization and Denormalization of Data

Secure Microsoft Access Passwords and Encryption in Access 2007

Using Microsoft Access to query and update Web sites

IT Departments and Microsoft Access ~ Developers Have Their Say

Conditional Formatting In Forms And Reports

Access 2007 Security Considerations

Tricky Queries To Impress Your Boss

Zip A File

Samples of How To Change Startup Properties and Use Hotkeys

Autoexec macro in Access

SQL Server Knowledge Based Articles

Samples of how to backup and recover your Access database

Samples of Menu and Toolbar Protection

Samples of Developer Workgroup Security Manipulation

Samples of Data Security and Database Passwords

Samples of Object Protection and Other Security Measures

Alternative Access Protection/Security Ideas

How to Setup an Access Version Number System

Restrict The People Who Can Use Your Database Folder

Automation Of Word

Microsoft Access Security And Passwords

Replace Your File API's With The FileDialog Object

Processing E-Mail Orders using Outlook and Access

Take Advantage Of The Class Module Features Of Your Access Forms

Duplicate Data Entry For Access

Lookup Tables - Getting Rid Of Junk data

Backing Up Your Access Data With XML

Track all changes made to a record in Microsoft Access

Consolidation Queries   A list of errors

Save Reports As PDF Files From Access

Remote Queries In Microsoft Access

Access Unlimited News - Issue 80

How We Read A PayPal Notification Email Using VBA

Using Microsoft Access to post data into Web sites

Read all the latest information
  Check out Garry's Blog, he is always posting something on Access and if you sign up for the newsletter, the blog turns up in your inbox.  Useless trivia: Our newsletters have 5000 readers.

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
  • Get Good Help
    If you need help with a database, our Australian Professionals could be the answer

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection.  Purchase Smart Access

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.
  • Purchase the Popular FMS Products  
    If you purchase the Popular FMS products from us, you will receive a complimentary of Smart Access Gold, Silver or Bronze Collections [Your choice]