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

Sabtu, 24 November 2012

Re: [MS_AccessPros] Slow performance in a split database

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@gmail.com>
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