Multi User and slow database

J

John Maclain

I am looking to adress 2 "problems"

I have a database on a network.

The network consists of 3 PC's (no server).

The database is housed on one of these and the other 2 PC's work across the
lan.

The first issue is speed - the database has been operational for about 7
months and has collected 4000+ line entries.

It is noticably slower on searching and opening - is there a way around this?

The second is the fact there are 3 users entering/updating and searching
across the database. Is there a way for access to show new data to the other
users without the need to close and reopen the database?

any info/links would be much appreciated.

TIA
 
J

John Maclain

I have looked at splitting the database and have read other peoples topics.


I am a fairly novice access user and am woried about the switchboard
becoming "useless"?

Any helpful hints?

TIA
 
J

John Maclain

Thanks for the tips!

generally if someone tries ANYTHING new on an original database - without
making a backup - they should not be using a PC :)

Will try the split this afternoon. Fingers crossed!

Again thanks for the help!
 
J

John Maclain

Just an update:

I have done a compact and repair and split the database.

I then copied the front end to each machines desktop (including the host
machine)

I now get like an arrow infront of the tables? does this mean it's linked ok?

Everything appears to work fine and there is a noticable increase in speed!

Many thanks!!

John Maclain said:
Thanks for the tips!

generally if someone tries ANYTHING new on an original database - without
making a backup - they should not be using a PC :)

Will try the split this afternoon. Fingers crossed!

Again thanks for the help!
Click to expand...
 
Top