|
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 74
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. |
|
--- 1/2/2007 ------------------------------------------------------------------------------------------ |
|
Read the latest Access Unlimited newsletter online |
|
We are adding new items that this newsletter is based on into an RSS feed so rather than waiting for the newsletter every month or so, get into our RSS feed. http://www.vb123.com/news/rss1.xml
|
|
|
|
--- 21/12/2006 ------------------------------------------------------------------------------------------ |
|
Updated page on transferring Excel to Access |
|
A number of the Microsoft Access projects that I have been involved in are in essence rescue missions for spreadsheet systems that have outgrown themselves. With good design and a few compromises, you can turn these into database systems that have easier navigation for input for users, report equivalent output and they do not require spreadsheet skills to run. This article tries to capture the techniques that I have used over the years to get these conversion projects up and running smoothly.
|
|
--- 11/01/2007 ------------------------------------------------------------------------------------------ |
|
Data Mining with SQL Server and Visual Studio |
|
Data mining helps you to uncover hard-to-find facts about your business. This paper outlines this science and including discussions on how technology is not as important as business understanding.
|
|
--- 16/12/2006 ------------------------------------------------------------------------------------------ |
|
Moving Your Database To Access 2007 |
|
Article by Jan Fransen and Ken Getz on something's to get on top of when moving to Access 2007. Get to know Macro security model, ribbons, side bar, GUI and other things that will affect your Access 2000-2003 database. Also understand Access 2007 AccDB format.
|
|
--- 25/01/2007 ------------------------------------------------------------------------------------------ |
|
AUSSIE CONTRACT WORK |
|
In the last two newsletters I asked for skilled Access developers to to help us with our projects in Sydney, Brisbane or Melbourne. I now have met or have corresponded with some very talented people and we are keen to help you on your projects. So if are having trouble with an Access database, need help doing the tricky stuff like upgrading to SQL Server or simply need a mentor, call me on (02) 9665 2871 or email me at access@gr-fx.com Otherwise if you are a developer, I am interested in taking to people who can walk into a client's office, talk specifications, build good data models, sort out messy Access applications and keep the users happy. This is not full time work and may only amount to a single project or two a year. If this is you, contact me by email. Garry Robinson |
|
--- 16/12/2006 ------------------------------------------------------------------------------------------ |
|
Moving Your Database To Access 2007 - Visual Interface |
|
This section of this article describes why your Access database will look better.
|
|
--- 16/12/2006 ------------------------------------------------------------------------------------------ |
|
No More VBA for Mac Office |
|
Microsoft has stopped supporting VBA for the Mac version of Office.
|
|
--- 12/12/2006 ------------------------------------------------------------------------------------------ |
|
SQL Server Cascade update glitches |
|
If you have two separate fields in one table that uses referential integrity/cascade updates to another table, you will run into trouble upgrading to SQL server. This page discusses the problem. The message that you will see in the upsizing Wizard report will look like [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint 'tblDirtMovements_FK05' on table 'tblDirtMovements' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. |
|
--- 25/01/2007 ------------------------------------------------------------------------------------------ |
|
Repair Damaged Access Databases |
|
vb123.com now 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 and in most cases, you should be able to recover a corrupt database in less than 30 minutes elapsed time.
|
|
--- 7/12/2006 ------------------------------------------------------------------------------------------ |
|
Front page replacement-Expression-Web has been released |
|
The replacement for front-page has been released by Microsoft. There is also another product from Microsoft from the front page designed for SharePoint server.
|
|
--- 26/07/2006 ------------------------------------------------------------------------------------------ |
|
Garry's Access Security Book |
|
My book on protecting and securing Access databases received its 12th 5 star review at Amazon USA making it one of the highest rated Access books at Amazon. It looks like it's getting harder and harder to purchase the book so don't delay any more..
|
|
--- 1/11/2006 ------------------------------------------------------------------------------------------ |
|
Access Unlimited Newsletter 73 |
|
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 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
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.