Next Tip Access Unlimited News - Edition 81
See all newsletters

Independent news for enthusiastic Microsoft Access and Office readers

If you cannot see any links in this article, you are reading it in text format. The newsletter can be signed up for and read at
vb123 dot com

Produced by Garry Robinson from Sydney, Australia.


 

Aussie Readers ~ Access Development/Office Automation    Advertisement

If you need help with an Access database or are contemplating upgrading to SQL Server or 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) 9340 7789 or email me.     

http://www.vb123.com.au/professionals/                       Garry Robinson, Office Access MVP award winner.
 

 


--- 9/9/2007  ------------------------------------------------------------------------------------------
 
  Read the latest Access Unlimited newsletter online
 
 
  Greetings to you all from Sydney Australia, enjoy the newsletter .

Garry Robinson
Access MVP and Editor of vb123.com and vb123.blogspot.com

 

 

 

--- 8/09/2007  ------------------------------------------------------------------------------------------
 
  Using Library Databases as Part Of Your Access Solutions
 
 
  In this detailed article from Andrew Wrigley, a long time Access professional, you will find out why and how you can deliver your database solutions with a library either to protect your intellectual property or to reduce the duplication of code across your projects.

"When Andrew first proposed this article for vb123.com, I thought it would be good to review how my team delivers Access applications to multiple customers. I hope you find the article as useful as I did." Garry

 
 

--- 7/09/2007  ------------------------------------------------------------------------------------------
 
  Danny Does the Web In Access
 
 
  This is a topic that crops up occasionally in client discussions. How can we make this Access application look like a web browser. Here at vb123.com.au/professionals we have implemented many solutions that involve a a hybrid button ~ hyperlink look. In this series of articles, Danny Lesandrini discusses ways to clear all the Access clutter out altogether.
 
 

--- 25/01/2007  ------------------------------------------------------------------------------------------
 
  Repair Damaged Access Databases
 
 
  vb123.com 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 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
 
 

--- 22/08/2007  ------------------------------------------------------------------------------------------
 
  Excel to Access video time
 
 
  Microsoft have prepared a video (and text for you old fogies) on how to get Excel information into MS Access 2007. "Don't forget your popcorn".
 
 

--- 18/08/2007  ------------------------------------------------------------------------------------------
 
  How To Make A Numerical Sequence in An Access Query
 
 
  Creating a numerical sequence for an Access query then appending that to a table (i.e. 1..2..3..4..5..6) in its own column is not as simple as it first seems.
 
 

--- 31/07/2007  ------------------------------------------------------------------------------------------
 
  Access Team Blog
 
 
  New posts at the Microsoft blog about buttons with text and images, how to use attachments and integrating Access data with SharePoint.
 
 

--- 17/08/2007  ------------------------------------------------------------------------------------------
 
  Access and Ruby on Rails
 
 
  A bit off the normal track but its good to see a different and new language for a change.
 
 

--- 15/08/2007  ------------------------------------------------------------------------------------------
 
  Garry's Access blog
 
 
  No real blogging in the last month though you may want to check the my blog this month if you to lift your spirits with some good old Aussie comedy.
 
 

--- 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
                    
 
 
So thanks for reading our popular newsletter. Feel free to make comments, copy the email to a friend or maybe even contribute to the next edition. If you really like this newsletter, why not purchase The Toolbox and you will get all the other newsletters and plenty more in a developer’s knowledge base tool with super searching facilities.
 

Garry Robinson - Software Consultant and Author
Editor of vb123.com

Microsoft Office Access MVP

 

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics

  • 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. 

    See the Smart Access 2010 specials here

  • 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

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions



Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
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

Access 2003 Security

MS Access Security

Read More here