>I have one access database secured by Access03 User level sytem. The users
>have to login and use the forms to enter or change the data. All is perfect
>except that some of the access familiar users are accessing the table from
>the database window and entering data or messing with data directly without
>using the forms.
You'll need to implement Access workgroup security - a complex task but
doable. Download the Microsoft Access 2000 Security FAQ:
http://support.microsoft.com/kb/207793/en-us
Follow its instructions PRECISELY - print it out, read it carefully, get a
good night's sleep, read it *again*, and check the steps off as you do them.
Put all these users in a Group, and give the group permission to run your
forms, and to *read* tables and queries - but do not give them update
privileges to the tables, nor permission to create new queries, nor update
permission to the queries upon which the forms are based. Use the "Run With
Owner Permission" property on the form's recordsources.
>By the way, does the table or query trigger an event before showing the data?
No.
>If a better solution exists with Access2007, then I will upgrade.
It's *worse*. They've *removed* workgroup security!
If the data is business-critical, you may want to seriously consider moving
the data to SQL/Server and locking it down with SQL security.
John W. Vinson [MVP]