Access performance

[Ilja Mihailovs]

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 AccessMonster.com]

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

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

 

[Jeff Boyce]

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]

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]

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.