25112
asked on
assign self permission in access 2002
pl see attached.
this is a lone machine/program.. no other users.. the user never had a need to edit before.. now would like to go into form and design, but there is a block.
1)can you guide how to access the security?
(Tools seems to be missing the 'Security' option. (as I read in http://support.microsoft.com/KB/288960 ))
2)where can we see what the current user is called as inside WInxp or in the access program?
the user cant afford to upgrade the program. the program is on a XP VM inside Win7, now.
thanks.
access.png
this is a lone machine/program.. no other users.. the user never had a need to edit before.. now would like to go into form and design, but there is a block.
1)can you guide how to access the security?
(Tools seems to be missing the 'Security' option. (as I read in http://support.microsoft.com/KB/288960 ))
2)where can we see what the current user is called as inside WInxp or in the access program?
the user cant afford to upgrade the program. the program is on a XP VM inside Win7, now.
thanks.
access.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>So you're able to actually open the database? You just cannot enter into design view? Do you see the Forms and Reports listing as well?
yes
>>If all you're doing is changing the address, then perhaps you could review the tables to see if this data is stored there.
yes, i found the table.. but the tricky part is the data only in that table is encrypted.. (garbled data).. i believe it in the form design the logic to encrypt the correct new values...
now the programmer did give a password in the documentation.. i thought and was hoping that when i try to design the form, it would prompt for the password.. is there any other place/way a password could be used to authenticate?
thank you for your assistance to understand this.
yes
>>If all you're doing is changing the address, then perhaps you could review the tables to see if this data is stored there.
yes, i found the table.. but the tricky part is the data only in that table is encrypted.. (garbled data).. i believe it in the form design the logic to encrypt the correct new values...
now the programmer did give a password in the documentation.. i thought and was hoping that when i try to design the form, it would prompt for the password.. is there any other place/way a password could be used to authenticate?
thank you for your assistance to understand this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the programmer who sold it is not responding to emails/calls.. hence this client asked me to check to change his address, so his reports will have the right address... need to edit the form. but blocked ATM.
Scott, it does show has mdb file, but as you said, mde might be renamed as mdb.. i don't know for sure.
>>f you can open the database, then it may report the name of the logged in user
where could this be? in the tables or on the displayed forms?
when i hit shift and enter on the program, i do see the tables, views etc list.. i am able to open the tables or queries.. does that tell anything?
thanks for your input so far.