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!
ellenkd62Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rick_RickardsCommented:
Macro security isn't something that exested back in the days of Office 2000.  It was introduced with Office 2003.
0
ellenkd62Author Commented:
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.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I've seen this happen one other time.

Try Help>>Detect & Repair.

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ellenkd62Author Commented:
Thank you!!! That worked!
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Cool.

Don't forget to close the Q :-)

mx

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
??

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:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23148483.html#20852580

mbizup, Access ZAPE
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Actually, I thought it was a admin comment :-)

mx
0
mbizupCommented:
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):
http://www.experts-exchange.com/Community_Support/General/Q_23148733.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.


0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.