I want to let other network users a 1

[zoe1]

I want to let other network users access to one MS Access database (located at one server) by providing their ID & password(this decides their permission).

is it possible? any Access security can do this?
user & gp/permission/ user-security-level?
what's the brief steps?

am i really have to creata a new workgroup?
will others network users can access it due to different workgroup?

 

[tlbroadbent]

You can set up Access security to allow designated users to open the database. You can grant only those permissions you want to each user. You will need to setup a workgroup file. If security is properly setup, unauthorized users will not be able to open the database.

See the following FAQs for more information about security.

faq181-1164
faq181-1131
faq181-83
faq181-641 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[zoe1]

Many thanks Terry, yr information is very helpful!

Regards,
Zoey

 

[Ed2020]

Alternatively, if you are running on Windows NT you can use Environ$("User&quot to return the user's Windows ID. This can then be used internally to restrict access to certain objects.

Sometimes a simpler alternative to MS Access security, which can be a little daunting if you have never used it before...............

Ed Metcalfe
ed_metcalfe@hotmail.com

 

[tlbroadbent]

The problem with using the network logon to internally secure the database is that method doesn't prevent users from opening the database independent of the code or attaching the tables in another database. They can then perform ad hoc data changes and even modify the schema.

You can use NT security to restrict/grant permission to the database but the entire database is affected rather than being able to setup security on objects in the database.

Access user security can be daunting but has become easier with each version. With the Security Manager add-in that can be downloaded from Microsoft as well as the FAQs and white papers available, you should be able to manage security quite easily. However, it does require understanding, planning and effort. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.