Hi Chris,

I would recommend VBA too and totally agree it will be very hard to you to find a new VB 6. Actually, Microsoft still sells it but you will have to pay the same price as Visual Studio what would be paying for more than what you get.

Another good option is to migrate to .net because it will be a lot easier to work with it when you go to Longhorn and you dont need to spend a dime for that, just do a download of a free tool to develop and choose which language you prefer to use from VB.NET or C# (better support for C# with intellisense).

Download Sharp Develop at: http://www.icsharpcode.net/OpenSourc...spx?What=Setup

You can even migrate you Access database to a SQL Server 2000 free of charge using MSDE, downloadable from here: http://www.asp.net/Tools/redir.aspx?path=msde (database size limited to 2 Gb).