By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

performing dba role in Ms-Access

P: 20
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,
Jan 3 '07 #1
Share this Question
Share on Google+
5 Replies


PEB
Expert 100+
P: 1,418
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 autothentication in ur system!
Jan 3 '07 #2

P: 20
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 autothentication 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!
Jan 3 '07 #3

PEB
Expert 100+
P: 1,418
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!
Jan 3 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 3 '07 #5

P: 20
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 .
Jan 4 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.