Read only database?

[sasolini]

Hey,

I secured my database with password login form. Usernames and password are in special table becouse i did not want to use access security sistem. And thats workin just fine for me. The problem that i have now is that if two users login the second user get Run-Time error 2467. I think thats becouse two ppl cant edit the same database at the same time. So i would like, if its posible, that my database would start up as read only? Even better if i caould set it to start based on the user level i have set? So can someone pls tell me if this it even posible and how?

thx

 

[ghudson]

Hey,

I secured my database with password login form. Usernames and password are in special table becouse i did not want to use access security sistem. And thats workin just fine for me.

It does not sound like it is really working just fine for you.

Your db should be split so that each user has a copy of the front end installed in their hard drive. Then you can customize how the db acts based on the user and their security level. You will probably continue to have problems with your homemade version of security.

 

[sasolini]

Ok , when i read somethink like this from you i know im in deep sh**

The problem is that i want my DB to be in one file only. No installation on users computers! Becouse users only need to read the DB (Im the only one to write data in DB) i thot that i would make my DB read only by defould. Looks like thats no good or it can be done?

I protect my DB with desabling SHIFT key(it thik it was your code), and custum users (I find a code on the net and it works ok). So what would be the best solution for my DB? I would realy like to have my DB in one file so users wouldnt have to install a special file.

For any help I will be more than greatfull!

 

[Bat17]

If you read the MS Security FAQ, http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Especialy part 26, you will see that you can set it up secured in such a way that you dont need to distribute the security file with the DB, you just need a copy of it when you are developing.

HTH

Peter

ps. You could also try right-click the mdb file and setting it to read only, but this seems a bit weak
The user will also get a warning msg everytime they open the DB

Peter