no security needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm going to create a database that needs to be accessed by about 50 users at
a time. In the past I've created databases that lock and can not open
because it is already in use by other users. How do I create the database so
that all users can access it simultaneously without locking, with out
passwords or security requirements? Is 98 or 2000 better?
 
First, you'll need to split the database into a so-called "front
end/back end" (FE/BE) strucure. Google the Access groups for those
terms, if you don't know what they mean.

Second, you'll have to make sure that every Windows user who uses the
database, has full read/write/create/delete/whatever permissions to the
folders in which the FE and BE files reside.

As for whether 50 users will be able to use it simulatneously,
/successfully/, this depends on various factors, including:

o The speed & reliability of your network;
o The percentage of users doing updates (as opposed to queries);
o Their actual usage patterns: 10 simultaneous users doing tons of
work every minute, might create a far higher load than 50 simultaneous
users, each doing a single query per hour;
o The nature & quality of your sql and vba code.

Have you ever done a 50-user system before? If not, perhaps you'd
better check it out with a smaller number of users, before you roll it
out "for real".

HTH,
TC [MVP Access]
 
Back
Top