Member Avatar for ahmed_1

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

  • 2 Contributors
  • 1 Reply
  • 132 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by jwshepherd
Member Avatar for jwshepherd

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.