 |  |  |  |  |  |  |  |
How to set user rights in ms.access from vb6
 |
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
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
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
irc://irc.rizon.net/#itf
|
Similar Threads
- Howto set password for folder shared in LAN (Network Security)
- Set, View, Change, or Remove Special Permissions for Files and Folders in Windows XP (Windows tips 'n' tweaks)
- MS Access and other applications on VB6.0 (Visual Basic 4 / 5 / 6)
- Access to the path is denied (ASP.NET)
- Using 'nix-like User Permissions in Windows XP (Windows NT / 2000 / XP)
- VB6 and MS Access 2002 (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Report In Vb
- Next Thread: hi
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
