Need 2 change user & permission cannot contact creator of control

[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.

 

[Keith]

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.

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

 

[Keith]

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?

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.

 

[Guest]

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.

 

[Guest]

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

 

[TC]

Keith wrote:

(snip)

Sorry, I just re-read your post.

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

 

[Guest]

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??????

 

[Keith]

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."

That did flummox(TM) me a bit but it looks like a NTFS file permissions
problem to me.

)

 

[TC]

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

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

 

[Keith]

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????

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

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

 

[Keith]

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??????

But you still have it on CD, right?

 

[TC]

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

 

[Guest]

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.

 

[Guest]

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>)

 

[Guest]

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>)

 

[Guest]

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

 

[Keith]

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.

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.

 

[Keith]

It will go w/me to my grave if I can't fix it.....aaaarrrggh

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.

 

[Guest]

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!!!!!

 

[Keith]

However.....that is such a basic thing - why didn't I see that?????

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

No problem, glad you got there in the end.

p.s. - what are you doing up all night anyhow!!!!!

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