Access 2000 Permissions

[Glenn]

Trying to make a design change to a form and getting
error "You don't have permission to copy ...". Logged on
as Administrator. Check of permissions indicates UserID
Administrator does NOT have authority to change design of
this particular form, but does have authority to change
others. Tried to grant permission, but Access denies that
change. Tried copying DB to new name, but new DB has same
limitations on access. How do I grant complete
permissions to Administrator? Alternatively, how do I
copy the desired form to a new object, make changes, then
copy back to original? Thx.

 

[Joan Wild]

Trying to make a design change to a form and getting
error "You don't have permission to copy ...". Logged on
as Administrator. Check of permissions indicates UserID
Administrator does NOT have authority to change design of
this particular form, but does have authority to change
others. Tried to grant permission, but Access denies that
change. Tried copying DB to new name, but new DB has same
limitations on access. How do I grant complete
permissions to Administrator? Alternatively, how do I
copy the desired form to a new object, make changes, then
copy back to original? Thx.

Who is the owner of the form? Log on as that user and grant the
Administrator user permissions.

 

[Lynn Trapp]

You may need to check to see if the problem has to do with your Windows
folder permisions. Also, make certain that you are logged on using the same
..mdw file that was used to secure the database.

 

[Glenn]

-----Original Message-----


Who is the owner of the form? Log on as that user and grant the
Administrator user permissions.

--
Joan Wild
Microsoft Access MVP


.
Joan, thanks for the prompt reply. I am logged on as

Admin, which is a user in the Admins Group. UserID Admin
is a member of the Admins Group. The Form has an owner
of the Admins Group. Should I change ownership to an
individual UserID, such as Admin?

 

[Glenn]

-----Original Message-----
Logged design
Admin, which is a user in the Admins Group. UserID Admin
is a member of the Admins Group. The Form has an owner
of the Admins Group. Should I change ownership to an
individual UserID, such as Admin?
.
Joan, On checking more carefully, I find that contrary

to my earlier post, the Owner for the form is <unknown>.
Access will not allow me to change the Owner (no
permission). Seems like the table that maintains the
security settings needs modification. How can I reset
the table or at least enable UserID of Admin to have
complete ownership and access to all objects in the DB?

 

[Joan Wild]

to my earlier post, the Owner for the form is <unknown>.
Access will not allow me to change the Owner (no
permission). Seems like the table that maintains the
security settings needs modification. How can I reset
the table or at least enable UserID of Admin to have
complete ownership and access to all objects in the DB?

If you are logged on as 'Admin', then you are perhaps using the standard
system.mdw workgroup file.

An owner of unknown indicates that the form was created by a user that
a) was in your mdw, but has been deleted
or
b) you are not using the correct mdw

I think it's the latter. You need to log on using the correct mdw and the
correct user.

If you are actually using the correct mdw, but logging in as 'Admin'...well
you shouldn't; log in as the user that owns the form.

 

[Glenn]

-----Original Message-----


If you are logged on as 'Admin', then you are perhaps using the standard
system.mdw workgroup file.

An owner of unknown indicates that the form was created by a user that
a) was in your mdw, but has been deleted
or
b) you are not using the correct mdw

I think it's the latter. You need to log on using the correct mdw and the
correct user.

If you are actually using the correct mdw, but logging in as 'Admin'...well
you shouldn't; log in as the user that owns the form.

--
Joan Wild
Microsoft Access MVP


.
Joan, Our Access2000 DB is a conversion from an Access97

DB over a year ago and, although the owner of the form
(the form developer) may have been in the MDW file in
Access97, they are not there now. On converting to
Access2000 we did not, to my knowledge, migrate any
prior 'mdw' file (I think the prior files had a different
extension). The only MDW file we now have is the current
one. How can I reset to a point where we can reenter the
security and ownership information. Or do we just delete
the MDW file and somehow create a new one?

 

[Joan Wild]

DB over a year ago and, although the owner of the form
(the form developer) may have been in the MDW file in
Access97, they are not there now.

Then you may have difficulty regaining control of the form. Are you saying
you converted the mdw, or did you convert the mdb and you're still using the
version 97 mdw?

On converting to
Access2000 we did not, to my knowledge, migrate any
prior 'mdw' file (I think the prior files had a different
extension).

If it had a different extension (mda?) then that indicates it was originally
created in version 2.0. The workgroup file has had a mdw extension since
version 95.

The only MDW file we now have is the current
one. How can I reset to a point where we can reenter the
security and ownership information. Or do we just delete
the MDW file and somehow create a new one?

Whatever you do, don't delete the mdw file! If you have the original
information (workgroup name/ID; group names/IDs, and usernames/IDs), then
you can recreate the mdw using version 2000.

 

[Glenn]

-----Original Message-----


Then you may have difficulty regaining control of the form. Are you saying
you converted the mdw, or did you convert the mdb and you're still using the
version 97 mdw?


If it had a different extension (mda?) then that indicates it was originally
created in version 2.0. The workgroup file has had a mdw extension since
version 95.


Whatever you do, don't delete the mdw file! If you have the original
information (workgroup name/ID; group names/IDs, and usernames/IDs), then
you can recreate the mdw using version 2000.

--
Joan Wild
Microsoft Access MVP


.
Joan, Thanks for your patience with this issue. On

checking my notes, it appears the MDW file may be the one
from Access97. It has the name VARSYS.MDW. The database
name is PCVAR2K.MDB. How do we recreate the MDW using
Access2000?

 

[Joan Wild]

Joan, Thanks for your patience with this issue. On
checking my notes, it appears the MDW file may be the one
from Access97. It has the name VARSYS.MDW. The database
name is PCVAR2K.MDB. How do we recreate the MDW using
Access2000?

You would need to have the information I indicated above. The person who
originally secured the database should have written down that information.
Something tells me that you don't have it.

You may have to recreate the particular form from scratch.

 

[Glenn]

-----Original Message-----


You would need to have the information I indicated above. The person who
originally secured the database should have written down that information.
Something tells me that you don't have it.

You may have to recreate the particular form from scratch.

--
Joan Wild
Microsoft Access MVP


.
What I interpret from your suggestions is that I will

have to recreate this database form. Too bad. The form
that we need to change is complex and will take
significant time to rebuild. Found another
characteristic about security on this DB. On trying to
rename the problem form, the system says I do not have
permission; need design modify permission, which of
course we do not have. Is there any way to delete this
form? Sounds like we have to leave the existing form in
place, create a new one and point dependent objects to
the new form. Is there just no other way to clean up
this situation? Seems like there should be a way to copy
all objects to a new DB and then set permissions as
desired.

 

[Lynn]

-----Original Message-----
You may need to check to see if the problem has to do with your Windows
folder permisions. Also, make certain that you are logged on using the same
..mdw file that was used to secure the database.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.
Lynn, Thanks for your suggestions. Received another

response from Joan Wild and have been trying her several
suggestions. No success. Looks like we have to rebuild
the form under a UserID that has the desired permissions,
such as Admin (DB Administrator). Then we use the new
form and abandon the old one. Is there no other way to
simply reset the permissions to give the Admin UserID all
needed privileges and then start reassigning?

 

[Lynn Trapp]

I've been following your thread with Joan and I'm afraid I can't offer you
any more advice than she has. If you cannot log onto the database as a
member of the Admins Group, then you are probably going to have to recreate
the form. If you can log on as a member of the Admins Group then you
should be able to give any user all the permissions they need to the form,
unless there is some kind of corruption.

 

[Joan Wild]

What I interpret from your suggestions is that I will
have to recreate this database form. Too bad. The form
that we need to change is complex and will take
significant time to rebuild. Found another
characteristic about security on this DB. On trying to
rename the problem form, the system says I do not have
permission; need design modify permission, which of
course we do not have. Is there any way to delete this
form? Sounds like we have to leave the existing form in
place, create a new one and point dependent objects to
the new form. Is there just no other way to clean up
this situation? Seems like there should be a way to copy
all objects to a new DB and then set permissions as
desired.

You keep talking about the Admin user. If security is set up properly this
user would have *no* permissions whatsoever. Do you have any other
username/passwords you can try? It's possible another user would have the
necessary permissions.

You can try creating a new database and importing all the objects (but you
may not have sufficient permissions to do so).

Another thing you can try is to use your favourite search engine and search
for Access username/password recovery program/service. There are lots (some
free) that will recover a database password, so check that what you're
getting is for user level security, not just the database password
(different thing)