Multi-User Access Database

[Dave Cabbage]

Hi,

At work there is an Access DB which sits on a common server and is accessed
by multiple users (up to 9 concurrently). Sometimes this database "falls
over", is this because of the number of users or network problems etc.?

What is the best way to set up a Multi-User Access database?

Cheers

Dave

[Allen Browne]

Standard practice is to split the database into two mdb files.

The back end contains only the tables, and resides on your server.

The front end has all the other objects (queries, forms, ...), and linked
tables.

Details:
http://allenbrowne.com/ser-01.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave Cabbage" <la******@spammers.co.uk> wrote in message
news:l-********************@brightview.com...

At work there is an Access DB which sits on a common server and is
accessed
by multiple users (up to 9 concurrently). Sometimes this database "falls
over", is this because of the number of users or network problems etc.?

What is the best way to set up a Multi-User Access database?

[Dave Cabbage]

Cheers Allen!

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42**********************@per-qv1-newsreader-01.iinet.net.au...

Standard practice is to split the database into two mdb files.

The back end contains only the tables, and resides on your server.

The front end has all the other objects (queries, forms, ...), and linked
tables.

Details:
http://allenbrowne.com/ser-01.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave Cabbage" <la******@spammers.co.uk> wrote in message
news:l-********************@brightview.com...

At work there is an Access DB which sits on a common server and is
accessed
by multiple users (up to 9 concurrently). Sometimes this database "falls over", is this because of the number of users or network problems etc.?

What is the best way to set up a Multi-User Access database?