ACCESS FEED: [MS_AccessPros] Re: Slow performance in a split database

Senin, 26 November 2012

[MS_AccessPros] Re: Slow performance in a split database

That's what is so strange, all of my dbs are configured the same way, I only have this problem with two of them.

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> John F-
>
> What is different about that one user's environment or what the user is
> doing?
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: "jfakes.rm" <jfakes@...>
> Reply-To: <MS_Access_Professionals@yahoogroups.com>
> Date: Monday, November 26, 2012 3:19 PM
> To: <MS_Access_Professionals@yahoogroups.com>
> Subject: [MS_AccessPros] Re: Slow performance in a split database
>
> John,
> Thanks for the explanation, however, why is this only occuring on two of
> my databases?
>
> John F
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > Tim-
> >
> > If your application has a form that opens and stays open for the duration
> > of the run, you can put something like this in the form code:
> >
> > Option Compare Database
> > Option Explicit
> > Dim db As DAO.Database, rst As DAO.Recordset
> >
> > Private Sub Form_Load()
> >
> > ' Point to this database
> > Set db = CurrentDb
> > ' Open any linked table and leave it open
> > Set rst = db.OpenRecordset("SELECT * FROM LinkedTable")
> >
> > End Sub
> >
> > Private Sub Form_Close()
> > ' Close and clean up the open recordset
> > rst.Close
> > Set rst = Nothing
> > Set db = Nothing
> > End Sub
> >
> >
> > John Viescas, Author
> > Microsoft Access 2010 Inside Out
> > Microsoft Access 2007 Inside Out
> > Microsoft Access 2003 Inside Out
> > Building Microsoft Access Applications
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: timdbui <timdbui@>
> > Reply-To: <MS_Access_Professionals@yahoogroups.com>
> > Date: Saturday, November 24, 2012 2:56 PM
> > To: <MS_Access_Professionals@yahoogroups.com>
> > Subject: Re: [MS_AccessPros] Slow performance in a split database
> >
> > Dear Mr. Viescas:
> >
> > I have similar slowness problem. Would you please elaborate you point on
> > "open record set on the backend"? How can I do that.
> >
> > Thanks for your help!
> >
> > Tim
> > .
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> > wrote:
> > >
> > > John F-
> > >
> > > In general, if two users have a frontend open, but neither has a
> > >permanent
> > > connection to the back end (like a recordset left open at startup),
> >they
> > > will fight each other to establish a new connection every time a new
> > > object gets opened. The solution is to open a recordset on the backend
> > >on
> > > startup and keep it open until exit. There will be some overhead in
> > > opening the recordset if someone else already has the backend open, but
> > > all other connections will share the already established one.
> > >
> > > John Viescas, Author
> > > Microsoft Access 2010 Inside Out
> > > Microsoft Access 2007 Inside Out
> > > Microsoft Access 2003 Inside Out
> > > Building Microsoft Access Applications
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: "jfakes.rm" <jfakes@>
> > > Reply-To: <MS_Access_Professionals@yahoogroups.com>
> > > Date: Friday, November 23, 2012 8:32 PM
> > > To: <MS_Access_Professionals@yahoogroups.com>
> > > Subject: [MS_AccessPros] Slow performance in a split database
> > >
> > > Ok here is another one of those weird ones.
> > >
> > > I admin several split databases. In two of them, when I access the
> > > database in a development frontend, I notice a huge slow down when
> > >another
> > > user access the database using a different frontend. In one of the
> > > databases, I only notice when one certain user logs in. When other
> >users
> > > log in (again different frontend) I don't notice any issues.
> > >
> > > This only occurs in two databases and none of the other dbs. I connect
> > > and have them are configured the same way (same versions, connection
> > > method etc.).
> > >
> > > Any idea why the slowdown on only two databases?
> > >
> > > John F