Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I integrate Access 97 and VB.NET systems?

Status
Not open for further replies.

BrianBurgit

IS-IT--Management
Dec 13, 2004
95
US
Looking for some advice regarding an approach to migrating an Access 97 based business system to a .NET version. Before economy crash, had a team of developers building a “new and improved” business system in VB.NET with a SQL 2005 database. No work was being done on the Access 97 system. About half way done when economy tanked and now faced with need to enhance Access 97 system. I do have an Interop module that I’m using to use some of my SQL Objects in the Access system. I would like to be able to build new windows apps using .NET and make them somehow available in or thru the Access application in a seamless fashion so it’s not clunky for the user. If this can be done nicely, then I can continue to develop the newer system and replace the old functionality piece by piece. Any ideas?

Thanks,

Brian
 
I would like to be able to build new windows apps using .NET and make them somehow available in or thru the Access application in a seamless fashion so it's not clunky for the user

I think you're going to have a difficult time making it seamless and "not clunky." You might even end up spending less time developing the new, SQL/VB based version than you will spend on getting the UI to behave nicely if you should tackle the WinForms/Access97 UI integration.

One alternative would be to retain the Access 97 backend database for now, migrate your UI and business rules tier to VB (still storing the data in Access), and finally finishing migrating the backend to SQL Server once that is complete.

 
Any idea if this would be an easier task if I migrated Access 97 to Access 2007?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top