|
vb123.com |
|
|
Home Contact Us Order our Software
RSS &
Newsletter
Get Good Help
The
Workbench
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
Garry's Blog
About The Editor
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
or try our Aussie
|
Is Your Database Corrupt
?
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/toolshed/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
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/toolshed/news/toc.htm
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 Toolshed 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 9665 2871 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