Front end for multiusers

  • Thread starter Thread starter Andrew Ofthesong
  • Start date Start date
A

Andrew Ofthesong

Hi, i have a backend and front end mdb.... they're going to be used for
about 10 users (can be same time)

¿any problem that they use all the same front end, from a shared folder, or
should i copy it 10 times?

¿any considerations i should have at the time of coding?
 
Andrew Ofthesong said:
Hi, i have a backend and front end mdb.... they're going to be used for
about 10 users (can be same time)

¿any problem that they use all the same front end, from a shared folder, or
should i copy it 10 times?
Click to expand...

Copy it ten times. Multiple people in the same front end leads to corruption
problems.
 
Any considerations i should have at the time of coding?
Click to expand...

Off the top of my head:

Back up often.

Be real mean about network usage: always base forms on queries and make the
queries as tight as possible, in order to minimise locking conflicts and
general delays. EG

SELECT Height, Weight, Volume
FROM Boxes
WHERE BoxNumber = 307

rather than

SELECT * FROM Boxes

Back up often.

Get the server to do as much work as possible: use SELECT COUNT(*) not
rs.RecordCount and so on.

Back up often.

Always specify the type of recordset you are opening; use snapshots if you
are only looking up stuff; never open table-type recordsets.

Back up often (did I mention that?)

There are more tips on perfomance and split dbs on Dev's site
http://www.mvps.org/access/


HTH


Tim F
 
In addition to the other very valid comments from Rick & Tim:

I have several A97 databases on a server in shared folders that are multi
user accessed with very few problems. These databases are available to over
100 different users, with an average access of up to 15 users at a time. The
server does nightly backups.

All front end databases are MDEs vs MDbs.

And yes, corruption does occur occasionaly, but not often.

If you are distributing the databases to other other computers, I highly
recommend using MDEs for the front end.

hth,
Andy
 
Back
Top