Need 2 change user & permission cannot contact creator of control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in an Access database created by someone else.
I am very new to Access, however am very good with computers and learning
new programs. I have never had this many problems or become so frustrated!!!!

The database is saved as a read only. I have tried to change this by going
to Tools/security/
then I add a new workgroup administrator
I join
then i also go to user groups and accounts - set this workgroup
administrator up here -
nothing keeps.
the APPLY button is not available.
I have read thru all of the HELP options and am completely at a loss of what
to do at this time.
I cannot change the read only from the PROPERTIES selection if I go the the
file Icon thru My Computer.
SOMEBODY PLEEEEEZZZZEEE HELP ME. I have been hired to do some data entry
and am spending more time trying to open this dang file then I think this
person really wants to pay me for.
 
SimplicitySake said:
I am working in an Access database created by someone else.
I am very new to Access, however am very good with computers and learning
new programs. I have never had this many problems or become so
frustrated!!!!

The database is saved as a read only. I have tried to change this by
going
to Tools/security/
then I add a new workgroup administrator
I join
then i also go to user groups and accounts - set this workgroup
administrator up here -
nothing keeps.
the APPLY button is not available.
I have read thru all of the HELP options and am completely at a loss of
what
to do at this time.
I cannot change the read only from the PROPERTIES selection if I go the
the
file Icon thru My Computer.
SOMEBODY PLEEEEEZZZZEEE HELP ME. I have been hired to do some data entry
and am spending more time trying to open this dang file then I think this
person really wants to pay me for.
Click to expand...

What do you mean by "saved as read-only"? Do you mean the file attribute?
If so then you need to change this at file level, you can't change it from
within Access. Or have I missed your point?

Regards,
Keith.
www.keithwilby.com
 
What do you mean by "saved as read-only"? Do you mean the file attribute?
If so then you need to change this at file level, you can't change it from
within Access. Or have I missed your point?
Click to expand...
Sorry, I just re-read your post. Whay can't you change it? Do you not have
the appropriate permissions? If not then you either need to acquire them or
find someone who has them to change it for you, you won't be able to do a
thing with the app until the read-only attribute is removed.

Regards,
Keith.
 
Keith said:
Sorry, I just re-read your post. Whay can't you change it? Do you not have
the appropriate permissions? If not then you either need to acquire them or
find someone who has them to change it for you, you won't be able to do a
thing with the app until the read-only attribute is removed.

Regards,
Keith.
Click to expand...
 
Hi Keith, Thanks for your reply.
You are correct, I do not have the appropriate permissions.
I've tried every which way I can think of to get them/reset them or whatever
it is called.
I cannot get this info from the originator of the database. The guy who
hired me is going thru a divorce....the ex-wife set up the database for his
company....i guess she is being difficult and won't provide him any
help....she gave him a CD with the database on it....but decided to lock all
of the permissions....practical joke maybe????

I can however, seem to make changes to the database if I am on this guys
laptop signed in under a windows user name that was created by this lady. As
long as I access the database this way, I can make and save changes. I
cannot do this under his windows user name.....not sure if that info is
helpful

Thanks again, Tammy
 
Keith wrote:

(snip)
Sorry, I just re-read your post.
Click to expand...

And /understood/ it?

"then I add a new workgroup administrator
I join then i also go to user groups and
accounts - set this workgroup administrator
up here - nothing keeps."

! :-) TC
 
Yeah...typical for me, I hardly ever make sense.
Let me try again...

I have a database created by somebody else (person not accessible).
I cannot seem to make any additions/changes, etc. - due to this file being a
read only file.
I cannot figure out how to change the read only status (cannot do it thru
going to My Computer I am told that I do not have permission/access denied)
I have tried all of the steps suggested on the Access Help Menu (correctly i
hope/think)
what am i missing??????
 
TC said:
And /understood/ it?

"then I add a new workgroup administrator
I join then i also go to user groups and
accounts - set this workgroup administrator
up here - nothing keeps."
Click to expand...
That did flummox(TM) me a bit but it looks like a NTFS file permissions
problem to me.

:o)
 
simplicitysake wrote:

(snip)
I can however, seem to make changes to the database if I am on this guys
laptop signed in under a windows user name that was created by this lady. As
long as I access the database this way, I can make and save changes. I
cannot do this under his windows user name
Click to expand...


The Windows username is unlikely to be relevant in my opinion. Access
security is not tied to Windows usernames, unless you do some special
coding.

Are you saying that if you log into the laptop using one Windows logon
name, say 'x', you /can/ make changes to the database; but if you logon
under a different Windows username, say 'y', you /can not/ make changes
to the database?

TC
 
simplicitysake said:
You are correct, I do not have the appropriate permissions.
I've tried every which way I can think of to get them/reset them or
whatever
it is called.
I cannot get this info from the originator of the database. The guy who
hired me is going thru a divorce....the ex-wife set up the database for
his
company....i guess she is being difficult and won't provide him any
help....she gave him a CD with the database on it....but decided to lock
all
of the permissions....practical joke maybe????
Click to expand...

Exactly how did she achieve this? What are the symptoms?
I can however, seem to make changes to the database if I am on this guys
laptop signed in under a windows user name that was created by this lady.
As
long as I access the database this way, I can make and save changes. I
cannot do this under his windows user name.....not sure if that info is
helpful
Click to expand...
If you can administer the database by logging in to *Windows* as this other
person but *without* supplying Access with any authentication then copying
the file from the CD to a folder where *you* have Full Control permissions
should enable you to remove the read-only file attribute. It doesn't sound
like user-level security has been applied.

Regards,
Keith.
www.keithwilby.com
 
simplicitysake said:
Yeah...typical for me, I hardly ever make sense.
Let me try again...

I have a database created by somebody else (person not accessible).
I cannot seem to make any additions/changes, etc. - due to this file being
a
read only file.
I cannot figure out how to change the read only status (cannot do it thru
going to My Computer I am told that I do not have permission/access
denied)
I have tried all of the steps suggested on the Access Help Menu (correctly
i
hope/think)
what am i missing??????
Click to expand...
But you still have it on CD, right?
 
Um, maybe the first Windows user has read/write/execute/delete
permission to the folder containing the database, but the second
Windows user does not. That could explain your problem.

HTH,
TC
 
correct, I do have it on CD - but the CD version is also read only.
I just read your other note and you said it looks like an nftc
problem.....what is that?
geez....it is so humbling not knowing what the hell I'm doing. :)
 
That is correct....and the "x" logon that is allowing me to make changes is
the logon of the lady that created the database. However, even on this
logon, if I check the database file properties under My Computer - the
properties show it as NOT read only. I think to myself "GREAT"...and I save
it to my CD and suddenly it is now marked as a read only and will not allow
me to change.
Go figure. (is there a symbol for a greatly confused person <grin>)
 
Hey there....i think my reply up above cancels this suggestion out....i'll
re-post my reply here.....
That is correct....and the "x" logon that is allowing me to make changes is
the logon of the lady that created the database. However, even on this
logon, if I check the database file properties under My Computer - the
properties show it as NOT read only. I think to myself "GREAT"...and I save
it to my CD and suddenly it is now marked as a read only and will not allow
me to change.
Go figure. (is there a symbol for a greatly confused person <grin>)
 
Hey Keith,
Thanks for hanging in there with me. I know it can be irritating to deal
with a person who doesn't know what they are doing.
I am copying a response that I sent to TC (in this same message thread)
which I think answers your question/suggestion.....I cannot seem to copy to a
CD file or any other file other than hers w/out it turning automatically into
a read only.
I would just make it simple and work under her windows login, however it is
not my laptop - it is this guy's, and secondly because I can't stand not
knowing how to solve the problem.
It will go w/me to my grave if I can't fix it.....aaaarrrggh
 
simplicitysake said:
correct, I do have it on CD - but the CD version is also read only.
I just read your other note and you said it looks like an nftc
problem.....what is that?
geez....it is so humbling not knowing what the hell I'm doing. :)
Click to expand...
It's read-only on the CD because you can't write data to the CD. Copy the
file from the CD to a folder where you have "Change" permissions (NTFS is
Windows NT File System which W2000 and WinXP also use). You will then be
able to remove the read-only attribute.

Regards,
Keith.
 
It will go w/me to my grave if I can't fix it.....aaaarrrggh
Click to expand...
OK, let's take a step back and take a deep and calming breath ... that's
better ;-)

Forget about Access security, that's not an issue (yet). You need a folder
on any PC or network where you have the ability to change file attributes.
On an NTFS system (XP and the like) this requires "Full Control"
permissions. Copy the file from the CD to a folder where you have such
permissions (you can tell this by right-clicking the file, selecting
'properties' and then the 'security' tab). The file will then inherit the
*permissions* (but not the attributes) of the folder you copied it to. This
will enable you to remove the read-only attribute.

If you're limited to your client's laptop, have him create a user account
for you and also some dedicated disk space set to give you the "Full
Control" permissions you need.

Regards,
Keith.
 
However.....that is such a basic thing - why didn't I see that?????
It worked. Before copying the info from the CD - i created a folder - took
off the Read Only property - then copied the info - then my problem was
solved.
Wow. Almost wish it was a more difficult answer - just so I didn't feel
like such a dummy.
Thanks a million - sincerely.
Tammy
p.s. - what are you doing up all night anyhow!!!!! :)
 
simplicitysake said:
However.....that is such a basic thing - why didn't I see that?????
Click to expand...

Sometimes we just can't see the wood for the trees, usually whilst in panic
mode.
It worked. Before copying the info from the CD - i created a folder -
took
off the Read Only property - then copied the info - then my problem was
solved.
Wow. Almost wish it was a more difficult answer - just so I didn't feel
like such a dummy.
Thanks a million - sincerely.
Tammy
Click to expand...

No problem, glad you got there in the end.
p.s. - what are you doing up all night anyhow!!!!! :)
Click to expand...
Oooh, there are so many cheeky responses I could make to that, how about
"I'm in the UK so I won't be up all night for another few hours yet" ;-p

Regards,
Keith.
www.keithwilby.com
 
Back
Top