For the defaults it's no locks.
I don't change the default lock settings on queries (which I assume is no locks), but the majority of the queries are coded so I can pass variables into them.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Lee,
>
> What are your default Record-Locking choices in
> Tool\Options\Advanced\default_record_locking?
>
> What are the settings for Record_Locks in the
> queries used for creating the 'report'?
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@> wrote:
> >
> > Lee-
> >
> > Opening a recordset and leaving it open on startup should make a world of
> > difference. But you also need to take a look at the report. Even 15 minutes
> > seems excessive. What recordsets are being used by the report and why are they
> > so slow? Do you have appropriate indexes defined?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> > -----------------------------------
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
> > Sent: Wednesday, April 11, 2012 5:58 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Concurrent users causing MASSIVE latency issues
> >
> >
> > Hi,
> > I have a front end/back end database with about 5 active users, usually no more
> > than 2 are in the file at one time. for single row transactions there are no
> > issues, however, for some of the larger reports/queries, if ONE extra person is
> > in the file, it causes HUGE latency issues.
> >
> > One report that normally takes about 10 minutes to run was abandoned after 90
> > minutes. I found 1 extra user in the file, kicked them out, and re-ran the
> > report and it took 15 minutes (which is the slow side of normal).
> >
> > Is there a setting somewhere I can check? This is causing some big problems and
> > it's causing my other projects to get scrutinized, ONE user should NOT be
> > causing this much delay, but every time the file is running slow if I kick
> > everyone out and change nothing else, the performance is back to normal. (I now
> > have a routine that permanently opens a recordset for each user since someone
> > advised that, but I don't have enough feedback to know what difference, if any,
> > it's making)
> >
> > Thanks
> > -Lee
> >
>
Tidak ada komentar:
Posting Komentar