table accessibility

[villsthearcher]

Hi,

I intend to make my database a read only file. What I mean is that the User will not be able to change the Design or modify the forms, reports or queries respectively.

So what I did was I first converted the .mdb file into .mde file. Then I replicated this file. Now, I was successful in doing this and I got what I wanted. But I found that, I was still able to add data to the tables. How do I or what should I do to turn off this ablity to enter data into a replicated file of a mde file.

Thanks,
villsthearcher

 

[JerryKlmns]

All forms should have Allow Edits, Deletions, Additions to No

At StartUp otpions define your start up form (switchboard) and unselect Display database window, Use special access keys, Allow Toolbar/Menu Changes.

This piece of code when run will create the AllowBypassKey property (pressing Shift key at startup) and disable it

Dim dbs As Object
Dim prp As Object
Dim AllowBypassKey As Boolean

    Set dbs = Application.CurrentDb
    Set prp = dbs.CreateProperty("AllowBypassKey", 1, True, True)
    dbs.Properties.Append prp
    'Next lines declare the start up form
    'Set prp = dbs.CreateProperty("StartupForm", 10, "StartUp", True)
    'dbs.Properties.Append prp

    Set dbs = Nothing
    Set prp = Nothing

so that the user only sees your start up form. This enables it back

Application.CurrentDb.Properties("AllowBypassKey") = True

and clears the start up declaration

Application.CurrentDb.Properties.Delete "StartUpForm"

But any one who knows how to open a connection to your database could play with your data. The best would be to create user level security, create a users group with permissions set to read only on tabels. Plus any other on the rest of the database objects.