Temporary change of UserName

[nagyf]

My idea to solve the question of preventing direct usage of table was:
1. Using workgroups
2. Deny permissions for table T for UserName="Writer"
3. Allow permissions for table T for UserName="Form_Writer"
4. In Form_Activate or _Load of T
set UserName= "Form_Writer"
5. In Form_Close or _Deactivate
set UserName = "Writer".

But UserName is a read-only property.
I found "Last User" in registry, changed it, but
neither CurrentUser() nor UserName property gave the changed result.

Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"

 

[Aivars]

Hi, Ferenc!

Just now I sent by e-mail ZIP file with several forms and function which would be helped you to solve your problem.

Aivars

 

[nagyf]

Aivars,
Please convert your exaples in Access 97 format.
I could use neither MDW nor MDB.
Regards
Frank Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"

 

[Aivars]

Hi again!
Just now I sent you DB for Acc97.

Aivars