Freezing Forms

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello,

I have a database with 6 tables, no more than 15 fields
in each, and 24 forms.

Each form is based on a SQL code typed into the Record
Source not a query.

I have a backend on the server, and a frontend on a
shared drive for each user. Each frontend is compiled as
a MDE file.

My problem is that the forms sometimes take ages to load,
about 2 minutes. They dont have much information on them,
about 5-10 controls. The computer isnt doing anything but
the database just comes up with "Not Responding". This
however does not always happen, sometimes it is very
quick as it should be. (It even happends on the
switchboard which doesnt have a record source only 5
buttons)

The total size for the database is only 2MB.
Is it anything obvious?

Thanks, James.
 
im not 100% sure, but my guess is network sluggishness
are you using linked tables?

if its that the network access is slow, then when you open
a linked table, you probably have to wait a similar length
of time

to test this out you might try copying the central file to
the hard disk of one of the workstations, link to it
locally, and see if the problem goes away

if you have SQL Server on any of your servers you might
try using that instead of access, and then use access for
the interface only.
 
Back
Top