Security File Error after converting from 97

[Peggy]

When I try to change user permissions or do any other
security function I get the following error message:

"Records can not be read,no read permissions on
MSysAccounts"

The only solutions I have found documented is to recreate
the mdw file, but... I do not have the workgroups name,
organiztion or WID. Do any of these password recovery
sites retrieve this information also?

 

[david epsom dot com dot au]

The problem was, unless you had a certain obscure
permission on the original database, the permission
for that table did not come across correctly.

One solution is to create an unsecured copy of
the Access 97 before attempting the conversion.
Can you do that?

(david)

 

[Peggy]

I can create an unsecured database before I convert it,
but I am trying to avoid loosing all of the groups, users
and security information that is already setup in the
database.

 

[david epsom dot com dot au]

1) I misread the question.

2) Apply all Access and Jet service packs before doing the conversion. I thought this was one of the problems that had already been fixed.

3) Review your code: do you get the error message when trying to /change/ user permissions, or when trying to /read/, or when trying to /refresh/. Can you ignore the problem?

4) Yes, database crackers can break all the security on an Access database.

5) Try this (in A97, or A2.0 if you still have it)
"You typically get an error if you try to read the information in these tables and you are not a member of Admins, because these tables are set up with no permissions for any other users or groups. Because the workgroup information file is just a Microsoft Access database, you can open it directly while logged on as a member of the Admins group. Assign Read Data permissions to these two tables for selected users or groups (assigning permissions to the Users group will grant it for all users). "

"These are the steps required to provide group membership information to selected users and groups. It assumes the name of the workgroup file is System.mda.

1.. Make sure you don't have a copy of Microsoft Access running.
2.. Copy your workgroup file and name it something like "Test.mdb."
3.. Start Microsoft Access. If you have security enabled, log on as a member of the Admins group.
4.. Open Test.mdb. Use View/Options/General, and select the Show System Objects option. Then use Security/Permissions to assign permissions to the MSysAccounts and MSysGroups tables for the users or groups who you want to have privileges to check group membership.
5.. Quit Microsoft Access
6.. Delete System.mda and rename Test.mdb to System.mda.
Authorized users or members of authorized groups can now obtain group membership information"

(david)

 

[CarlaB]

Hello Peggy

I have the same problem, but I couldn't resolve it, even changing the permissions to MSysAccounts and MSysgrups
Have you fix the problem already

CarlaB


----- Peggy escreveu: ----

I can create an unsecured database before I convert it,
but I am trying to avoid loosing all of the groups, users
and security information that is already setup in the
database