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

Senin, 26 November 2012

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

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@rocketmail.com>
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
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links