performing dba role in Ms-Access

[mukeshsrivastav]

Dear All,
Happy New Year
How to manage user's and authority's, &their passwords.my application developed on vb front end and access back end . backend operation handled by me.

Please provide me solution.
Thanking all,

[PEB]

U can store in table in Access the information about users and Passwords!

Protect ur mdb file, so the users can't access it easily!

U'll be able to access this database only by VB connection, passing SQL. However in the table u can create some encryption for the passwords

About users rights...

If uarentt able to create ur own permissions to different objects using VB and however u want to have database permissions, so when logging user u can log it using his user name and the same for Access pasword

but ur own password for autothenticatio n in ur system!

[mukeshsrivastav]

U can store in table in Access the information about users and Passwords!

Protect ur mdb file, so the users can't access it easily!

U'll be able to access this database only by VB connection, passing SQL. However in the table u can create some encryption for the passwords

About users rights...

If uarentt able to create ur own permissions to different objects using VB and however u want to have database permissions, so when logging user u can log it using his user name and the same for Access pasword

but ur own password for autothenticatio n in ur system!

Thanks Sir ,
But can u tell me whether the simple connection string is sufficent using adodc or dao .can u provide any sample code .can tools->security-> user& groups is helpful.
Please provide me any sample code.
thanks!

[PEB]

Thanks Sir ,
But can u tell me whether the simple connection string is sufficent using adodc or dao .can u provide any sample code .can tools->security-> user& groups is helpful.
Please provide me any sample code.
thanks!

In fact, i think u should use ADO coz not sure if DAO present under VB!

Exemples of ADO connections are present in the forum here

Search about:

ADO.Object

and u will find it!
Not writting now coz in my work i don't use very often ADO and don't have samples on my hand!

[MMcCarthy]

Thanks Sir ,
But can u tell me whether the simple connection string is sufficent using adodc or dao .can u provide any sample code .can tools->security-> user& groups is helpful.
Please provide me any sample code.
thanks!

Check out the following website

http://www.jmwild.com/Accesssecurity.htm

Mary

[mukeshsrivastav]

In fact, i think u should use ADO coz not sure if DAO present under VB!

Exemples of ADO connections are present in the forum here

Search about:

ADO.Object

and u will find it!
Not writting now coz in my work i don't use very often ADO and don't have samples on my hand!

Thanks sir for all ur cooperation .