MSysTables

[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

 

[Jack MacDonald]

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

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Connie]

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

 

[Joan Wild]

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.

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.

 

[Connie]

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!!!