Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 9th, 2008, 05:59 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default Slow move to last page

I create button to preview the report in access 2007.
when I click the button to preview the report, the report open
after that I click to last page option, it will take long time
to go / move to last page, it take approx 50 or 60 second
to go / move to last page. why ?

Now I have only 50 records in db.
only one time it take long time to move / to go to last page after that it work quick

table field like this

REC_ID AUTONUMBER PK
DEMAGE TEXT
DESCRIPTION TEXT
.....
..

What properties will change in the report it work fast / quick.
what properties will change in the report it move to last record quickly ?

Thanks and regards
Mateen
 
Old June 10th, 2008, 06:57 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

There are many things that can slow down your report.

1) Is the data (i.e. back end) on the network?
2) Is the report based on a complicated query?
3) Do you have VBA in the report that is slowing it down, e.g. DLOOKUP() function?
4) Where is the front end?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 10th, 2008, 07:51 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your response.

1) I splits the db, table are separate folder and forms, reports are separate
   folder.
   both folders are same network folder.
   g:\db\Reinstatement.accdb forms and reports
   g:\db\db_table_be.accdb table folder
2) no, simple query, by report wizard
3) no
4) I make main menu form, users click the main meun to open the db program.

Thanks
Mateen




 
Old June 10th, 2008, 07:55 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

It looks like your front end is also on the network. Do people share it? That is not good.

There should be many copies of the front end on everyone's C: drive. The tables (back end) would stay on the G: drive. With everyone sharing the front end on the network, it'd slow you down and also can cause problems.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 10th, 2008, 09:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, people share it. G: DRIVE is share.
how can users access the form / open the form ?

we have one network folder where db forms are save, users click
this forms by network.

can you explain more, how to use db form that each users access the forms
for the data entries and report etc ?

Thanks and regards
Mateen


 
Old June 10th, 2008, 11:40 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

You place the back end and the front end on G:. The back end is where all the data is stored. The front end connects to it. Although the front end is also on G:, users do NOT use that one.

You give them all a start-up batch file that copies the front end from G: to a folder in C:. The users all use their individual C: drive copies. Then if you have to make changes to the front end, you place the new one on G: and their batch routine copies it from G: to C: automatically when they boot up.

In that way, they all always have the same front end, but they are not sharing ONE, they are each using their own.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 11th, 2008, 05:53 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for response.

1) I have to make batch file like this. Reinstatement_db.bat

cd
net use G:
cd\ projects\reinstatement_db\........ (how form will run) ?

can you explain more ?

2) or if I make batch file it will copy from G: drive to C: Drive
so users will open the form from his C:\ DRIVE ?
I have to forms database ?

3) When I need update the form, I will update at G: drive,
each time user login batch file will copy all forms db to user C:\ DRIVE

Thanks
Mateen
 
Old June 11th, 2008, 07:01 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

1) I don't know what that is so I cannot help you there. The batch file I am thinking about sounds like...

2) In your batch file you have

COPY G:\db\Reinstatement.accdb C:\db
The users will open the forms from C:.

3) Yes, that is how it would work.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 14th, 2008, 11:43 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Very nice,

It is very good feature in 2007 that users run the form from C drive
it will save the records in Network Drive. we will use first time like this
to store db in network folder and users will open the form from his C Drive.

For the moving the db table / forms etc, it not necessary to use import / export method. it can be easily move just copy the db ?

Thaks and regards
Mateen





 
Old June 16th, 2008, 07:24 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Yes, I just do a simple copy of the database. Good luck!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
Page is Loading too Slow kornshell Classic ASP Basics 7 October 16th, 2008 09:28 AM
Slow page Loading yadavrahul2k5 ASP.NET 2.0 Professional 5 August 13th, 2007 07:12 AM
Initial Page is slow to load bjoneskc BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 2 July 7th, 2007 11:14 AM
.net page loading is slow angshujit .NET Framework 1.x 1 December 26th, 2006 07:53 AM
Slow page kherrerab BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 September 5th, 2006 09:50 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.