Table accessing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir,
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.
In earlier versions of Access (franckly I don't remember quite well)
whenever you try to enter data in the northwind sample database a message
appears stating that you cannot alter data directly from the table or query,
you have to use the forms. After pressing OK the table dosen't open and you
are forced to use the forms.
I urge your help as most of this data is sensitive and is rendering the
whole database in danger. I don't want to hide the tables, they know about
the shift key also I don't want to compile as further improvements might be
required. All I need is the Northwind system, I think it's a perfect solution.
By the way, does the table or query trigger an event before showing the data?

If a better solution exists with Access2007, then I will upgrade.
Yours truly
Wael K
 
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.
Click to expand...

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.
Click to expand...

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]
 
Back
Top