Can't Open mdb "Tom Lake" <tlake[ at ]twcny.rr.com> 09.06.2006 01:09:40 When anyone else is using an mdb file, I can't open it at all even to just browse a table. All our computers have Access set for no locking and tried record-level locks as opposed to page locking. I've never had this problem before even though I've been using Access since 1.0. Can anyone tell me what to check for? TIA Tom Lake

Re: Can't Open mdb "Keith Wilby" <here[ at ]there.com> 09.06.2006 09:04:57 "Tom Lake" <tlake[ at ]twcny.rr.com> wrote in message news:OK5NlF2iGHA.4344[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > When anyone else is using an mdb file, I can't open it at all even to > just browse a table. All our computers have Access set for no > locking and tried record-level locks as opposed to page locking. I've > never had this problem before even though I've been using > Access since 1.0. Can anyone tell me what to check for? TIA > Has the other user opened it in exclusive mode? Do you get an error messages? Keith. www.keithwilby.com

Re: Can't Open mdb "Tom Lake" <tom_lake[ at ]srmtenv.org> 09.06.2006 12:12:10 [Quoted Text] > Has the other user opened it in exclusive mode? Do you get an error > messages? No, all users have shared mode on. There is no error message, the hourglass appears then disappears immediately with no other activity. As soon as the other users are out of the program, I can open it normally. Tom L

Re: Can't Open mdb "Tom Lake" <tlake[ at ]twcny.rr.com> 10.06.2006 03:28:11 "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >> Has the other user opened it in exclusive mode? Do you get an error >> messages? > > No, all users have shared mode on. There is no error message, the > hourglass > appears then disappears immediately with no other activity. As soon as > the other users are out of the program, I can open it normally. I found a way around it although I don't know why. I originally had a shortcut to the mdb file on my desktop. The Windows association took care of knowing to open Access when I clicked on the shortcut. I changed the shortcut to run MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. Thanks to all who responded! Tom Lake

Re: Can't Open mdb "José Luis" <jlcme99[ at ]hotmail.com> 18.06.2006 03:25:44 I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname didn't work, do you have another idea. JOSE LUIS "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message > news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... >>> Has the other user opened it in exclusive mode? Do you get an error >>> messages? >> >> No, all users have shared mode on. There is no error message, the >> hourglass >> appears then disappears immediately with no other activity. As soon as >> the other users are out of the program, I can open it normally. > > I found a way around it although I don't know why. I originally had a > shortcut > to the mdb file on my desktop. The Windows association took care of > knowing > to open Access when I clicked on the shortcut. I changed the shortcut to > run > MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. > Thanks to all who responded! > > Tom Lake >

Re: Can't Open mdb "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 20.06.2006 00:26:45 What exactly did you use in the shortcut? Assuming that there are spaces in the path, you need to have quotes around the path. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "José Luis" <jlcme99[ at ]hotmail.com> wrote in message news:ukNOibokGHA.896[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname > didn't work, do you have another idea. > > JOSE LUIS > > "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje > news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... >> "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message >> news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... >>>> Has the other user opened it in exclusive mode? Do you get an error >>>> messages? >>> >>> No, all users have shared mode on. There is no error message, the >>> hourglass >>> appears then disappears immediately with no other activity. As soon as >>> the other users are out of the program, I can open it normally. >> >> I found a way around it although I don't know why. I originally had a >> shortcut >> to the mdb file on my desktop. The Windows association took care of >> knowing >> to open Access when I clicked on the shortcut. I changed the shortcut to >> run >> MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. >> Thanks to all who responded! >> >> Tom Lake >> > >

Re: Can't Open mdb "José Luis" <jlcme99[ at ]hotmail.com> 20.06.2006 03:29:19 Sorry, it worked fine, running from the shortcut, but still not running from the link directly. Thanks... "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> escribió en el mensaje news:udfx$AAlGHA.4044[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > What exactly did you use in the shortcut? > > Assuming that there are spaces in the path, you need to have quotes around > the path. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "José Luis" <jlcme99[ at ]hotmail.com> wrote in message > news:ukNOibokGHA.896[ at ]TK2MSFTNGP04.phx.gbl... >> I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname >> didn't work, do you have another idea. >> >> JOSE LUIS >> >> "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje >> news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... >>> "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message >>> news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... >>>>> Has the other user opened it in exclusive mode? Do you get an error >>>>> messages? >>>> >>>> No, all users have shared mode on. There is no error message, the >>>> hourglass >>>> appears then disappears immediately with no other activity. As soon as >>>> the other users are out of the program, I can open it normally. >>> >>> I found a way around it although I don't know why. I originally had a >>> shortcut >>> to the mdb file on my desktop. The Windows association took care of >>> knowing >>> to open Access when I clicked on the shortcut. I changed the shortcut >>> to run >>> MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. >>> Thanks to all who responded! >>> >>> Tom Lake >>> >> >> > >

Re: Can't Open mdb "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 20.06.2006 23:11:02 What do you mean by "from the link directly"? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "José Luis" <jlcme99[ at ]hotmail.com> wrote in message news:eFGp2mBlGHA.4104[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Sorry, it worked fine, running from the shortcut, but still not running > from the link directly. > > Thanks... > > "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> escribió en el > mensaje news:udfx$AAlGHA.4044[ at ]TK2MSFTNGP03.phx.gbl... >> What exactly did you use in the shortcut? >> >> Assuming that there are spaces in the path, you need to have quotes >> around the path. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "José Luis" <jlcme99[ at ]hotmail.com> wrote in message >> news:ukNOibokGHA.896[ at ]TK2MSFTNGP04.phx.gbl... >>> I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname >>> didn't work, do you have another idea. >>> >>> JOSE LUIS >>> >>> "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje >>> news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... >>>> "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message >>>> news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... >>>>>> Has the other user opened it in exclusive mode? Do you get an error >>>>>> messages? >>>>> >>>>> No, all users have shared mode on. There is no error message, the >>>>> hourglass >>>>> appears then disappears immediately with no other activity. As soon >>>>> as >>>>> the other users are out of the program, I can open it normally. >>>> >>>> I found a way around it although I don't know why. I originally had a >>>> shortcut >>>> to the mdb file on my desktop. The Windows association took care of >>>> knowing >>>> to open Access when I clicked on the shortcut. I changed the shortcut >>>> to run >>>> MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. >>>> Thanks to all who responded! >>>> >>>> Tom Lake >>>> >>> >>> >> >> > >

Re: Can't Open mdb "José Luis" <jlcme99[ at ]hotmail.com> 28.06.2006 04:10:17 If i click on the link, nothing happens if somebody is using the database But the shortcut is working fine, thanks. "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> escribió en el mensaje news:O2slN7LlGHA.1320[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > What do you mean by "from the link directly"? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "José Luis" <jlcme99[ at ]hotmail.com> wrote in message > news:eFGp2mBlGHA.4104[ at ]TK2MSFTNGP04.phx.gbl... >> Sorry, it worked fine, running from the shortcut, but still not running >> from the link directly. >> >> Thanks... >> >> "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> escribió en el >> mensaje news:udfx$AAlGHA.4044[ at ]TK2MSFTNGP03.phx.gbl... >>> What exactly did you use in the shortcut? >>> >>> Assuming that there are spaces in the path, you need to have quotes >>> around the path. >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no private e-mails, please) >>> >>> >>> "José Luis" <jlcme99[ at ]hotmail.com> wrote in message >>> news:ukNOibokGHA.896[ at ]TK2MSFTNGP04.phx.gbl... >>>> I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname >>>> didn't work, do you have another idea. >>>> >>>> JOSE LUIS >>>> >>>> "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje >>>> news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... >>>>> "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message >>>>> news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... >>>>>>> Has the other user opened it in exclusive mode? Do you get an error >>>>>>> messages? >>>>>> >>>>>> No, all users have shared mode on. There is no error message, the >>>>>> hourglass >>>>>> appears then disappears immediately with no other activity. As soon >>>>>> as >>>>>> the other users are out of the program, I can open it normally. >>>>> >>>>> I found a way around it although I don't know why. I originally had a >>>>> shortcut >>>>> to the mdb file on my desktop. The Windows association took care of >>>>> knowing >>>>> to open Access when I clicked on the shortcut. I changed the shortcut >>>>> to run >>>>> MSACCESS.EXE mdbname and now it works. I don't know why but I'm >>>>> happy. >>>>> Thanks to all who responded! >>>>> >>>>> Tom Lake >>>>> >>>> >>>> >>> >>> >> >> > >

Re: Can't Open mdb "Francisco Córdova" <facglegal[ at ]yahoo.com.mx> 10.09.2006 03:38:32 hola "José Luis" <jlcme99[ at ]hotmail.com> escribió en el mensaje news:ukNOibokGHA.896[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > I'm having the same problem, but the shortcut with MSACCESS.EXE mdbname > didn't work, do you have another idea. > > JOSE LUIS > > "Tom Lake" <tlake[ at ]twcny.rr.com> escribió en el mensaje > news:%237fvo3DjGHA.2188[ at ]TK2MSFTNGP04.phx.gbl... > > "Tom Lake" <tom_lake[ at ]srmtenv.org> wrote in message > > news:estHu37iGHA.1936[ at ]TK2MSFTNGP04.phx.gbl... > >>> Has the other user opened it in exclusive mode? Do you get an error > >>> messages? > >> > >> No, all users have shared mode on. There is no error message, the > >> hourglass > >> appears then disappears immediately with no other activity. As soon as > >> the other users are out of the program, I can open it normally. > > > > I found a way around it although I don't know why. I originally had a > > shortcut > > to the mdb file on my desktop. The Windows association took care of > > knowing > > to open Access when I clicked on the shortcut. I changed the shortcut to > > run > > MSACCESS.EXE mdbname and now it works. I don't know why but I'm happy. > > Thanks to all who responded! > > > > Tom Lake > > > >