Access 2007 replacement for mslldbusr? "rick_teller via AccessMonster.com" <u47952[ at ]uwe> 12/5/2008 11:37:55 PM We have an application (VB frontend, Access 2000 backend) that we are considering moving to Access 2007. One question for which I haven't found an answer - is there an Access 2007 version of msldbusr.dll. Currently we call a method from this library (LDBUser_GetUsers) to see how many users are logged on to the database when any user opens the application. We are using DAO 3.6 in the current version of the app, and plan to move to the updated version of DAO provided by the Access Runtime Engine. Is there a more direct way to determine the number of current users? -- Message posted via http://www.accessmonster.com

Re: Access 2007 replacement for mslldbusr? Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 12/6/2008 4:09:30 AM On Fri, 05 Dec 2008 23:37:55 GMT, "rick_teller via AccessMonster.com" <u47952[ at ]uwe> wrote: I'm 99% sure you can continue to use the same one. -Tom. Microsoft Access MVP [Quoted Text] >We have an application (VB frontend, Access 2000 backend) that we are >considering moving to Access 2007. One question for which I haven't found an >answer - is there an Access 2007 version of msldbusr.dll. Currently we call a >method from this library (LDBUser_GetUsers) to see how many users are logged >on to the database when any user opens the application. We are using DAO 3.6 >in the current version of the app, and plan to move to the updated version of >DAO provided by the Access Runtime Engine. Is there a more direct way to >determine the number of current users?

Re: Access 2007 replacement for mslldbusr? "Pete D." <pduffy211AT[ at ]coxDOT.net> 12/6/2008 5:08:12 PM I just tested it and it works fine. "rick_teller via AccessMonster.com" <u47952[ at ]uwe> wrote in message news:8e3acb19f56b6[ at ]uwe... [Quoted Text] > We have an application (VB frontend, Access 2000 backend) that we are > considering moving to Access 2007. One question for which I haven't found > an > answer - is there an Access 2007 version of msldbusr.dll. Currently we > call a > method from this library (LDBUser_GetUsers) to see how many users are > logged > on to the database when any user opens the application. We are using DAO > 3.6 > in the current version of the app, and plan to move to the updated version > of > DAO provided by the Access Runtime Engine. Is there a more direct way to > determine the number of current users? > > -- > Message posted via http://www.accessmonster.com >

Re: Access 2007 replacement for mslldbusr? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/6/2008 8:52:31 PM Another option would be to use the technique outlined in http://support.microsoft.com/kb/198755/EN-US/ You'd need to change your connection string if you're using an ACCDB. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "rick_teller via AccessMonster.com" <u47952[ at ]uwe> wrote in message news:8e3acb19f56b6[ at ]uwe... [Quoted Text] > We have an application (VB frontend, Access 2000 backend) that we are > considering moving to Access 2007. One question for which I haven't found > an > answer - is there an Access 2007 version of msldbusr.dll. Currently we > call a > method from this library (LDBUser_GetUsers) to see how many users are > logged > on to the database when any user opens the application. We are using DAO > 3.6 > in the current version of the app, and plan to move to the updated version > of > DAO provided by the Access Runtime Engine. Is there a more direct way to > determine the number of current users? > > -- > Message posted via http://www.accessmonster.com >

Re: Access 2007 replacement for mslldbusr? "rick_teller via AccessMonster.com" <u47952[ at ]uwe> 12/8/2008 6:27:54 PM Thanks for the reply. I realize that this dll works with the new file format. But since we have to include the dll on our installation CD, I was wondering if there is a more up-to-date version to include along with the newer runtime files. Tom van Stiphout wrote: [Quoted Text] >I'm 99% sure you can continue to use the same one. > >-Tom. >Microsoft Access MVP > >>We have an application (VB frontend, Access 2000 backend) that we are >>considering moving to Access 2007. One question for which I haven't found an >[quoted text clipped - 4 lines] >>DAO provided by the Access Runtime Engine. Is there a more direct way to >>determine the number of current users? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200812/1