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.
- Identify the database that you most proud off and convert it to run with a SQL Server backend.
- Do not stop when things get hard, solve all the problems.
- It would be best if you then started using that database in your day to day work
- 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
Brooks Writes: What are the choices for moving forms from Access to SS2005? Is there a form designer built in? If so, what is it called? Or do you need to use VB.NET in Visual Studio to do forms?
Garry: For forms you will need a .NET application and for reports SQL Reporting services are one choice. Initially though concern yourself only with getting your application to work with Linked SQL Server tables. Then move your queries to the backend then you will be in a position to worry about .Net forms etc. We sell a .NET convertor here