Re: Fastest way to do this?
- From: eselk@xxxxxxxxxxxx
- Date: Fri, 30 Nov 2007 09:10:38 -0800 (PST)
On Nov 29, 1:17 pm, insomniux <dispos...@xxxxxxxxxxxxxx> wrote:
Running access over the network usually is extremely slow. My solution
was to install a 'local user-interface' of the database on each PC
with linked tables to the central database (btw in my case not an
access database). The user-interface only had the forms/reports/
modules, but no tables. This gave an extreme boost in speed. As I
understand you have the solution already at hand in VBA using a
recordset, this could solve your speed problem.- Hide quoted text -
Yes, in my mind this is the *only* way to go. I'm not using Access or
VBA as my front-end though so this isn't really related to my speed
issue, I'm writing an app using C++ which uses DAO, but I do my
testing and proto-type stuff in Access and using DAO the way I do
isn't much different than using it from VBA so my questions/comments
still apply to this news-group. Also, I always get almost identical
speed testing results in Access or in my C++ code (which makes since,
because Access 2000 is using DAO basicly the same way I do).
Anyway, even with an EXE I've found that it is a really bad idea to
have your "code" (VBA script, forms, whatever it may be) located on a
network share. You can use network monitor to see that Windows goes
out to the EXE/code a lot as your code is running (it doesn't just
keep the entire EXE in memory like one might think). This is basicly
what a "General Page Fault" is, when Windows wants to get your code,
but it is GONE/moved because the network connection was reset.
Although, that being said, I'd think Access would just keep a local
cache of the forms and scripts (or keep in memory) so it doesn't need
to access the network each time. It requires exclusive access to edit
code/forms/reports anyway, so not like they need to keep checking to
see if the code was modified by another user.
.
- References:
- Fastest way to do this?
- From: eselk
- Re: Fastest way to do this?
- From: Salad
- Re: Fastest way to do this?
- From: eselk
- Re: Fastest way to do this?
- From: insomniux
- Fastest way to do this?
- Prev by Date: Re: Append Table problem
- Next by Date: Re: Couple of questions about the MSAccess environment
- Previous by thread: Re: Fastest way to do this?
- Next by thread: Re: Fastest way to do this?
- Index(es):
Relevant Pages
|
