Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Best password method with time factor

Best password method with time factor

Best password method with time factor

8/19/22 I have read many posts about this topic but wonder, which is the best one for me.
I have an Access database and need protection but do not want anything too complicated.

I am thinking, give me ability to change the password say every 3 months.
And prevent someone hiring a knowledgeable Access person to get into our Table data.
I this possible?? Thanks.

RE: Best password method with time factor

I think you need to provide more detail to get a good answer. I'm just now seeing this for the first time, as I rarely check-in at TT anymore.

That said, here are some thoughts:
  1. Split database design. You did not specify your database design, but your tables should be in a separate database, always, whether that's Access, SQL Server, or something else.
    This will provide additional security for protecting data tables besides better stability with Access applications.
  2. What is the password for? The database? Why does it need to change every 3 months? Is it a password for the entire database? Again, split database design would likely help here as well, as I would imagine you could assign 1 password to the backend and a separate to the frontend, and then the frontend could expire. Or maybe, again never tried, you could have a different password for each different front-end database. I'd want to at least consider that if I were handling this.
  3. Not sure of the details here, nor if possible because I've not needed to worry about it, but I would also want to see if Windows authentication could be used here to simplify it all. Then if someone should no longer have access, you remove (or have someone remove) that user's permissions to the database/folder.
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: Best password method with time factor

Access ACCDB fundamentally are not secure.

Put your data in an RDBMS (e.g. SQL Server) and manage security there. Do not embed passwords in your connection string.
You can use DSNLESS connections via code, set the password for sign on at startup and use an ACCDE file to keep the password secure within the file. It has been a while, I'd have to search for specifics of specifying the sign on programmatically.

The old Through Access 97 .mdb's had workgroup security... It wasn't completely secure but the model worked but we are well past that now.

RE: Best password method with time factor

10/1/22 I want to discourage a couple of employees from stealing our Access database.
One of them did so years ago. And use it for himself. I want to make a simple login method. Nothing fancy. Nothing fool proof. Just to make 3 employees think they cannot get inside the file unless they know the password. Which we would change every 2 or 3 months.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close