File Server

[GR]

Hi, I have a database which will reside in a file server
where at least 20 users will be using it. In my database I
have a switchboard for controlling the flow and guiding
the users, usually some forms visible property is turned
off and on. what will happen when all the users will start
using it? for example for userA formX es visible, but
userB needs formX to be visible... Sorry my english is not
that good, i hope I am explaining myself ok. the main
issue what considerations should I take to avoid multiuser
conflicts?
thx
gr

 

[John Vinson]

the main
issue what considerations should I take to avoid multiuser
conflicts?

Split the database.

Use Tools... Database Utilities... Database Splitter to split the
database into a "frontend", with the Forms, Reports, code and so on,
linked to a "Backend" with just the tables. Store the backend on the
file server, and give each user a copy of the frontend on their own
machine.

 

[Van T. Dinh]

The UI shouldn't be a problem since each user will run a copy of the
database on his / her desktop. However, to avoid corruptions, you should
(MUST, really) split the database into Front-End and Back-End.

Check Access Help on splitting a database.