Open database in read-only mode

[checkOut]

I have an Acces2K database
I have a kind of trivial security in it.
One of the security is: some people only can read the database
In the StartUp form, I put in the load event a function to check the safety level of the user
If Safetylevel = 4 then
' application only readable
end if

Anyone an idea to handle this?
Thnx in advance,
gerard

 

[JeremyNYC]

Use Access User Level security. It has this ability built into it. Check out the Security FAQ either at the MS site or on mine. Building your own security like this will only waste your time.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[checkOut]

It's not waste of time, the problem is that some trivial buttons are linked to a kind of security level. In my opionon and knowledge this is only possible to handle by code. The only difference between 2 group of members is the read-only modus. So I better like code to put it in the mainform and handle the whole question of securitylevel in 1 line of code.
Thnx in advance,
Gerard

 

[JeremyNYC]

Gerard,

That functionality is available using Access's built-in security.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.