Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-16-2006, 07:07 AM   #1
Rob.Mills
Registered User
 
Join Date: Aug 2002
Location: Raleigh, NC USA
Posts: 871
Thanks: 0
Thanked 1 Time in 1 Post
Rob.Mills
Modifying security using Sql

Is it possible in access to modify user permissions with SQL?

Rob.Mills is offline   Reply With Quote
Old 01-16-2006, 01:27 PM   #2
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,149
Thanks: 15
Thanked 1,572 Times in 1,494 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 01-16-2006, 01:33 PM   #3
Rob.Mills
Registered User
 
Join Date: Aug 2002
Location: Raleigh, NC USA
Posts: 871
Thanks: 0
Thanked 1 Time in 1 Post
Rob.Mills
Quote:
Originally Posted by Pat Hartman
No. SQL can only be used against tables. You will need to write VBA to manipulate the Access object model.
Actually, I found out since I created this thread, that you can but you have to execute the sql through ADO. Why, I don't know, but it did work.

Rob.Mills is offline   Reply With Quote
Old 01-17-2006, 11:51 AM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,149
Thanks: 15
Thanked 1,572 Times in 1,494 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
I assumed you were talking about securing the Access object model. My statement wasn't clear. Yes, SQL includes the ability to use queries to modify table security.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
User Defined Show/No Show Query Results lauriphi Queries 10 07-08-2005 06:17 AM
SQL Query: Having 'OR' clause causes problems rusco Queries 3 11-20-2004 09:26 PM
Need help with VBA SQL RichO Modules & VBA 2 05-18-2004 12:03 PM
Access Security or SQL Server Security? hooi General 6 09-24-2003 10:06 AM
[SOLVED] wrong number of arguments error?? diggsy Queries 7 07-26-2002 02:30 PM




All times are GMT -8. The time now is 06:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World