Access 2000 J Wild security procedure JoAnne 08.06.2006 21:18:01 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 ??

Re: Access 2000 J Wild security procedure "Joan Wild" <jwild[ at ]nospamtyenet.com> 08.06.2006 21:52:34 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: [Quoted Text] > 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 ??

Re: Access 2000 J Wild security procedure JoAnne 09.06.2006 19:04:01 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: [Quoted Text] > 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 ?? > > >

Re: Access 2000 J Wild security procedure "Joan Wild" <jwild[ at ]nospamtyenet.com> 09.06.2006 20:22:58 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: [Quoted Text] > 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 ??

Re: Access 2000 J Wild security procedure JoAnne 09.06.2006 21:16:02 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: [Quoted Text] > 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 ?? > > >

Re: Access 2000 J Wild security procedure "Joan Wild" <jwild[ at ]nospamtyenet.com> 09.06.2006 22:01:43 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: [Quoted Text] > 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 ??

Re: Access 2000 J Wild security procedure JoAnne 09.06.2006 22:51:35 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: [Quoted Text] > 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 ?? > > >

Re: Access 2000 J Wild security procedure "Joan Wild" <jwild[ at ]nospamtyenet.com> 09.06.2006 23:50:52 Just import that Module again. That's all you need to do - nothing to do with security. -- Joan Wild Microsoft Access MVP JoAnne wrote: [Quoted Text] > 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 ??

Re: Access 2000 J Wild security procedure JoAnne 10.06.2006 22:58:02 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 ?? "Joan Wild" wrote: [Quoted Text] > Just import that Module again. That's all you need to do - nothing to do > with security. > > -- > Joan Wild > Microsoft Access MVP > > JoAnne wrote: > > 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 ?? > > >

Re: Access 2000 J Wild security procedure "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 10.06.2006 23:13:35 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 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "JoAnne" <JoAnne[ at ]discussions.microsoft.com> wrote in message news:915343BE-2D69-405E-A47F-7FDA2294D3EF[ at ]microsoft.com... [Quoted Text] > 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 ?? > "Joan Wild" wrote: > >> Just import that Module again. That's all you need to do - nothing to do >> with security. >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> JoAnne wrote: >> > 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 ?? >> >> >>

Re: Access 2000 J Wild security procedure JoAnne 10.06.2006 23:23:01 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: [Quoted Text] > 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 ?? > "Joan Wild" wrote: > > > Just import that Module again. That's all you need to do - nothing to do > > with security. > > > > -- > > Joan Wild > > Microsoft Access MVP > > > > JoAnne wrote: > > > 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 ?? > > > > > >

Re: Access 2000 J Wild security procedure "Joan Wild" <jwild[ at ]nospamtyenet.com> 11.06.2006 14:07:47 Have you followed up on Doug's suggestions? What if you import the Module1 from the original? -- Joan Wild Microsoft Access MVP JoAnne wrote: [Quoted Text] > 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, >> >> 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 ?? >> "Joan Wild" wrote: >> >>> Just import that Module again. That's all you need to do - nothing >>> to do with security. >>> >>> -- >>> Joan Wild >>> Microsoft Access MVP >>> >>> JoAnne wrote: >>>> 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 ??