newbie wans to create usernames & passwords on inherited .mdb

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

Guest

I have inherited a database that has an .mdb on its central server, however,
the developer has left and I need to set up loads of new users with usernames
and passwords. After that I need to set a .mde? as the team that will be
using it do not have access on their PC's. Can anyone talk me through it in
real layman's terms and any neccesary annotated code would be most
appreciated.
 
fishy said:
I have inherited a database that has an .mdb on its central server,
however,
the developer has left and I need to set up loads of new users with
usernames
and passwords. After that I need to set a .mde? as the team that will be
using it do not have access on their PC's. Can anyone talk me through it
in
real layman's terms and any neccesary annotated code would be most
appreciated.
Click to expand...

There's no such thing as "layman's terms" on user-level security I'm afraid.
You'd need to be prepared for hours of reading (using the MS FAQ, link on my
website) and experimenting using dummy files.

An mde will not run on a PC that does not have Access installed. AIUI you'd
need the Developer's Edition of Access to distribute a run-time version of
Access with your application.

Regards,
Keith.
www.keithwilby.com
 
Jumping in here (cos I can not see the original post):

Further to Keith's good points:

1. How many users do you mean by "loads"? Access has an absolute upper
limit of 255 simultaneous users. The actual limit can be very much less
than that, depending on various factors.

2. You should not have all the users sharing a single mdb file. This is
commonly believed to increase the chances of file corruption. Instead,
you should split the database into a so-called front-end/back-end
structure. This has other advantage besides reducing the risk of file
corruption.

If all of the above sounds lilke absolute goobldigook, then, you should
probably not be doing this work until you learn more about Access,
and/or get someone more experienced to help you out.

HTH,
TC
 
Back
Top