DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

How to set user rights in ms.access from vb6

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Sep 2005

Posts: 3

Reputation: ahmed_1 is an unknown quantity at this point

Solved Threads: 0

ahmed_1

Offline

Newbie Poster

How to set user rights in ms.access from vb6

Sep 30th, 2005

Hi,

Is their any way to create user and assign user rights/permissions for any table(s) in ms.access through vb6 code (ADO / DAO).

waiting for your reply.

Ahmed

•

Join Date: Jun 2005

Posts: 121

Reputation: jwshepherd is an unknown quantity at this point

Solved Threads: 5

jwshepherd jwshepherd is offline

Offline

Junior Poster

Re: How to set user rights in ms.access from vb6

Oct 3rd, 2005

I believe there is limited security in msaccess for what you are wanting. I don't believe it is with ado or dao though I think it is ADOX (Microsoft ADO Ext 2.8 For DDL and Security ). YOu would do better either upgrading to sql where you can set security by column for read & write or basically hide the access databasewhere they cannot find it to manipulate it. ( %SYSTEMROOT%\system32\drivers\projectname\data\ ) Just make sure the user has right sto that directory.

.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf