Access 2000 J Wild security procedure

[Guest]

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

 

[Joan Wild]

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.

 

[Guest]

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]

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.

 

[Guest]

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]

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.

 

[Guest]

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]

Just import that Module again. That's all you need to do - nothing to do
with security.

 

[Guest]

Joan,

I hate to be a thorn in your side, but I am truly confused. I went through
the process of setting up a new database using the default Access workgroup.
Everything was just perfect. I started the security process over again from
scratch, and wound up with the same situation as my previous post. I get
messages like "Network connection may have been lost" . I am working from my
hard drive and no network connectivity is involved.

Would the location of the new MDW matter ??

 

[Douglas J. Steele]

Are you using Access 2000, and you haven't kept up to date with the patches?
If so, you may have a corrupted database on your hands.
http://support.microsoft.com/?id=304548

 

[Guest]

Joan, I also tried your suggestions re: tools, references compared the old
and the new db's (dialog bog contents) and they were identical. Although in
the original database going to VB brings up a host of programming and a blank
screen in the new db. The funny thing is in the new DB, Module 1 exists, it
is just empty - I feel like such a moron !!!

wrote:

 

[Joan Wild]

Have you followed up on Doug's suggestions?

What if you import the Module1 from the original?