Link to home
Start Free TrialLog in
Avatar of ellenkd62
ellenkd62

asked on

No "Macro Security" option on the Toolbar

I had to reinstall Access 2000, and now it won't let multiple users access the database at the same time. I know I need to reset the Macro Security to "low" (and we've always run it that way), but my toolbar doesn't show the Macro-Security Option. It's not even grayed-out... it's just not there at all. I've tried "customizing" the toolbar, but the option isn't in the customization box either.

Help!
Avatar of Rick_Rickards
Rick_Rickards
Flag of United States of America image

Macro security isn't something that exested back in the days of Office 2000.  It was introduced with Office 2003.
Avatar of ellenkd62
ellenkd62

ASKER

So how can I set up my database so multiple users can get into it at the same time? I know they can't access/change data simultaneously, but prior to my reinstall (and repairing the databases), multiple people were able to get into the database, print reports, etc.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you!!! That worked!
Cool.

Don't forget to close the Q :-)

mx

??

Why is this here:

Notice: The Asker has requested that this comment be accepted as the solution and the points broken down as follows, with any remaining points refunded to the Asker's account:
250 points to 20852580 by DatabaseMX

If you object to this action, you have until 2/15/2008 to post a comment describing your objection. This will generate a request in Community Support for Moderator review. If no Expert objects, this question will be closed as described above.
************************************************
??

Just assign the points and close the Q - just like we normally would






------------------------------------------------------------------------
Unaccepted this comment in favor of:
https://www.experts-exchange.com/questions/23148483/No-Macro-Security-option-on-the-Toolbar.html#20852580

mbizup, Access ZAPE
Actually, I thought it was a admin comment :-)

mx
Joe,

It was a admin comment of sorts, just an automated one.  In a nutshell:

- The Asker clicked Accept on their own comment.
- The message you saw got displayed,  and an automated process to close the question in 7 days got initiated
- You posted a response which was interpreted as a possible objection, automatically posting the following question on the Asker's behalf, and the process to close the question got cancelled (please don't post any comments at this link since it is in a CS zone):
https://www.experts-exchange.com/questions/23148733/Automated-Request-for-Review-PAQ-Q-23148483.html

It's a great feature.  Askers *should* have a simple means of accepting their own comments.  It will just take some getting used to, in terms of Askers using it in the right situations, and Experts only posting legitimate objections in response.


btw ... this sentence:

"Just assign the points and close the Q - just like we normally would"

I was in a hurry ... off to a meeting - and it looks like I might have been mad or something ... not the case ... just in a hurry.

Well ... looks like we are doing 3/4 on new features:
Attach Code Snippet  Yes
Attach File Yes
Pseudo Admin feature above Yes
Sticky Neglected Q's     NO !


mx