Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / July 2007

Tip: Looking for answers? Try searching our database.

Table accessing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wael K - 24 Jul 2007 17:22 GMT
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
John W. Vinson - 24 Jul 2007 22:59 GMT
>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]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.