MSysTables

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

what is it referring to when it says "You do not have the necessary
permissions to use the MSysTables' object .... etc" What permissions do I
need to set for this user to allow this code to run.

TIA
Connie
 
You can't... those tables are controlled by the Jet engine, and are
off-limits to direct manipulation.


what is it referring to when it says "You do not have the necessary
permissions to use the MSysTables' object .... etc" What permissions do I
need to set for this user to allow this code to run.

TIA
Connie
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Then why does the msg go on to say "Have your system administrator or the
person who created this object establish the appropriate permissions for
you." What do I do to prevent this msg & allow the code to continue .... I
don't know if I have pinpointed the problem, but it seems that the couple of
places this happens is when I'm using ADOX.Catalog & ADODB.Command to set &
save a query. (BTW I'm using Access 2002). While I'm logged on as the
Developer (full access) everything works (also, my db has been in place for
a few months now (unsecured) - used by 1 person & working fine ... now that
more people will be using it I'm securing it), but when I log on as one of
the users .. I get this msg. If it would help to see that portion of code,
let me know & I'll post it.

Thanks for any suggestions you might have.
Connie
 
Connie said:
Then why does the msg go on to say "Have your system administrator or the
person who created this object establish the appropriate permissions for
you." What do I do to prevent this msg & allow the code to continue ....
I
don't know if I have pinpointed the problem, but it seems that the couple
of
places this happens is when I'm using ADOX.Catalog & ADODB.Command to set
&
save a query. (BTW I'm using Access 2002). While I'm logged on as the
Developer (full access) everything works (also, my db has been in place
for
a few months now (unsecured) - used by 1 person & working fine ... now
that
more people will be using it I'm securing it), but when I log on as one of
the users .. I get this msg. If it would help to see that portion of
code,
let me know & I'll post it.
Click to expand...

In code are you modifying the SQL property of a saved query? If so, then
you need to give the users modify design permission on that query.
 
yes that's exactly what I'm doing .... I'm new to security (can you tell?)
;) & didn't know what that error meant. Now of course it all makes sense
.... not the error, but the fact that I need to give them Modify design
permission cause that's what I'm doing with code!

Thank you so much Joan!!!
 
Back
Top