Re: Password problem
From: Joe (anonymous_at_discussions.microsoft.com)
Date: 05/14/04
- Next message: Les: "Format output to email problem"
- Previous message: Van T. Dinh: "Re: Error accessing Network File"
- In reply to: TC: "Re: Password problem"
- Next in thread: TC: "Re: Password problem"
- Reply: TC: "Re: Password problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 May 2004 01:36:53 -0700
1. Double-click db #2;
2. Log on as joe;
3. Use tools:security to check the owner of the query in
question - who is (joe is the current owner of all tables,
queries and forms.)
it?
4. Double click the relevant query - what error occurs?
(no errors occur the query executes as normal.)
5. Close db #2;
6. Double-click db #1;
7. Log on as joe;
8. See if the user from step 3., has full permissions to
the table in
question. (joe is the current owner of all tables, queries
and forms.)
If the user from step 3. above, has full permissions to
the table in
question, I can't see any way that the query (which
references that table)
would say that there is no read access to that table. ( I
hate to be repetitive but I am convinced that the problem
lies in the reference to the security & workgroup file
contained within the desktop shortcut, this is referred to
when the database is started from the desktop, but is not
when the database is started from db #1. the response is
exactly the same as would occur should db #2 be started
from the mdb file in the documents folder. This results in
exactly the same error "record(s) cannot be read no read
permissions on 'tblmasterfuel'", even though the
user 'joe' complete with password is supplied at start-up?)
>-----Original Message-----
>Joe, if you are logging-on as a user who has full
permissions to the
>relevant table, you shouldn't be getting any errors
saying that there is no
>read access to that table.
>
>I feel you need to double-check this. Please follow these
steps precisely -
>adding & omitting nothing.
>
>1. Double-click db #2;
>2. Log on as joe;
>3. Use tools:security to check the owner of the query in
question - who is
>it?
>4. Double click the relevant query - what error occurs?
>5. Close db #2;
>6. Double-click db #1;
>7. Log on as joe;
>8. See if the user from step 3., has full permissions to
the table in
>question.
>
>If the user from step 3. above, has full permissions to
the table in
>question, I can't see any way that the query (which
references that table)
>would say that there is no read access to that table.
>
>HTH,
>TC
>
>
>"Joe" <anonymous@discussions.microsoft.com> wrote in
message
>news:bcde01c437fc$28cf3150$a501280a@phx.gbl...
>> Hi TC
>> Sorry about losing the history, I didn't appreciate that
>> your access to the group was any different from mine. To
>> answer your question, I have given 'joe' user rights to
>> all tables and queries on both databases.
>>
>> Regards Joe
>>
>> >-----Original Message-----
>> >
>> ><anonymous@discussions.microsoft.com> wrote in message
>> >news:b6c801c43778$f32a37d0$a001280a@phx.gbl...
>> >> Hi TC
>> >>
>> >> Your continued deliberations are much appreciated.
>> >
>> >No probs. But Joe, could you please retain the text of
>> the whole
>> >conversation when you make each post. The old posts
>> rapidly disappear from
>> >my newsserver. So if you cut out the old text, I can
not
>> see it any more, to
>> >refer back to it. >All of the previous posts< have
>> already isappeared from
>> >my newsserver :-(
>> >
>> >
>> >> I have
>> >> looked at the permissions as you requested and they
>> appear
>> >> to be in order, with the qryfuelupdate owner being
joe
>> and
>> >> all permissions suggesting that joe be allowed read
>> write
>> >> and administration rights over this query.
>> >
>> >The issue is not whether joe has read/write access to
the
>> query in db #2. It
>> >is whether joe has read access to the relevant table in
>> db #1. The message
>> >(as I remember it) implies that joe can not read the
>> table in db #. It does
>> >not imply that joe can not use the query in db #2. In
>> fact, he >is< using
>> >the query in db #2, because it is giving an error when
it
>> executes the query
>> >SQL!
>> >
>> >So, does joe have read access to the relevant table in
db
>> #1?
>> >
>> >
>> >> I was unable to
>> >> run the statement you provided in the immediate
window,
>> >> which gave the compile error 'member or data member
not
>> >> found'.
>> >
>> >Ok, I guess you got the query owner from the
>> Tools:Security options.
>> >
>> >
>> >> I have managed to get the database #2 to accept the
>> >> password for user joe when the logon dialog is
opened.
>> >
>> >Not sure what you mean by that. If joe has a password,
>> you must enter it, or
>> >the open won't proceed. Conversely, if joe >does not<
>> have a password, you
>> >must leave that field blank, or again, the open won't
>> proceed.
>> >
>> >
>> >> I have also taken out the new reference in the dim
>> statement.
>> >
>> >
>> >
>> >> I still wonder about the reference to the database
mdw
>> file.
>> >
>> >No point wondering, until you tell me whether user joe
>> does or does not have
>> >read access to the relevant table in db #1 :-)
>> >
>> >HTH,
>> >TC
>> >
>> >
>> >>
>> >> "C:\Program Files\Microsoft Office\2000
>> >> \Office\MSACCESS.EXE" "C:\Documents and
Settings\Joe\My
>> >> Documents\Van Run05.mdb" /WRKGRP "C:\Documents and
>> >> Settings\Joe\My Documents\Secured1.mdw"
>> >>
>> >> Which is called when database #2 is started from the
>> >> desktop shortcut. If I start database #2 by double
>> >> clicking on the mdb file and enter the username joe
with
>> >> the correct password and attempt to run
qryfuelupdate I
>> >> obtain the same error message as when database #2 is
>> >> started from database #1. Or am I still confused.
>> >>
>> >> Regards Joe
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Les: "Format output to email problem"
- Previous message: Van T. Dinh: "Re: Error accessing Network File"
- In reply to: TC: "Re: Password problem"
- Next in thread: TC: "Re: Password problem"
- Reply: TC: "Re: Password problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
