By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,062 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,062 IT Pros & Developers. It's quick & easy.

Jet User-Level Security

P: 58
I was creating a Jet User-Level-Security following some instructions. I created an user name called “student1” and what I don’t understand is why now every time I open a DB Access file it shows a Logon window asking me a Name and Password. I was never intended to create an account for me. I tried to delete it and it doesn’t allow me. My intention is to continue being the admin to create user accounts for a group of user and limit them with some permission. Is there a file that I can manipulate user accounts without login? or how can I be an admin again and be able to create and delete user or group accounts. I have MS Access 2007. If anyone can give a hint on this, It will be greatly appreciated.

plaguna
Aug 19 '08 #1
Share this Question
Share on Google+
10 Replies


100+
P: 167
hi Plaguna!

It seems your database is now joined with new .mdw file that holds user, groups, permissions etc.

You need to find that file (.mdw) and open it using Log-on.
Inside you can add/change user accounts

To locate .mdw file you can put this in you immediat window (CTRL+G) in any module you have in your database and press Enter:
[HTML]DoCmd.RunCommand acCmdWorkgroupAdministrator[/HTML]
Now wizard will open showing you workgroup file currently joined to your database.
To create new .mdw file click Create (make sure to creat one user name with admin permissions)
To join to existing .mdw file click Join and locate the file
To clear all joined .mdw files click Join and then delete the current path (access will then automaticaly join your database to it's default .mdw file)
Aug 19 '08 #2

NeoPa
Expert Mod 15k+
P: 31,494
As you've added a new user to your .Mdw file, it now has more than the simple default of Admin with no password and needs to ask you which you need.

Consider adding a password to the Admin account and using that when you want Admin access.

PS. I would read up on the subject before going further into it. It is not as straightforward as most people would like it to be. It can cause lots of problems for the unwary.
Aug 20 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
It is not as straightforward as most people would like...
Indeed! It actually resembles a corkscrew! Which is why Micro$oft finally dropped it altogether in v2007!

Welcome to Bytes, plaguna!

Linq ;0)>
Aug 20 '08 #4

NeoPa
Expert Mod 15k+
P: 31,494
Thanks for that Linq. I suppose that means they didn't do EVERYTHING wrong in A2007 then ;D
Aug 20 '08 #5

missinglinq
Expert 2.5K+
P: 3,532
Nope, just "almost" everything! The single most telling statement I've heard about v2007, made by someone (can't remember who, but a heavy weight developer) on the MS Access newsgroup, was that the learning curve for v2007 is about three times as big for an experienced Access developer as it is for a newbie!

Linq ;0)>
Aug 20 '08 #6

NeoPa
Expert Mod 15k+
P: 31,494
Wow!

That's not a light point. Very telling indeed.
Aug 20 '08 #7

missinglinq
Expert 2.5K+
P: 3,532
It is indeed! I think Access 2003 is going to follow the lead of VB6. I took a VB6 course, the year before VB.Net was released, given by an old VB hand. He'd run his own VB shop since the beginning. This guy's first programming job, while he was still in college in the '60s, was writing code for NASA! He just knew, that VB.Net was going to eradicate VB6 from the face of the earth! I argued the point at the time, but he remained convinced. I happened to see him out shopping last week, and before I could say anything, he said "I know! You were right! VB6 is still alive and well!"

I think Access 2003 is going to do the same thing. I think 2007 is such a radical departure that people will continue using 2003 long beyond it's natural life span!

Linq ;0)>
Aug 21 '08 #8

NeoPa
Expert Mod 15k+
P: 31,494
LOL

Yes, they (MS) have been doing a lot of that sort of thing lately. XP could be better but it's still more popular than Vista. I can't see that changing any time soon either.
Aug 21 '08 #9

P: 58
Thank you guys for your input.
Sep 2 '08 #10

NeoPa
Expert Mod 15k+
P: 31,494
You're welcome :) I hope we were able to help somewhat.

Welcome to Bytes!
Sep 2 '08 #11

Post your reply

Sign in to post your reply or Sign up for a free account.