Edit records only

[valntyn via AccessMonster.com]

I have a multi user database. Only a hand full of users can edit records,
the rest have read-only access. My issue is...the users who have edit access
can hold down the shift key and make any changes to the database they want.
It is not desirable for them to make any changes to the forms, reports, or
querys. Is there a way to restrict there abilities so they can only edit the
records in the tables and not the other aspects of the database.

I don't believe a split database is an option because there are far to may
user PCs to install the front-side on.

Any help would be greatly appreciated.

Thanks

 

[Mr. B]

I have a multi user database. Only a hand full of users can edit records,
the rest have read-only access. My issue is...the users who have edit access
can hold down the shift key and make any changes to the database they want.
It is not desirable for them to make any changes to the forms, reports, or
querys. Is there a way to restrict there abilities so they can only edit the
records in the tables and not the other aspects of the database.

I don't believe a split database is an option because there are far to may
user PCs to install the front-side on.

Any help would be greatly appreciated.

Thanks

From a previous post by Doug Steele:

You create a boolean database property named AllowBypassKey, and set
its
value to False. Use the code from
http://www.mvps.org/access/general/gen0040.htm at "The Access Web" to
ensure
that the property is created properly.

This will work for just disableing the Shift key issue.

As for the split issue you mention:

The concept is that each user should have their own copy of the
Frontend. No matter howmany user there are. In fact, the more users
you expect to have using your database, the more imperative it that
you implement the split FE/BE approach to managing your database
application. This is not just a comcept, but is the way Access
databases were designed to work, expecially in a mulit-user
environment.

HTH

Mr. B

 

[John W. Vinson]

I don't believe a split database is an option because there are far to may
user PCs to install the front-side on.

It's not an option - it's a REQUIREMENT!

And the maintenance is less of a hassle than you might think.

See

http://www.granite.ab.ca/access/splitapp/index.htm

and download Tony's front end update utility from the same site.

John W. Vinson [MVP]

 

[valntyn via AccessMonster.com]

Mr. B

If I disable the shift key function then how do I get to the database to make
possible enhancement that may come along in the future?

Thanks for your help.

I have a multi user database. Only a hand full of users can edit records,
the rest have read-only access. My issue is...the users who have edit access

[quoted text clipped - 12 lines]

From a previous post by Doug Steele:

You create a boolean database property named AllowBypassKey, and set
its
value to False. Use the code from
http://www.mvps.org/access/general/gen0040.htm at "The Access Web" to
ensure
that the property is created properly.

This will work for just disableing the Shift key issue.

HTH

Mr. B