Question Database speed issue - advice please?

[Johnrg]

Guys,
We have a MS Access database at work for our order and stock tracking.
I have done some of the design with a local programmer steping in and doing the rest.
The database, as it is, works well and has been very stable but our big issue is the database speed.
The database is split into backend and front end files that both sit in the same folder on our main work server. The users connect direct to the front end file throughour network neighbourhood.
Our PCs have 100bit cards and are running 2002 or 2003 Access and we have just upgraded our servers routing hub from 10bit to 100bit expecting a big improvement but its still very slow.
I compact and repair alot but it does not seem to make much difference.
Its OK with one user, but gets really bad when there is more than one user in the database, for example it can take up to a minute for the database login screen to fire up with a couple of users logged in.
I know there are heaps of varibales here, but can anyone let me know the general areas that I should be looking at in software and hardware to diagonse and/or help improve the issue?
The front end file is about 6mb, the backend about 11mb.
Any advice or help at all would be greatly appeciated.
Regards
JG

 

[stopher]

One thing I see is that you have the front end on the server. You should not do this. You should put a copy of the front end on each users pc i.e. they should be opening the front end locally and certainly not sharing the front end.

Chris

 

[rob.low]

Hi there
Do all your users Have their own copy of the front end on their PC's

as I understand it multi users should not be logging into a single front end of the database located on the network as you are pulling forms etc over the network, were if they have their own physical copy of the front end on the PC you are just retrieving and sending data over the network

I used the above method and my database and it speeded up substantially

regards
Rob

 

[rob.low]

One thing I see is that you have the front end on the server. You should not do this. You should put a copy of the front end on each users pc i.e. they should be opening the front end locally and certainly not sharing the front end.

Chris

You posted faster than me stopher lolll

 

[gemma-the-husky]

oine real issue is the way Windows shares resources, which can realt cause performance issues

look at this article, particularly with repsect to the "sharing violations notification issue"

http://support.microsoft.com/kb/889588