Communication between Web and Windows application

[Jochen Neyens]

We're in the process of developing an e-commerce application that vets can
use to order medicines. One of the requirements is that the web application
can communicate with a locally installed practice management application
that uses MS-Access as a backend database. This way shipped e-commerce
orders can we imported in the practice management application to update the
stock levels of medicines.

The web-application will be written in ASP.NET / C#.

My question:

Which technology should we use to communicate from within the browser with
the MS-Access backend of the practice management application? I was thinking
of writing an ActiveX control using C# and let this sign by Verisign. Will
this be a good solution? Is there an alternative solution? The interface
will be used by approx 1500 clients. An important aspect is the ability to
deploy code via the Internet. The current order application is written in VB
5 and needs to be installed from a CD-Rom which is a nightmare for code
updates. This has to be replaced with an ASP.NET application whilst
maintaining the ability the synchronise data with the locally installed
practice management application.

[Jochen Neyens]

Mark,

The MS-Access DB from the locally installed practive management application
is from another software vendor. We can only insert data at MDB level. We'll
be using SQL server as backend for the web application but we need to find a
way to push certain data to the local MDB file via the browser. Each vet has
its own practice management application, provided by various software
vendors. We 're to provide a bridge to these application since the current
(windows based) order application also provides this.

Thanks,

Jochen

"Mark Rae" <ma**@mark-N-O-S-P-A-M-rae.co.uk> wrote in message
news:er******** ******@TK2MSFTN GP09.phx.gbl...

"Jochen Neyens" <jn*****@anal yz-it.be> wrote in message
news:eX******** ******@TK2MSFTN GP09.phx.gbl...

Firstly, MS-Access, even the very latest version is totally the wrong
solution for this! As has already been mentioned, you're limited to 10
concurrent web users this way. When the 11th concurrent user tries to access the site, they will sit and wait until a connection to the Access database
becomes available. Really. Forget it!

Secondly, is there any necessity to deploy local code at all? Why not just
go for a browser-based solution? That way, all your 1500 users require is a connection to the Internet (which they would need anyway under your scenario in order to do the data synchronisation ) and a web browser.

I can virtually guarantee that the money you'll save in deployment and
maintenance will far outweigh your initial outlay in SQL Server.

[Mark Rae]

"Jochen Neyens" <jn*****@anal yz-it.be> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

The MS-Access DB from the locally installed practive management application is from another software vendor. We can only insert data at MDB level. We'll be using SQL server as backend for the web application but we need to find a way to push certain data to the local MDB file via the browser. Each vet has its own practice management application, provided by various software
vendors. We 're to provide a bridge to these application since the current
(windows based) order application also provides this.

Wow! Seems unnecessarily over-complicated... However, I think the only way
you're going to get a web page to insert data into an Access database which
resides on the client machine is via ActiveX.

Will each client machine have a full copy of Access installed, or just the
actual .MDB file?