database opens/closes very slowly.. 1

[cityrock]

Hi all.
Using a back end that sits on window2000 server, we have a couple of
users connecting through a front end with a local network to the back
end.
Some more users connected through the internet with terminal services.
The people connected with TS, dont have any problem ,as they are all
working on the server itself.
But the people in the local office, connected with the front end
through the LAN, are expiancing very slow opening and closing of the
database.
Some times it takes more then 5 minutes, from when they close the
front end, until the window closes.
Sometimes we even get the "ERROR with ACCESS, do you want to send to
microsoft...".
Anyone can help me?? some computers are faster then others, all using
windows xp pro.
Thanks in Advance,
Eli Gur

 

[ShawnR]

I'm having the same problem with opening when the 2nd or 3rd etc user opens the database. I'm using a front end and back end. The probem arose when I move the main forms to a new database(i was having probs with the original database and imported everything to a new database). This is when the users started experiencing 5+ min open times. I am using access 2002 on windows XP.

 

[tonyflavell]

Hi guys
This is a common problem with all flavours of Access.

The answer you want is located at

http://www.granite.ab.ca/access/a2kslow.htm

Let me know how you get on.

regards

 

[Hap007]

Tony,

Good link to a great deal of suggestions,
here is a star from an interested viewer.

Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer

 

[tonyflavell]

Why thank you kind sir!