How to get Access 2k VB Function to work with VB.Net???
Posted on 2008-06-16
I have a front/end Access 2k Disptaching application connected to a MySQL back end server for a client. Currently we have a xmlgateway vehicle tracking service for which inbound transactions are posted directly to the MySQL server tables and this all works and was developed by a web developer. Now, on the click of a button, I have to make the Access 2k front/end application send a basic text message to a vehicle through the xmlgateway. I have the format and structure of the SendOutboundMessage Function provided by the tracking company and it uses VB.Net which is what I'm trying to get a clear understanding on how to make this work since the application is written in Access/VBA.
1.) Obviously I will need a copy of VB.Net to write this function and the question is since the application is Access/VBA, will the entire application have to be converted to VB.Net or can the application use both as long as they both exist on the machine???
2.) Also, at the client site, this appliation is used on several machines and they already have VB.Net on there web server because they can process the InBound transactions. If I include this function in the Access Front End, will all machines have to have VB.Net installed on them???