Exclusive error Glen 02.08.2006 00:53:02 I have a database, Trakker.mdb, that is on a server. Each user has Microsoft Access on their individual computers. Trakker.mdb is not split. If person A opens Trakker.mdb first, then person B gets an error message about Trakker.mdb being open exclusively. Person B has to hit the OK button 30 times to get the message to go away. [Yes, she counted 30.] On the other hand, if person B opens the database first, person A does NOT get the same error message. Both persons use a icon on their desktop to open the database. The shortcuts are identical. Any suggestions?

Re: Exclusive error "Keith Wilby" <here[ at ]there.com> 02.08.2006 08:24:40 "Glen" <Glen[ at ]discussions.microsoft.com> wrote in message news:AB6E52FE-E848-4E27-8ECD-D9CD6BEDF71D[ at ]microsoft.com... [Quoted Text] >I have a database, Trakker.mdb, that is on a server. > Each user has Microsoft Access on their individual computers. Trakker.mdb > is > not split. > > If person A opens Trakker.mdb first, then person B gets an error message > about Trakker.mdb being open exclusively. Person B has to hit the OK > button > 30 times to get the message to go away. [Yes, she counted 30.] > > On the other hand, if person B opens the database first, person A does NOT > get the same error message. > > Both persons use a icon on their desktop to open the database. The > shortcuts > are identical. > > Any suggestions? Make sure the default open mode is set to "shared". Split your database and give each user their own FE. Regards, Keith. www.keithwilby.com

Re: Exclusive error "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 02.08.2006 11:17:18 "Keith Wilby" <here[ at ]there.com> wrote in message news:44d05e81$1_1[ at ]glkas0286.greenlnk.net... [Quoted Text] > "Glen" <Glen[ at ]discussions.microsoft.com> wrote in message > news:AB6E52FE-E848-4E27-8ECD-D9CD6BEDF71D[ at ]microsoft.com... >>I have a database, Trakker.mdb, that is on a server. >> Each user has Microsoft Access on their individual computers. Trakker.mdb >> is >> not split. >> >> If person A opens Trakker.mdb first, then person B gets an error message >> about Trakker.mdb being open exclusively. Person B has to hit the OK >> button >> 30 times to get the message to go away. [Yes, she counted 30.] >> >> On the other hand, if person B opens the database first, person A does >> NOT >> get the same error message. >> >> Both persons use a icon on their desktop to open the database. The >> shortcuts >> are identical. >> >> Any suggestions? > > Make sure the default open mode is set to "shared". Split your database > and give each user their own FE. Also, make sure that each user has full rights to the folder where the BE database exists (they need Read, Write, Delete and Execute) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please)

Re: Exclusive error "JohnC" <anonymous[ at ]news.groups.com> 03.08.2006 02:13:01 Does user "A" have Adobe Acrobat or Adobe Professional 7.0 or later (not the reader) installed? This version of Adobe installs by default the PDFMaker in all MS Office applications. The PDFMaker creates a toolbar and in a shared application such as Access, you get the error as you mentioned. The PDFMaker really isn't necessary in Access because the user can still print to the Adobe printer to create the .pdf file. Easy fix, In Add/Remove Programs, Adobe Acrobat (or Professional), Change, expand Create PDF, expand PDFMaker, and select "do not run from computer" for Access. John "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:OBPS4UitGHA.2260[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > "Keith Wilby" <here[ at ]there.com> wrote in message > news:44d05e81$1_1[ at ]glkas0286.greenlnk.net... >> "Glen" <Glen[ at ]discussions.microsoft.com> wrote in message >> news:AB6E52FE-E848-4E27-8ECD-D9CD6BEDF71D[ at ]microsoft.com... >>>I have a database, Trakker.mdb, that is on a server. >>> Each user has Microsoft Access on their individual computers. >>> Trakker.mdb is >>> not split. >>> >>> If person A opens Trakker.mdb first, then person B gets an error message >>> about Trakker.mdb being open exclusively. Person B has to hit the OK >>> button >>> 30 times to get the message to go away. [Yes, she counted 30.] >>> >>> On the other hand, if person B opens the database first, person A does >>> NOT >>> get the same error message. >>> >>> Both persons use a icon on their desktop to open the database. The >>> shortcuts >>> are identical. >>> >>> Any suggestions? >> >> Make sure the default open mode is set to "shared". Split your database >> and give each user their own FE. > > Also, make sure that each user has full rights to the folder where the BE > database exists (they need Read, Write, Delete and Execute) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > >