> Hi, can any1 help me with this? Its very weird, I have a table which is
> accessed whenever a user logs on to my program. Its purpose is to store
the
> username of the last person who logged on, then that username is displayed
> automatically during the next log on.
> It works perfectly most of the time, but every now and then the table
seems
> to get corrupted and i get a message 'NOT A TABLE'.
> To get around this i simply delete the table and it is created again
> automatically the next time someone logs in.
> I havent been able to determine a common factor associated with this other
> than the fact that it seems to happen on average once a week.

> Your help is as always very appreciated

> John

> ***this code is run at the start of log in***
> IF FILE(SYS(5)+'\lastlogin.dbf')
>    use SYS(5)+'\lastlogin' exclusive IN 0
>    select lastlogin
>    username3=ALLTRIM(lastlogin.userlist)
>    use
> ELSE
>    username3=username
> ENDIF

> ***this code is run at the end of log in***
> SET SAFETY off
> SELECT * from login;
>   WHERE
> alltrim(upper(LOGIN.USERLIST))==alltrim(upper(thisform.TEXT1.value));
>   INTO TABLE SYS(5)+'\lastlogin'
> SET SAFETY on