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

Multi-User Access Database

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a
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?


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.