Re: Communication between Web and Windows application

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jochen Neyens (jneyens_at_analyz-it.be)
Date: 08/07/04 

Date: Sat, 7 Aug 2004 13:06:17 +0200

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" <mark@mark-N-O-S-P-A-M-rae.co.uk> wrote in message
news:erlL7z9eEHA.1652@TK2MSFTNGP09.phx.gbl...
> "Jochen Neyens" <jneyens@analyz-it.be> wrote in message
> news:eX9JIV9eEHA.1656@TK2MSFTNGP09.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.
>
>

Relevant Pages

  • Re: Cannot Crete server object
    ... Contact your Software Vendor. ... It is not a SQL Server error, ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server 2005 ?
    ... >> There is an application running SQL Server 2000. ... >suggests upgrading the product. ...
    (microsoft.public.sqlserver.server)
  • Need info about SQL Server Bug #469751
    ... I have an issue with an application using SQL Server 2000 SP3a that causes the database to dump an ACCESS_VIOLATION. ... The support organisation of my application software vendor says it´s a SQL Server bug. ...
    (microsoft.public.sqlserver.server)
  • SQL Server 2005 ?
    ... There is an application running SQL Server 2000. ... software vendor suggests upgrading the application to a ...
    (microsoft.public.sqlserver.server)