Freakin' Access

Ok, normally I’d never consider psoting a work-type question here…but I’m begging any and all Microsof Access genius’s here…this is driving me up the wall. Does anyone know of a good site to go to for help, someone to e-mail for help, even a damn 900 number I can call…

Now just a disclamer…I need some advanced advice here…I’m certified expert at access 97…passed with a 98%…But this security feature has whooped my ass…HELP!

Don’t know about any helpdesks (except you might try Microsoft’s homepage).

Still, I’ve worked with Access quite a bit, and a few others here probably have, too. How 'bout some details. What’s the problem?

Hey, wanna see something neat? If you have access to machine with Windows NT 4, open its task manager and tab over to the CPU graph. Watch it noodle around the low end of the scale for a while. Then open up MS Access, and watch as the CPU usage shoots straight to 100% and stays there.

I will pay $20 to anyone who gives me a good technical reason why this behavior was permitted in a “finished” software product.

(As of yet, I have only come up with one possible explanation: “MS programmers are braindead sacks of nearly-sentient protoplasm whose sole purpose in existence is to make my life difficult.” This theory has yet to be disproven by evidence.)

Of course I don’t fit in; I’m part of a better puzzle.

Anyway, posting the details of your problem here would be a good idea. There are enough of us programmers around that you’re bound to get some workable suggestions, if not the precise solution.

(BTW, do you say “certified expert” meaning that you got your MCSE? If not that, then what?)

Of course I don’t fit in; I’m part of a better puzzle.

Ok…I didn’t want to post to many details here, 'cause I really wasn’t sure if I was breaking some unwritten rule about asking for work-type advice.

As far as the certification, well when I was an instructor at a computer training session, they made us all take something calles a M.O.U.S. test…you can find more info for it at

It stands for Microsoft Office User Specialist It’s a fairly good test designed to give someone that works with Access, but is short of time/money needed to get a MCP, a chance to have something that says Yes I know how to create a database

The problem I was having was with assigning security for one database that is accessed via a NT network. After $100 in books, I finally found one that touched on the security, but it fell short of explaining how to really make it work. I mean I can see the user interface damn it, but how do you get it to work with just one database, and not every time you start Access.

(sigh)…I finnaly figured it out…I had to make a shortcut with about 4 different switches to open it from the shared location.

Thanks to all that offered to help…I guess I jumped the gun a little, but I’ve been beating my head against the wall for 4 days on this thing and had gotten frustrated. I mean I can write Macros, do the VBA coding I need, but I couldn’t get the stupid security to work…and it came with a Wizard…But I finaly found the one paragraph in the entire bood that helped…Again, thanks to everyone for offering to help.

If anyone wants more info about the tests, let me know…I’ll be happy to help.

FileMaker Inc. could use this column as advertising copy.

Designated Optional Signature at Bottom of Post