Trying to add a record in MSysUserList

DistillingExperts
DistillingExperts used Ask the Experts™
on
Hi,

I have an application which I used to be part as user in the MSysUserList table. My user name is not there anymore and I cannot find who removed it. I have admin rights to the database in SQL Server, which the application is linked and to the group which the workgroup file is added. However, the New Record option is grayed out for me.

How to solve that? Where this MSysUserList table and its data come from?

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
How are you opening the Access database if you are no longer a recognised user?

Author

Commented:
For this workgroup file, it doesn't require password. I can open read-only, but get a permission message if try to modify the design, for example. However, I only want to add my user name and put it there as admin.
You will not be able to do that. Access will prevent it.

You will have to use a dummy database and then create a new security file (,mdw) using the names and PID values that were used to create the original .mdw file.
You should then be able to use the new .mdw file to open the 'problem' database logging in as the administrator.

I guess I also need to make you aware that on this site no-one is allowed to post solutions which involve 'breaking' security-  no matter what the cause.  If you are not able to open the file using built-in features of Access then you will have to look elsewhere on the net for a solution.
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
If it doesn't require a password, how do you log in, and how does Access know which user you are? If you're using ULS, and you don't login, then in most cases you are logging in as the Admin user.

Are you prompted for a username, but not a password? If so, then that's not a typical Access ULS login - it was custom built by someone for that application, and you'll have to consult with that person to determine where/how the credentials are presented.

If you don't log in, but you simply open the database directly (i.e. you doubleclick it, or you open Access and then open the database), then you might have an issue with a corrupt database, or with a hanging Lockfile (i.e. the .lbd file). If so, then perform a compact, or build a new, blank database and import everything into that new database.
Scott  - I would remove the password from Admin-  as long as the default Admin user can only do things I want them to do (and so are not Administrators).  Obviously this only applies where you don't need the username or are getting it from Windows.

When I want to log in as an administrator I use a shortcut which supplies username and password.  

This setup means you can distribute the app to anybody/everybody without including an .mdw file.  I just make sure that I have the true 'security' mdw which provides administrator Access.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<This setup means you can distribute the app to anybody/everybody without including an .mdw file.  I just make sure that I have the true 'security' mdw which provides administrator Access.>>

 I've done that in the past as well.  All the queries are set to RWOP in the DB and the default workgroup file is used.

 Everyone is then locked out of the app except if they access it through the FE, but the only thing they can do is run stuff.

Jim.

Author

Commented:
Ok,

I managed that by using "User and Group Accounts" and created my user there. For whom should I give the points? It is weird that still don't show my user name in the MSysUserList. Is there any other way to see that?

Author

Commented:
I will read again throw the answers and let you know. Thanks all for the help.
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
Scott  - I would remove the password from Admin-  as long as the default Admin user can only do things I want them to do (and so are not Administrators).  Obviously this only applies where you don't need the username or are getting it from Windows

Right - I've done that too, but wasn't sure exactly how the author was doing this. My thinking was that some HAD done what you describe, but the author was unsure of this ... hence my question.

Glad they got it sorted!!

Author

Commented:
Sorry for the long time awaiting. You guys were the ones closest to what I needed as answer. As I said, I used this User and Group Accounts within Access. The key point is that I had to copy the mdw file locally (it was in a different network location). That seemed to be the security issue.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial