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

Rabu, 28 November 2012

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

John-

Oh, are the users opening a shared "front end" from the server? That's
not a good idea. Give each user their own copy of the front end database
to be opened locally on each machine.

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: Wednesday, November 28, 2012 3:26 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Re: Slow performance in a split database

Crystal,
I put the backend and the users frontend in the root directory of the
server. My frontend resides in a development subfolder.

John F.

--- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@...> wrote:
>
> use a SHORT PATH to the back-end for better performance. Map a drive if
>the path is lots of characters
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
> ________________________________
> From: John Viescas <JohnV@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, November 26, 2012 8:19 AM
> Subject: 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@...>
> 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