How to forbid tables and queries creation in Access 97? Files.mde and
security wizard don't provide the right solution ( you can create tables and
query,anyway).
I know that an utility exists, but for Access 2000 and besides I tried this
code but with no result ( I'm sure I'm using it in the wrong way).
Function faq_NoNew (strUser as String)
Dim db As Database
Dim con As Container
Set db = DBEngine(0)(0)
Set con = db.Containers("Tables")
con.UserName = strUser
con.Permissions = con.Permissions And Not dbSecCreate
End Function
In particular, I don't know what exactly write instead of "strUser as
String" and "strUser";
have I to compile this code with an AutoExec Macro?
If you can help me, please do it.
Regards
secure db in Access 97