473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Access / DotNet hybrid: yes it's possible

I am really impressed with this new (to me) capability MSFT has built. Check
out this picture:
http://www.kittest.com/AccessInterop.jpg
That's an Access form on the left, with a textbox to type your name in. Then
you click the button, and with a few lines of code you're launching a DotNet
form (on the right) which is picking up the argument you passed in. Not
shown in the picture is that you can then raise an event in the DotNet form
(including arguments) and your Access application can be listening for it
(WithEvents). There is also a Session-like name/value pairs capability for
global variables.

When DotNet first came out MSFT had a "conversion kit" that supposedly could
take your VB applications and convert them to DotNet. It didn't work very
well, and was probably doomed from day one. This new capability makes a lot
of sense to me, because now you can migrate an application one form at a
time and take as much time as you want for the conversion, and build the
infrastructural pieces (e.g. data access, error handling) exactly like you
want, not how some tool decides you'll want it.

The Interop Forms Toolkit is here:
http://www.microsoft.com/downloads/d...displaylang=en

It is positioned as a tool for VB6 apps, but as you can see it works for
Access as well. Not too surprising, since it is a COM-based solution.

-Tom.


Oct 18 '07 #1
5 3647
Interesting. This sounds like an upsizing tool to upsize stuff from an
Access application to the .Net platform. If this is a sort of upsizing
tool it would be quite handy for people (like myself) who have to
upsize/migrate Access projects (ADPs, mdb's) to the enterprise arena
(.Net). I have been doing this manually - almost like creating a .Net
application from scratch except that I have the Access project model to
follow. A tool like this could be a real time saver.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 18 '07 #2
Rich P wrote:
Interesting. This sounds like an upsizing tool to upsize stuff from an
Access application to the .Net platform. If this is a sort of upsizing
tool it would be quite handy for people (like myself) who have to
upsize/migrate Access projects (ADPs, mdb's) to the enterprise arena
(.Net). I have been doing this manually - almost like creating a .Net
application from scratch except that I have the Access project model to
follow. A tool like this could be a real time saver.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Somehow I missed the first message in the thread and cannot find it in
my newsgroup. Would you mind repeating the name of the tool you are
referencing?

Bob
Oct 18 '07 #3
>>
From: Tom van Stiphout
Date Posted: 10/18/2007 10:58:00 AM

I am really impressed with this new (to me) capability MSFT has built.
Check out this picture:

http://www.kittest.com/AccessInterop.jpg

That's an Access form on the left, with a textbox to type your name in.
Then you click the button, and with a few lines of code you're launching
a DotNet form (on the right) which is picking up the argument you passed
in. Not shown in the picture is that you can then raise an event in the
DotNet form (including arguments) and your Access application can be
listening for it (WithEvents). There is also a Session-like name/value
pairs capability for global variables.

When DotNet first came out MSFT had a "conversion kit" that supposedly
could take your VB applications and convert them to DotNet. It didn't
work very well, and was probably doomed from day one. This new
capability makes a lot of sense to me, because now you can migrate an
application one form at a time and take as much time as you want for the
conversion, and build the infrastructural pieces (e.g. data access,
error handling) exactly like you
want, not how some tool decides you'll want it.

The Interop Forms Toolkit is here:
http://www.microsoft.com/downloads/d...34de3c5-dc85-4
065-9327-96801e57b81d&displaylang=en

It is positioned as a tool for VB6 apps, but as you can see it works for
Access as well. Not too surprising, since it is a COM-based solution.

-Tom.
<<
Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 18 '07 #4
No, you got that wrong. It's not an upsizing tool, it's an interop tool
allowing a partial VB or Access application to run side-by-side to a partial
DotNet application, and to seamlessly communicate with each other. You have
to build the DotNet part yourself.

-Tom.

"Rich P" <rp*****@aol.comwrote in message
news:47**********************@news.qwest.net...
Interesting. This sounds like an upsizing tool to upsize stuff from an
Access application to the .Net platform. If this is a sort of upsizing
tool it would be quite handy for people (like myself) who have to
upsize/migrate Access projects (ADPs, mdb's) to the enterprise arena
(.Net). I have been doing this manually - almost like creating a .Net
application from scratch except that I have the Access project model to
follow. A tool like this could be a real time saver.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Oct 18 '07 #5
I didn't think it was going to be that easy.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Oct 18 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: alvis | last post by:
I need to write a windows service that will read a excell spreadsheet and either update a row in my sql db or insert the row. My question is how do i read excell spreadsheet row by row in VB dotnet
13
by: bill | last post by:
I am trying to convince a client that dotNet is preferable to an Access project (ADP/ADE). This client currently has a large, pure Access MDB solution with 30+ users, which needs to be upgraded....
7
by: RCS | last post by:
Okay, a rather 'interesting' situation has arisen at a place I work: I need to convert a database from Access to something that can be used over the web. I am currently maintaining and...
3
by: Jerome | last post by:
Hi there, I've got an MS Access application with multiple tables, queries, forms (and sub-forms!), reports ... It would be neat if that application could be migrated to ASP.NET since it...
3
by: Rahul Agarwal | last post by:
Hi In our web page we use a combination of HTML and server side controls and some of them have a custom attribute based on which we need to find and replace the values once the HTML is ready. ...
22
by: Deano | last post by:
Hi, I have a finished Microsoft Access app that we are distributing using an Access runtime. This works fine (mostly) but I'm sold on the advantages of dot.NET and upgrading to vb.NET seems...
1
by: Joe | last post by:
Is it possible to access VB.Net Assemblies from VBScript? I have a Visual Basic DLL that is accessed from VBScript. I would like to rewrite the dll in VB.Net. How would I do this, if it is...
3
by: Joseph Geretz | last post by:
Our application is primarily VB6, however we are migrating toward .NET and a newer architecture. For the time being though, we're stuck with a hybrid approach with our ActiveX client application...
2
by: Ben | last post by:
Hi all! I am confronted with this question if MS Access 2003 can consume a .NET 3.5 assembly or not. Is this possible? Thanks, Ben
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.