section access rpoblem

[#1]

Dear all,

I've created the following section access:

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN, ,

    USER, USER1, U1, 9001,

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

// CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

After the loading, as ADMIN, I see everything. If I close and open the document, as ADMIN I don't see anything. If I open the document as USER1, I see all the information concerning this user. What I'm doing wrong ?

Help please

Thanks in advance

[#2]

what is the reason you load :

// CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

???

try this : -------------------------------------------

SECTION ACCESS;

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN,*,

    USER, USER, USER, 1111,2222

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

section Application;

LOAD * INLINE [

    FIELD1, FIELD2

    1, 2

    11, 22

    111, 222

    1111, 2222

];

or this: ---------------------------------------------------------

USERACCESS:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FIELD1, FIELD2

    ADMIN, ADMIN,ADMIN,*,

    USER, USER, USER, 1111,2222

];

Concatenate

LOAD 'USER' AS ACCESS,

     UPPER(USERCODE) as USERID,

     UPPER(USERPASSWORD) as PASSWORD,

     UPPER(cod1) as FIELD1,

     UPPER(cod2) as FIELD2

     RESIDENT mytable;

//CREAZIONE SECTION ACCESS

SECTION ACCESS;

Load *

Resident USERACCESS;

section Application;

LOAD * INLINE [

    FIELD1, FIELD2

    1, 2

    11, 22

    111, 222

    1111, 2222

];