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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar