Migrating from mdb to ADP: dbengine.idle dbRefreshcache "Mark" <asd[ at ]notMe.com> 22.02.2006 11:43:08 Hi Using Access XP (with integrated windows security), MSDE and a very very slow network. I am migrating a small mdb to ADP and have many instances where I use "dbEngine.Idle dbRefreshCache" etc. When I use this in the ADP I am getting prompted for a (Workgroup) login etc. As far as I can tell this only happens the first time. I have two questions then: First: Is it necessary to use "dbEngine.Idle dbRefreshCache" when working with an MSDE backend? And second: If the answer to the first question is yes then how do I prevent the login dialog popping up? Thanks very much Mark

Re: Migrating from mdb to ADP: dbengine.idle dbRefreshcache "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 22.02.2006 14:49:19 No, it's not necessary to use it for MSDE and regular ADO commands or when you have created a DBEngine to issue DAO commands against the MSDE database. However, if you have openened a MDB, then of course you must use it if necessary (ie. this MDB file is not opened for your exclusive use and other people use it, too). -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Mark" <asd[ at ]notMe.com> wrote in message news:g7YKf.42982$K42.12247[ at ]newsfe7-win.ntli.net... [Quoted Text] > Hi > > Using Access XP (with integrated windows security), MSDE and a very very > slow network. > > I am migrating a small mdb to ADP and have many instances where I use > "dbEngine.Idle dbRefreshCache" etc. > > When I use this in the ADP I am getting prompted for a (Workgroup) login > etc. As far as I can tell this only happens the first time. > > I have two questions then: > > First: Is it necessary to use "dbEngine.Idle dbRefreshCache" when working > with an MSDE backend? > > And second: If the answer to the first question is yes then how do I > prevent the login dialog popping up? > > Thanks very much > > Mark > > >

Re: Migrating from mdb to ADP: dbengine.idle dbRefreshcache "Mark" <asd[ at ]notMe.com> 22.02.2006 20:12:03 Thanks Sylvian :[ at ]) "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in message news:%2341Ir87NGHA.2176[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] > No, it's not necessary to use it for MSDE and regular ADO commands or when > you have created a DBEngine to issue DAO commands against the MSDE > database. > > However, if you have openened a MDB, then of course you must use it if > necessary (ie. this MDB file is not opened for your exclusive use and > other people use it, too). > > -- > Sylvain Lafontaine, ing. > MVP - Technologies Virtual-PC > E-mail: http://cerbermail.com/?QugbLEWINF > > > "Mark" <asd[ at ]notMe.com> wrote in message > news:g7YKf.42982$K42.12247[ at ]newsfe7-win.ntli.net... >> Hi >> >> Using Access XP (with integrated windows security), MSDE and a very very >> slow network. >> >> I am migrating a small mdb to ADP and have many instances where I use >> "dbEngine.Idle dbRefreshCache" etc. >> >> When I use this in the ADP I am getting prompted for a (Workgroup) login >> etc. As far as I can tell this only happens the first time. >> >> I have two questions then: >> >> First: Is it necessary to use "dbEngine.Idle dbRefreshCache" when working >> with an MSDE backend? >> >> And second: If the answer to the first question is yes then how do I >> prevent the login dialog popping up? >> >> Thanks very much >> >> Mark >> >> >> > >

Re: Migrating from mdb to ADP: dbengine.idle dbRefreshcache "david epsom dot com dot au" <david[ at ]epsomdotcomdotau> 24.02.2006 07:26:32 MSDE uses a different cache, and a different login. It is interesting that you are getting prompted for a workgroup login when you refresh the Jet data cache, but if the engine hadn't had to log in previously, then there can't be anything in that cache worth refreshing. (david) "Mark" <asd[ at ]notMe.com> wrote in message news:g7YKf.42982$K42.12247[ at ]newsfe7-win.ntli.net... [Quoted Text] > Hi > > Using Access XP (with integrated windows security), MSDE and a very very > slow network. > > I am migrating a small mdb to ADP and have many instances where I use > "dbEngine.Idle dbRefreshCache" etc. > > When I use this in the ADP I am getting prompted for a (Workgroup) login > etc. As far as I can tell this only happens the first time. > > I have two questions then: > > First: Is it necessary to use "dbEngine.Idle dbRefreshCache" when working > with an MSDE backend? > > And second: If the answer to the first question is yes then how do I > prevent the login dialog popping up? > > Thanks very much > > Mark > > >