By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,530 Members | 880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,530 IT Pros & Developers. It's quick & easy.

Access 2000 Network Database Freezes on Open

P: n/a
FMR
I have an Access 2000 application that has a backend database which
sits on the network and a frontend installed to each PC.

When the frontend is opened, users have to log on and then the
database opens their menu form with buttons for key activities.

The problem I am having is that the user is logging on then there is a
delay before the menu form opens (normally this is really fast) and
then the application freezes - they can't push any of the buttons or
use the menus.

I've done the usual - Name Autocorrect is off, all file/folder
permissions are correct etc. Any ideas?

Fiona
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
fi*********@hotmail.com (FMR) wrote in message news:<c5**************************@posting.google. com>...
I have an Access 2000 application that has a backend database which
sits on the network and a frontend installed to each PC.

When the frontend is opened, users have to log on and then the
database opens their menu form with buttons for key activities.

The problem I am having is that the user is logging on then there is a
delay before the menu form opens (normally this is really fast) and
then the application freezes - they can't push any of the buttons or
use the menus.

I've done the usual - Name Autocorrect is off, all file/folder
permissions are correct etc. Any ideas?

Fiona


I'd make a local copy of the backend and relink. That should tell you
if the network is causing the problem. Did you compact/repair yet?
Nov 13 '05 #2

P: n/a
FMR
>
I'd make a local copy of the backend and relink. That should tell you
if the network is causing the problem. Did you compact/repair yet?


If you run the whole app locally then speed is fantastic. This would
imply it's a network issue except for the fact that they have another
database application where both front and back end are run over the
network and it's faster than mine. The key difference is that my
application contains a LOT of VBA and their older app is all managed
through macros & queries. Is there anything I need to configure to
make mine run better? I've never had this problem before!

I've now managed to get a number of PCs logged on to the db without
freezing but the whole login process is very slow so I need to find a
solution.

Fiona
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.