vb123.com.au                                                          

  Welcome To The Access Unlimited Newsletter - Edition 49
See all newsletters

Access Unlimited is an email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.

Produced by Garry Robinson (known below as "Ed") from Sydney, Australia.

This edition is primarily focused on encouraging the 4500 readers of this humble magazine to participate in a bit of blogging on a topic that I know will be of interest to most of you. 

What would you like to see in the next version(s) of Microsoft Access ?

To whet your appetite, Peter Vogel invited Ed to write an editorial on “Access 2006”. This article has now surfaced as the free to read article in the August Edition of Smart Access. Read more at www.pinpub.com. I have also republished the same material at http://vb123.blogspot.com where you can do more than just read, you can post your comments and ideas (anonymously) along with many others already posted in the comments section.

After you chaps and gals have all added your little gems. Peter and I will organize your ideas, publish them in Smart Access and at http://vb123.com/access2006 and then send the list onto to Microsoft.

Remember the best way to improve your software is not to have a good idea but to have a list of good ideas.  Same principle applies to Microsoft as it does to the humble backyard developer.  Read and Add Your Comments Here

Ed

Latest Access Workbench Beta: 16-July-04

A new beta version of the workbench has been released.  It includes

(1) You can select from Access 2003, 2002 or 2000 to open you Access 2002 or 2000 format databases.  (2) There is now a facility to view and change the release version of the database. The release data and version number need to be stored in a table in the database. We provide the format for this with the registered copy. (3) The software includes a button to open backup databases in the backup folder. This is useful when you are looking for the original of that form that you just edited. You can also delete backup databases produced by the workbench from the backup tab in the workbench.

 http://www.vb123.com/workbench

---- Advertisement  ---

The Easy Access Database Directory is a non commercial enterprise, which offers a free directory service (including a free listing for anyone, whether they are a commercial business or just an enthusiast) in relation to Microsoft Access resources, which can be easily browsed by category or via key word searches.

Visit us today as http://www.directory-base.com/access/

GOOD READING

Find the number of records effected by an SQL query in Access
http://www.techonthenet.com/access/modules/recordsaffected.htm

Discussions on DbEngine.Execute verses doCmd.runsql in Access
http://www.developersdex.com/vb/message.asp?p=2899&r=4320246

Ed Note: Can anyone verify the speed performance differences between the two approaches mentioned above ? If so email use the comments link on the side.

How to manage the SQL Server Desktop Engine (MSDE 2000) by using the OSQL utility  Read more

Connect an InfoPath form to an Access database  Read more

Remove hidden data from Word 2002 or 2003 Add-In
Read More

Moving The Temp and Master DB in SQL Server
http://www.databasejournal.com/features/mssql/article.php/3379901

Managing Group policy in Windows
http://mcpmag.com/columns/article.asp?EditorialsID=745

Display an  Excel range in an Access listbox
http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

I love golf but not as much as this nutter who lost over 500 balls playing from one side of Mongolia to the other.
http://www.pgatour.com/story/7530334

FMS Paper on compiling and other things
http://www.fmsinc.com/tpapers/vbaint/

Upsize Access Reports to SQL Server Reporting Services
http://www.databasejournal.com/features/msaccess/article.php/3373661

Send Faxes with VB 6 and a Modem
http://www.freevbcode.com/ShowCode.Asp?ID=6685

Process a group of queries as a batch (in MySQL)
http://www.databasejournal.com/features/mysql/article.php/3382171

The facts and figures of the copper exploration project in Mongolia that we provide database support for.  The geology database is a 250 megabyte Access database with 100 tables. 32 of the tables are linked will referential integrity to the one master table. And it all works most are time!!! http://www.ivanhoe-mines.com/s/TurquoiseHill.asp

--- The end of this edition of Access Unlimited ---

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. And if you can, have a look at our software by using the Marketing section on the left hand side of this newsletter. 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
 

PS Don’t forget Garry’s book …
http://www.vb123.com/map/

Click on this button to read the previous edition of Access Unlimited 
Published  2004-08