Access performance

Ilja Mihailovs · External Since: Sep 30, 2009 Posts: 2

The situation is that I have an application running from a shared folder on
Windows 2003 Server. This application uses Access 2003 as a database. Two
users are simultaneously opening that application (from a share). When this
happens, one of the users has abnormally slow data extraction. Assuming that
network is alright, ports are good and firewalls are either off or correctly
configured, what can cause such slow performance? Is it Access issue or a
share misconfiguration? Can u suggest any configuration options?

Best regards!

AccessVandal via AccessMo · External Since: Apr 19, 2006 Posts: 40

Is the database split? Try to read up on Tony's site on performance issue
here.

http://www.granite.ab.ca/access/performancefaq.htm

Ilja Mihailovs wrote:
>The situation is that I have an application running from a shared folder on
>Windows 2003 Server. This application uses Access 2003 as a database. Two
>users are simultaneously opening that application (from a share). When this
>happens, one of the users has abnormally slow data extraction. Assuming that
>network is alright, ports are good and firewalls are either off or correctly
>configured, what can cause such slow performance? Is it Access issue or a
>share misconfiguration? Can u suggest any configuration options?
>
>Best regards!

--
Please Rate the posting if helps you.

Message posted via http://www.accessmonster.com

Jeff Boyce · External Since: Nov 04, 2004 Posts: 2342

If I'm interpreting your description correctly, you have a single database
(file) that's being shared by multiple users.

Why? Do your users also share a single (on the network) copy of Word? ...
or Excel? Why would they need to share a single copy of a database
application?

The common approach to having multiple users share an Access
database/application is to, as described else-thread, "split" the database
into one file that holds only data and lives on your network, and a second
file that holds everything else besides data, links to the data and exists
as ONE COPY PER USER on each user's PC. What gets shared is the data, not
the application...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Ilja Mihailovs" <Ilja Mihailovs RemoveThis @discussions.microsoft.com> wrote in message
news:FAB6387C-FCEA-4D7C-988D-705D33F9E057@microsoft.com...
> The situation is that I have an application running from a shared folder
> on
> Windows 2003 Server. This application uses Access 2003 as a database. Two
> users are simultaneously opening that application (from a share). When
> this
> happens, one of the users has abnormally slow data extraction. Assuming
> that
> network is alright, ports are good and firewalls are either off or
> correctly
> configured, what can cause such slow performance? Is it Access issue or a
> share misconfiguration? Can u suggest any configuration options?
>
> Best regards!

Ilja Mihailovs · External Since: Sep 30, 2009 Posts: 2

I think we are misunderstanding each other here.

Thing is. My enterprise uses custom application written by a external
company. The executable connects to an Access database. The application is
NOT designed in a Access itself, it only uses it as a database. Everything
(including executable and a DB) is stored in a share on a server. Two users
simultaneously are working with the executable (launching it from a share).
Executable works with the DB, so to me it is no use in splitting the DB. One
user has extremely good response times (data is extracted quite fast). In
controversy, second user has to wait 1-2 minutes for the data to appear. Both
PCs are configured in the same way, no differences there.

Can someone suggest any share / DB tuning approach?

"Jeff Boyce" wrote:

> If I'm interpreting your description correctly, you have a single database
> (file) that's being shared by multiple users.
>
> Why? Do your users also share a single (on the network) copy of Word? ...
> or Excel? Why would they need to share a single copy of a database
> application?
>
> The common approach to having multiple users share an Access
> database/application is to, as described else-thread, "split" the database
> into one file that holds only data and lives on your network, and a second
> file that holds everything else besides data, links to the data and exists
> as ONE COPY PER USER on each user's PC. What gets shared is the data, not
> the application...
>
> Good luck!
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Ilja Mihailovs" <Ilja Mihailovs.DeleteThis@discussions.microsoft.com> wrote in message
> news:FAB6387C-FCEA-4D7C-988D-705D33F9E057@microsoft.com...
> > The situation is that I have an application running from a shared folder
> > on
> > Windows 2003 Server. This application uses Access 2003 as a database. Two
> > users are simultaneously opening that application (from a share). When
> > this
> > happens, one of the users has abnormally slow data extraction. Assuming
> > that
> > network is alright, ports are good and firewalls are either off or
> > correctly
> > configured, what can cause such slow performance? Is it Access issue or a
> > share misconfiguration? Can u suggest any configuration options?
> >
> > Best regards!
>
>
>

Jeff Boyce · External Since: Nov 04, 2004 Posts: 2342

If this is a custom application not written in Access, and only using an
Access data store, I would think the folks you need to check with about
tuning the performance of that app would be the developers of that app.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Ilja Mihailovs" <Ilja Mihailovs.DeleteThis@discussions.microsoft.com> wrote in message
news:DB95A8AA-8088-4694-A978-AD2C51ABC993@microsoft.com...
>I think we are misunderstanding each other here.
>
> Thing is. My enterprise uses custom application written by a external
> company. The executable connects to an Access database. The application is
> NOT designed in a Access itself, it only uses it as a database. Everything
> (including executable and a DB) is stored in a share on a server. Two
> users
> simultaneously are working with the executable (launching it from a
> share).
> Executable works with the DB, so to me it is no use in splitting the DB.
> One
> user has extremely good response times (data is extracted quite fast). In
> controversy, second user has to wait 1-2 minutes for the data to appear.
> Both
> PCs are configured in the same way, no differences there.
>
> Can someone suggest any share / DB tuning approach?
>
> "Jeff Boyce" wrote:
>
>> If I'm interpreting your description correctly, you have a single
>> database
>> (file) that's being shared by multiple users.
>>
>> Why? Do your users also share a single (on the network) copy of Word?
>> ...
>> or Excel? Why would they need to share a single copy of a database
>> application?
>>
>> The common approach to having multiple users share an Access
>> database/application is to, as described else-thread, "split" the
>> database
>> into one file that holds only data and lives on your network, and a
>> second
>> file that holds everything else besides data, links to the data and
>> exists
>> as ONE COPY PER USER on each user's PC. What gets shared is the data,
>> not
>> the application...
>>
>> Good luck!
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>>
>> "Ilja Mihailovs" <Ilja Mihailovs.DeleteThis@discussions.microsoft.com> wrote in
>> message
>> news:FAB6387C-FCEA-4D7C-988D-705D33F9E057@microsoft.com...
>> > The situation is that I have an application running from a shared
>> > folder
>> > on
>> > Windows 2003 Server. This application uses Access 2003 as a database.
>> > Two
>> > users are simultaneously opening that application (from a share). When
>> > this
>> > happens, one of the users has abnormally slow data extraction. Assuming
>> > that
>> > network is alright, ports are good and firewalls are either off or
>> > correctly
>> > configured, what can cause such slow performance? Is it Access issue or
>> > a
>> > share misconfiguration? Can u suggest any configuration options?
>> >
>> > Best regards!
>>
>>
>>