|
|
|
If you are in the unfortunate position of not having much paid work on in this global economic downturn, now is the time to upgrade your skills because if you are a skilled developer who can help people solve business problems, positive times will not be far away. So as it is likely that you are an Access practitioner, I suggest that the best way to improve your skills is to push into areas where Access provides a stepping stone. To me SQL Server is one of those areas and here is what you have to do.
1. Identify the database that you are most proud of and convert it to run with a SQL Server backend.
2. Do not stop when things get hard, solve all the problems.
3. It would be best if you then started using that database in your day to day work.
4. When that works, start converting the Access queries to Views, Pass Thru Queries and Stored Procedures
One thing you shouldn't do though. is become 100% immersed in your unpaid projects because its always better to write software that people need. For this, you will need to make sure that you attend conferences, participate in online forums and contact all the people that can help you get back into the thick of things. Good luck to you in your endeavours.
Garry Robinson from Sydney, Australia
|
|
|
|
You can download new help files for Access 2007
|
|
|
|
|
|
Luke Chung from FMS has written another one of his insightful articles on the dynamics of programming using rapid development environments such as Access, Excel and SharePoint. This one has been written with the motivation of the economic conditions but its a timeless piece. Read on
|
|
|
|
vb123.com offers an online repair system for Access databases. 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. Garry
|
|
|
|
|
|
Here is some code to strip out the DBO prefix on SQL Server linked tables
|
|
|
|
If you are still using Access 2000, 2002, 2003 or even Access 97, have you considered my book on Access security. Read the 15 5 star reviews at Amazon.
|
|
|
|
|
|
Switching between Access 2003 and 2007 improved a lot with service pack 1 of Office 2007. Even with that improvement, there have been many times when on opening Access 2007, I wish I hadn't. The latest version of the Workbench reduces that issue by warning when you are switching from one Access executable to another so that you can stop.
|
|
|
|
An article at Microsoft on Access 2007 validation rules by Allen Browne.
|
|
|
|
|
|
Article by Paul Zikopoulos mentions DB2 linked tables but it provides a good insight into the reporting wizards in Access 2007
|
|
|
|
Bumped into this article about a new operating system from Microsoft. Never a bad idea to rewrite your software so bring it on I say.
|
|
|
|
|