VB6 App On MS Server

I have a VB6 application front ending a Access Database running in a
LAN with 6 concurrent users. All has been running very well with no
performance issues.
When we moved the application to a remote MS Server, we seem to be
experiencing some problems with less than stellar performance.
Here is how we have things installed:
The server hosts both the Access Database and 3 executables that make
up the entire project.
Each of the PC workstations have the OCX's, a dll, and all the
components required to access the database.
Generally speaking all of the workstation load "Program A" from the
server, which is an inquiry program into the database (No data
modification allowed).
The other 2 program are used occasionally to maintain the database.
When we attempted to run one of these maintenance programs, it
eventually seemed to hang, with the task manager on the workstation
saying "Program is not Responding".
Without getting into the gory details, the program reads all 12,000
records in the database, and is expected to create about 1800 new
records as a result of search. We have restarted the program several
times each time it would fail with the same result. In desperation we
copied the database and the executable involved to one of the
workstations, ran it without any problem whatsoever, then copied the
database back to the server. Fortunately this is done only once a
year, so I have a bit of a reprieve to find a solution to the problem.
BTW we had terminated all user of the applications so that we were the
only workstation accessing the database.

I have no experience in setting up an application in the environment
as I described so any suggestions with my application or how it is
implemented on the server would be greatly appreciated.

Thanks in advance.



.

Relevant Pages

  • Re: ASP and Access Database queries
    ... http://www.bellfield-barna.com/ is running on an Apache server running ... which doesn't support ASP and Access. ... My Access database is situated in my office. ... I have an Access database where I would like ...
    (microsoft.public.frontpage.programming)
  • Re: Problems networking Access
    ... linked to the backend on the server. ... When I enter records into the database from the workstation, ... A good approach is to build some type of search form, ...
    (comp.databases.ms-access)
  • Re: ASP and Access Database queries
    ... than give me some ideas why the FP Wizard is not fing my database? ... http://www.bellfield-barna.com/ is running on an Apache server running ... My Access database is situated in my office. ... I have an Access database where I would like to ...
    (microsoft.public.frontpage.programming)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading