Limiting record range

[Ramesh]

HI,

Is there a way i can limit access to a user before a certain record? i d
like the user to be able to add new records and modify records till a
certain point in time and not before that. All through a form only and not
in the table itself. Any way i can stop a user from viewing and modifying
data in the table itself?

Thanks .. any inputs willbe very valubale.

Ramesh

 

[John W. Vinson]

HI,

Is there a way i can limit access to a user before a certain record? i d
like the user to be able to add new records and modify records till a
certain point in time and not before that. All through a form only and not
in the table itself. Any way i can stop a user from viewing and modifying
data in the table itself?

Thanks .. any inputs willbe very valubale.

Ramesh

Not sure what you mean by "before a certain record". Total number of
records in a table? A certain point in time is a very *different*
criterion than a number of records.

You can implement Access Security: carefully study the Microsoft
Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Follow the instructions CAREFULLY, it's quite possible to do security
wrong! Done right, though, you can compel the user to interact with
data only using your Form, and in your Form you can check the date,
the time, the count of records already added, etc. and take
appropriate action.

John W. Vinson [MVP]