Networking Problem

  • Thread starter Thread starter Brian Gallagher
  • Start date Start date
B

Brian Gallagher

Firstly sorry if this is the wrong forum

I have an application that when installed on a network runs like a dog even
when opening forms. The database has linked tables but the database holding
the data is less then 1mb in size.

On most screens the user is able to select a record from a list box and then
double click to view it however it takes about 30 seconds for the record to
appear. There is no complicated code all that happens is that the control
source gets changed dependeding on if a field value in a parent form is
filled it selected that record by using a where statement otherwise it opens
the table in data-entry mode with the table as the record source.

The system is running in Access 97. Are there any settings I need to change
ro check re-record locking?

Regards

Brian
 
Brian, this sounds like a network problem and not an Access problem. Are
all the users accessing the database directly. In other words, are there
multiple copies of the database being opened simultaneously. Running the
query from the original database could be the bottleneck. Try splitting the
database so that the main copy will only contain data and each user copy
contains the query. Having the query run on the user computer should make
things quicker than running from one central database.

Kelvin
 
Back
Top