What frontend application to use going forward?

[joejack0330]

We have been using Access 2000 .adp runtimes going against our SQL 2005 databases and have worked great for years now but going forward to Access 2007, there are many problems with runtimes and from some that I have read, Microsoft is moving away from .adp's and recommends going to .accdb and that .adp's will not be supported in the future? To convert to .accdb would be a huge project for many reasons so we are thinking of what would be the best way going forward. Maybe VB as frontend but that would be even a bigger project and don't see any built in reporting functioning other than using Crystal which is another thing.

Just curious to see what other people are doing and what might be the best way to go forward.

Thanks,
Joe

 

[mrdenny]

You can use a VB.NET or C#.NET as your front end. Then use either the built in Crystal Reports or SQL Server Reporting Services for your reporting needs.

You can also build a web based system in ASP.NET.

I'd learn towards the web based system as they are easier to upgrade as you don't have to worry about client code.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[joejack0330]

Thanks for the input. I think the forms might not be too bad in either asp or vb but the reports worry me a little because we are a big production warehouse environment and do all our own invoices and a few hundred thousand labels a week all with barcodes. I haven't looked too much at Crystal but don't think the sql reporting will be good for that kind of stuff. It might end up being combination of Crystal and SQL reporting.