Next Tip Access Unlimited News - Edition 73
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.

--- 25/01/2007  ------------------------------------------------------------------------------------------
 
Read the latest Access Unlimited newsletter online
 
If you will have upgraded to Internet Explorer 7, you can see the RSS feed that this newsletter is based on by copying the following line into the address bar of IE7.
http://www.vb123.com/news/rss1.xml

We are adding new items to the RSS feed every few days so rather than waiting for the newsletter every month or so, get into our RSS feed.

I hope you enjoy the latest newsletter.

Garry Robinson
Access MVP and Editor of vb123.com


--- 25/01/2007  ------------------------------------------------------------------------------------------
 
Add your requests for Access 2009
 
As Access 2007 is now being distributed around the world, Clint Covington, Senior Program Manager, Microsoft, wants feedback from people about the next version of Access.

Head to this page to see a huge list from users posted in 2005/2006. Use this list as inspiration for your post to the Microsoft blog.


--- 24/01/2007  ------------------------------------------------------------------------------------------
 
The Access Developer Portal
 
This is page where Microsoft will whip you into a frenzy of excitement about Access 2007.

--- 17/01/2007  ------------------------------------------------------------------------------------------
 
Optimising Access Connections to SQL Server by Andy Baron
 
One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables. This is the type of application created by using the SQL Server Migration Assistant for Office Access. This white paper presents techniques for improving performance and updatability in Office Access applications that use tables linked to SQL Server.

Did you know you can link to a SQL Server View? Read on...


--- 30/04/2006  ------------------------------------------------------------------------------------------
 
Beta Version of the Workbench For Microsoft Access Released
 
Build a zip file of the database whose name includes the version name (requires Winzip or similar). Very handy for keeping backups of release versions of your database and also for mailing to clients to install.

Find out all the improvements to our popular Access management and development tool on this page.

 

--- 2/01/2007  ------------------------------------------------------------------------------------------
 
1 Query ~ Totals and Items Combined
 
Find out how to display totals and detail in a query. I have been using a similar technique for adding chargeable time totals for years. Article is in PDF format by Susan Sales Harkins.

--- 24/01/2007  ------------------------------------------------------------------------------------------
 
Access 2007 Comments
 
Lots of comments, regular and extra-strong about Access 2007, some good and some well .... You read them. Remember that they are all based on the Beta version.

 

--- 1/11/2006  ------------------------------------------------------------------------------------------
 
Access Unlimited Newsletter 72
 
Read the last newsletter online.

 

 

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

---

 

To sign up for Access Unlimited, head to
http://www.vb123.com/news/

To rename, unsubscribe below and then sign up with new email address.

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