Dear VB users,

I want to create a database with many tables.
Not all users of the database may have access to a table or can only read the records. (no editing)
Is it possible to create a database in VB with Users? Every users gets their own password with properties.

if yes, can someone give me source how to create this.
Is it possible to create, when the database is made, to create new users?

Any information is welcome.


Source:

Set Db = Ws.CreateDatabase(DbSettings, dbLangGeneral)
Set tdfNew = Db.CreateTableDef("Vendor")
With tdfNew
.Fields.Append .CreateField("VendorName", dbText)
.Fields.Append .CreateField("VendorDate", dbDate)
End With
Db.TableDefs.Append tdfNew
Db.Close


Nice regards,

Michelle.