vb123.com.au                                                          

  Welcome To The Access Unlimited Newsletter - Edition 58   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.

In this edition
How to Change A Backend Database
Making Data Upper Case – Revisited
Annoying Hyperlinks in Access 2003
Vote For The Workbench
The popular GOOD READING section once again.

Feature Article - How to Change A Backend Database

In this edition of Access Unlimited, I would like to draw you attention to an article that Scott McManus and I wrote for the August edition of Smart Access. In this article we show you how to setup an Access database that will change the fields, relationships and properties of tables in a remote database. This article is useful if you have to update the structures of more than one backend, if those changes are complex and if you want to make sure that all the steps are followed. Please note that the approach that we take requires a good working knowledge of VBA, especially for issues such as relationships or field properties.

Click here to find the full article

Making Data Upper Case – Revisited

In the last newsletter I mentioned some solutions to uppercase handling. Once again the readers of this magazine have proved there is always a good alternative out there and I thank Jerry from http://www.personablepc.com for the updates to the following page.

http://www.vb123.com/Toolbox/05_access/upperlowercase.htm

Annoying Security - How to disable hyperlink warning messages in Office 2003

Now that some of our users are switching to Access 2003 and Office 2003, some internal hyperlink systems are sometimes getting the following painful message.
“Hyperlinks can be harmful to your computer. To protect your computer, click only those hyperlinks from trusted sources”.

You can read more about this at the following location.
http://support.microsoft.com/?kbid=829072

Vote For The Workbench

The Workbench is now featured in Microsoft Office Marketplace. If you have used the product and like it, take a few minutes to give it 5 stars J

Read more at http://office.microsoft.com/

Find out all the latest improvements to The Workbench for Microsoft Access at this page
http://www.vb123.com/workbench/improvements.htm

GOOD READING

Tony Jacoby from Solutions On Hand in Sydney says “Have you ever come across Be-Up the Backend Updater from Database Advisors?  It’s free and it’s also "open source" and the developers are pretty helpful with support and enhancements.  If you haven't already seen it, go to”
http://www.databaseadvisors.com/downloads.htm.

Extend your .Net application with Excel
Read at http://techrepublic.com.com/

Embed a spreadsheet or word document in a form
http://support.microsoft.com/?kbid=209990

Get on top of Administrator Accounts at Microsoft
Read at http://www.microsoft.com/

Unload all attachments from outlook to a folder
http://pages.infinit.net/rlevesqu/Scripts/ImportExport/SaveAllAttachmentsInOutlookFolder.txt

825433 Poor performance when you append data to a shared file-based database from a Windows XP-based client
http://www.kbAlertz.com/redir.aspx?kbs=193164

When to use Access and when to use Excel for data management. It is Ed’s guess that there will be a lot more of these articles in the next year as Microsoft rumors have the major changes in Access being to attract Excel users to store their data in a proper tool.
http://office.microsoft.com/en-au/assistance/HA010429181033.aspx

A simple review of SQL where statements
http://www.databasejournal.com/features/oracle/article.php/3524736

Database projects in visual studio.net
http://aspnet.4guysfromrolla.com/articles/071305-1.aspx

Write a macro recorder with Visual Studio 2005
http://www.developer.com/net/vb/article.php/3523191

A proper case for Access
Read at http://www.everythingaccess.com/

How to check the service pack of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

Setting Auto-numbers to a certain number
Read at http://www.everythingaccess.com/

Access 2000 KB 903275
How to troubleshoot problems that you may experience when you try to activate an Office product http://support.microsoft.com/?kbid=903275

Access 2002 KB 903771 Information about the ability to uninstall Office updates
http://support.microsoft.com/?kbid=903771

Access 2003 KB 904427 You receive a "Norton AntiVirus 2005 does not support the repair feature" error message when you start an Office 2003 program http://support.microsoft.com/?kbid=904427

A huge page of introductory Access articles
http://www.ehow.com/list_1014.html

WRAPPING THIS EDITION UP

If you like this newsletter but would rather be reminded about it rather than have it popup in the ever exploding inbox, I have setup an Outlook Calendar item that will remind you to visit the newsletter page every 3 months. I was probably more interested in this type of online calendar item because I might be able to use it with our clients so I would be interested if anyone else thought it was a good idea.  

http://www.vb123.com/news/

Please let me know what you think about this idea and if you want to try one of your own, create a calendar item, choose the menu File ~ Save As ~ iCalendar

On a different note, Stephen Siegel writes

I finally went and bought your book and am looking forward to reading it. The excerpts I have read so far were excellent. On a funny note, I got it at Barnes and Noble, and since I wasn't sure of the exact title I searched on your name instead. First match: God and Baseball, Second match: America's addiction to alcohol, Third match: yours.

I would be interested to find out why there is no mention of Access 12 in any of Microsoft's announcements. Is this the end of Access? There are hundreds of thousands of developers that seem to be forced to change to another developer method for the future.  Your input and or opinions are appreciated. Thanks Stephen

Ed “The anecdotal evidence is that the next version of Access will start to pickup the momentum on the scant improvements in Access 2003. My thoughts on this are based on comments in the Access Advisor magazine that have indicated that the biggest team since Access 2 has been assembled for this version of Access. There also are murmurs that the next version will be focusing on getting more Excel users into Access which will be good for developers as it could increase the user base. Anyway, a larger development team will mean a much better and rounded product into the future even if the next version doesn’t match the achievements of Access 2 and Access 97.

On a related note, one of the team leaders at Microsoft noted in an email to me that he had viewed our list of Access requests at www.vb123.com/access2008/ and that a good number of those requests were working in the latest beta version. I guess that we will see but as far as I am concerned, my user base of 100+ companies is still pretty happy with Access and that is really what concerns me the most.” J

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
GR-FX Pty Limited
Sydney, Australia.
Ph +61 2 9340 7789 Fax +61 2 9665 8448
Software Resources http://vb123.com/

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

PS Don’t forget Garry’s BRAND NEW Workbench 4… Shutdown your database, send messages to users, colored icons, MRU's, lots of other relevant stuff.

http://www.vb123.com/workbench/

Click on this button to read the previous edition of Access Unlimited 
Published  2005-06