Slow Performance - NEED HELP

[shamas21]

Hi everyone

I have 10 people running using 1 database on a network drive.

Its painfully slow. Can someone advise me and help me urgently as its hampering my companies performance.

Please
Thanks

 

[DCrake]

Questions to ask yourself:

Is the database split?
Does each user have their own copy of the db on their workstation?
Is the data normalised?
Is there a lot of records in the tables?
What data source is the back end in?

More Info

David

 

[shamas21]

Questions to ask yourself:

Is the database split?
Does each user have their own copy of the db on their workstation?
Is the data normalised?
Is there a lot of records in the tables?
What data source is the back end in?

More Info

David

Hi David

Please see the answers below.

Does each user have their own copy of the db on their workstation? We tried having the font end on each computer and have linked tables to the tables on the network drive but it made it even slower.

Is the data normalised? Yes

Is there a lot of records in the tables? around 20 tables and about 3000 records in each table

What data source is the back end in? Data Source is MS Access 2007.

Any suggestions?

Please let me know.
thanks

 

[mcclunyboy]

How large is the DB?

What are the network connections like? Possible network congestion?

Is it the whole database or when users attempt a query, report etc

Indexing is another area which maybe worth checking out

It could be one of a number of things.

Have you tried compacting and repairing the database (backup) ?

 

[gemma-the-husky]

two things

This MS knowledgebase article has lots of tips and tricks, especially the sharing violation registry entry

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


also, look at ways of maintaining a connection with the backend.

Keep a recordset open, or a form open but hidden.