April 19, 2006 at 11:40 am
Hello,
I have been tasked to upgrade @50 access db’s to SQL. I would like to know what would be a viable front end for this project. I’m proficient with VB6 and little else. Management will provide me with training but I do not know what I should be learning… C Sharp, Java, .net any ideas?
Thanks,
Marty
April 20, 2006 at 4:15 am
Hi
The 'easy' answer is that it really depends on what you're going to feel most comfortable with - after all, you'll no doubt end up supporting the application when it's complete, whatever it's written in.
If you're comfortable with VB6 then you may want to take a look at VB.Net - while there are some key differences to VB6 it's not too difficult to move over to .Net (the language syntax is virtually the same if not identical) and there's plenty of material out there (a lot of it freely downloadable from MSDN/the net) to get you started. You may want to have a look on MSDN for the "Getting Started in VB 2005" ebook (fairly sure that's the title anyway) before making any decision as it steps you through some development areas which may reassure you that the step isn't that big for you.
Cheers
Martin
April 20, 2006 at 6:51 am
Access would also work as a pretty decent front end. If you've been doing Access development, then it has the advantage of familiarity. You can either use Access Data Projects (which are specifically designed to use a SQL Server back end, and allow you to manipulate SQL Server objects in Access), or a regular Access MDB with either linked tables or pass-through queries.
Though, the products you quoted are mostly web tools. Do you want to get away from the desktop environment, and go web-enabled? If so, I'd recommend VB.Net and ASP.Net. That should have the most familiarity for you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply