Re: Access 2000 J Wild security procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

For some reason all the code (simple, but lots of it) in Module 1 did not
come across - now what ?? Do I need to start the security process over ??

"Joan Wild" wrote:

I doubt it have anything to do with security.


However, one of the steps is to import all the objects to a new database.
It's possible that the references were set incorrectly in the new mdb.

Hit Ctrl-G and go to Tools, References. If any are shown as missing, take a
note of which one it is and uncheck it. Close the dialog and go to Debug,
Compile. Then click on the Save button.

Close the window, and Tools, Database Utilities, Compact and Repair.

Now see if your query works.


--
Joan Wild
Microsoft Access MVP

JoAnne wrote:
Whew, that's a relief !!! I now have a weird one (or at lest I think
it's weird). In the orginal database I have an update query that
calculates lapsed days and populates a field in the table, it works
fine. In the secure database, I get an "unknown function". Is it
possible I did someting in securing te database that affected this.
I am using Now() in both - could that somehow be related ??

"Joan Wild" wrote:

No, that was a change starting with 2000. You won't need to login
until you open a database, or attempt to change the password.

In 97 you would get the login as soon as Access opens, but now
Access will open, and you won't get the prompt until you do
something.

Sounds like you did things just fine.


--
Joan Wild
Microsoft Access MVP

JoAnne wrote:
Joan,

Thanks, that did it. Next question - I am on step 12 and I would
have expected the login dialog box to come up as soon as I opened
Access. This did not happen. I onlt had to login when I picked the
step 7 new user in the tools, security, user and group accounts.
Is this what should have happned - or did I miss something in te
earlier steps ??

"Joan Wild" wrote:

It's possible that the windows username you are using doesn't have
permission to open that file.

Use Start, Search and try and locate wrkgadm.exe (tell it to search
hidden folders); and see if it can find it.


--
Joan Wild
Microsoft Access MVP

JoAnne wrote:
I am attempting to set up security using Joan Wild's procedure. I
have run into a snag from the get-go.

When I Start/Run and type in wrkgadm.exe I get a message saying
"Windows cannot find ........"

Help anyone ??



.

Quantcast