Security

[Paul Chernoff]

It occurred to me that the Access database I inherited doesn't have any security on it. Where do I look for adding accounts and passwords. First I would like to lock up the database and have separate user and developer accounts.

 

[CJ_London]

Security is a big topic. Before applying a solution you need to create a security policy to define who can do what and what you want to protect, from whom and by what means.

if you look to the bottom of this thread you will find a number of links to similar questions.

Alternatively google something like 'access security' for answers from other forums

At its simplest you would have a user table which depending on your policy would contain user permissions and password. You might want to use the windows login details or use your own.

 

[Paul Chernoff]

I plan on rewriting this database from scratch in the next few months once I figure it out. That will have security as part of the design, I am concerned that reworking security backwards will take at least as much work and more likely to have holes in it Fortunately most users will work with only a limited amount of data.

 

[CJ_London]

am concerned that reworking security backwards will take at least as much work and more likely to have holes in it

you're not wrong - security should not be considered as an afterthought.