|
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 News - Edition 82
See all newsletters
Independent news for enthusiastic Microsoft Access and Office readers
| Produced by Garry Robinson from Sydney, Australia. |
| Australian
Readers ~ Access Development/Office
Automation Advertisement If you need help with an Access database such as upgrading to 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) 9665 2871 in Australia or email me. http://www.vb123.com.au/professionals/ Garry Robinson, Office Access MVP award winner. |
--- 27/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Read the latest
Access Unlimited newsletter online |
||
| Greetings to
all of you from Sydney Australia. Whilst I have been discussing Access databases with managers and IT staff this year, I have often heard the phrase "We don't support Access databases". I then ask the question, do you support Excel and the reply is "yes but we don't support macros (VBA)". So here are three questions to YOU, the readers. Have you noticed this behavior? What parts of Access should IT staff support as a minimum ? What are three things that IT help teams should know about Access so that they can provide at least some support? You will find my email address at the top of this page so let me have some feedback on this topic and I will write up your notes for the next newsletter. http://www.gr-fx.com/ Enjoy the newsletter and if you live in Sydney or England, check out the good value conferences coming your way VERY soon. Garry Robinson Access MVP and Editor of vb123.com and vb123.blogspot.com |
||
--- 26/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Access Team Blog ~ Ryan McMinn Joins the Access team in Seattle.
|
||
| When I was in
Seattle earlier this year, Ryan McMinn gave an inspirational talk on
connecting Access to online services such as Amazon. In this article
Ryan discusses Ruby On Rails in brief and how his previous company was
involved in a project that had both a Thick Access interface on the
local network and Ruby on Rails as the web interface to the same mysql
backend database. Well done to Ryan on joining the team at Microsoft,
your experience with hooking into online databases will be great for the
future of Access. |
||
--- 28/09/2007 ------------------------------------------------------------------------------------------ |
||
|
Free Sydney Office
Developer Conference |
||
| We’d like to
let you know about a community lead event taking place in the Sydney
Microsoft Office on the weekend of November 3 & 4. The event has been
organised by Australian Office- Access MVP, Graham Seach, and is being
hosted at the Microsoft Sydney Office at North Ryde. We would like to
encourage attendance of staff working as Office Developers. It’s a free
event afterall… Office DevCon is a community-driven event aimed squarely at Microsoft Office developers and power-users. It allows people with interests across the Microsoft Office platform to come together in one location to network and hear expert presenters speak on a wide range of advanced Office-related topics. The purpose of this event is to help you take your knowledge and skills to the next level by learning advanced topics from Microsoft and industry experts from around the world. You can learn more, review the agenda and register at http://www.block.net.au/devcon/index.htm Seating is strictly limited, so please be quick to secure a seat at this technical, Microsoft Office Developer event. |
||
--- 27/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Garry's Access blog |
||
| Been quite a
few small snippets and links posted on my blog in the last month
covering topics such as SQL Server 2005 Express Edition - Easy Setup Microsoft Overhauls Data Protection Manager Removing Time from a date field Open a form and find a record Pickup Only in EBay Log Me In ~ a remote desktop support program Enjoy |
||
--- 23/10/2007 ------------------------------------------------------------------------------------------ |
||
|
UK Access User Group National Seminar
|
||
| The next
Access User Group seminar will be on 16th of November at Microsoft's
Offices in Reading. Topics include: Office 2007 Client Developer Features Application Development - Sharepoint As An Alternative Tool to Access Application Development - Working with Access 2007 and SharePoint Together Access 2007 Is Great - No It Isn't - Yes It Is - No It Isn't: Converting SQL from Access to SQL Server Overview of Office 2007 Choose Seminars Hyperlink |
||
--- 26/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Search Engine Optimisation |
||
| A good page on
search engine optimisation. "More important than all said on that page
is to write useful content" Garry Robinson 2007 |
||
--- 12/10/2007 ------------------------------------------------------------------------------------------ |
||
|
2007 Microsoft Office
Security Guide (software) Beta Program |
||
| This software
(called a solution accelerator*) provides best practices, pre configured
security settings, and automation tools to help IT-Professionals quickly
and easily deploy security configurations for the 2007 Office release
across mid size and enterprise-level organizations. * Microsoft says "Solution Accelerators from Microsoft are free, authoritative resources to proactively plan, integrate, and operate your systems. Designed in collaboration with industry experts and tested in real customer environments, Solution Accelerators give you prescriptive guidance and automation to achieve high-performance, cross-product IT infrastructure from both new and existing systems without reinventing the wheel. " |
||
--- 26/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Facebook worth 15 billion, Microsoft thinks so. |
||
| Microsoft
purchases a small slice of facebook for a lot of money. |
||
--- 27/10/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 |
||
--- 11/10/2007 ------------------------------------------------------------------------------------------ |
||
|
A great overview on MS Access 2007 |
||
| Allen Browne
provides a significant overview of the good and the ugly in Access 2007
|
||
--- 17/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Access and the Kaspersky Anti-Virus |
||
| I have just
installed Shield Delux 2008 as my antivirus (it calls Kaspersky
Anti-Virus) and it works well on my laptop, it is the first time I have
ever been able to work whilst a full scan was happening in the
background. One problem is that the software actually detects when you
first run VBA code in an Access 2000+ database. Read more about this on
Alex's blog. To turn off the Access/Office protection in Shield Delux, head to Proactive Defense settings and review your Office Guard settings. |
||
--- 9/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Updated
Page On PDF Creation to Include Access 2007 PDF generator |
||
| Access 2007
has an add-in to create PDF Files, here are the VBA commands to drive it
once it is installed on your computer. |
||
--- 9/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Open Office has a database
|
||
| With the
latest download of Java from Sun, you now can easily download the free
OpenOffice suite. The wide install base of Java will mean that the Open
Office platform will receive a boost in numbers because lets face it,
when faced with a choice of free and pay for MS Office, many home
computer users will adopt the free package. Anyway in OpenOffice is a
small database product called Base that can do things with Access
databases plus it has its own database. This looks a bit version 1.0 but
with Google's version 1.0 of its database released a few months ago,
maybe finally Access will have a competitor that Microsoft will worry
about. Read more |
||
--- 7/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Where are the commands in Access 2007 |
||
| This Microsoft
Flash demo tells you where commands can be found in Access 2007 that you
might expect from 2003. ie When you hover over the Print button on the
2003 toolbar, the demo tells you to click on the Microsoft Office
button, point to Print and then choose Quick Print. |
||
--- 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 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 Microsoft Office Access MVP |