network or local machine

[Guest]

The users of my database with backend on network and frontend on their
computer are complaining about the slow speed of running reports. There are
only
a few users and the users dont make any changes to tables. If I were to
install the entire unsplit database on each user's computer, they would be
able to able to run reports much faster. I have to make fortnighly additions
to these tables so I will have to update the database on their computers
every time but I have to update backend tables anyways with the existing
setup. I am hoping to get feedback and ideas on this.

 

[G. Vaught]

Don't do that, don't unsplit the database on each users machine. You will
have updating nightmares.

The mostly likely problem is the server you are using and the connectivity
between them and the machine.

The other possibility is you need to compact/repair the database when nobody
is connected to the database. First, make sure that everyone has the
frontend closed on their own machine. If you issue a compact/repair be sure
you open the database in exclusive mode. After you do the backend, then do
each user's machine.

The last possibility is that the reports need redesigning.

 

[G. Vaught]

I read your post again and the last sentence has me perplexed. If you link
the tables into the frontend, their is no updating needed by anybody other
than the data entry people. You may have your frontend/backend connected
incorrectly.

 

[Albert D.Kallal]

You don't mention the number of users, and how large these tables are.

What I would do before you consider trying to send all the data as a single
mdb file to each computer is simply check some things to restore
performance.

The #1 trick to restore performance is to try a persistent connection. (that
means in your startup code in the front end, you open a table to the back
end ..and KEEP it open). Give this concept a try, as this usually restores
performance back to un-split levels.

It does depend on what kind of network you are also talking about? Is the
office network of high quality and speed?

Also, check out the following performance eFAQ, as it tells you about the
persistent connection (that I seen speed things up by MORE THEN a factor of
100 times!!). Check each of the suggestions, and by the time you are
finished, you may have adequate performance that you can continue to share
the data as is..


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

 

[Guest]

There is no data entry in my database by users. Users are using database only
to run reports(queries). These queries are based on sales data table which is
a part of the backend lying on the server. I have to append records to this
table every 2 weeks or so. The FE with all the queries/reports etc. is on the
users' computers. This is the setup that I have now. I am debating whether I
really need to split the database as I am doing now or if I can load the
entire unsplit database on each user's machine . I dont see any reason for
splitting the database because there is no data entry by users; please let me
know if I am wrong.

 

[Guest]

There will be like upto 5 users for now. There is only one big table in the
db and that table has approx 800,000 records. Other tables are very small ,
none is more than 50 records.

 

[Tony Toews]

The users of my database with backend on network and frontend on their
computer are complaining about the slow speed of running reports.

FWIW reports with subreports on them are always slow due to the nature
of the beast. Do you have any subreports?

Albert has already suggesting visiting the performance FAQ page which
should help.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm