473,224 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Slow form/report design

Have recently upgraded to Windows XP and latest Access 2003 from
Windows 98 and Access 97. Distribute a lot of front end applications
linked to network based data files. During normal working hours the
loading of forms and reports in design mode is slow; response time to
keyboard/mouse commands is horrible. After network activity is slowed
down, normal design reactions resume. Yes, I have refreshed the links
in my applications. Have the same problem in brand new applications.
Obviously there is some problem with network settings, but our IT
people are stumped. Does anyone have a suggestion that doesn't
require me to work a night shift? Thanks for your help.
Nov 12 '05 #1
2 4806
First, of course windows xp is a complete different operating system..one
that attaches security settings to every file on the system (win98 had no
such system). So, from a "difference" point of view the difference in
systems is huge.

I remember walking up to a server, copying a file to the desktop on the
server, and then copying the file to a shard folder for everyone on the
network. Guess what, that shared folder had complete open permissions..but
that silly little file I copied to the folder could NOT be accessed by
anyone. Of course, the problem here was that when I copied the file to the
server's desktop..it inherited the security settings that the server had.

Even more strange is was when I went home and ftp'ed the file to the same
directory..everyone could use the file!

My only point here is that the difference the file systems from win98 to
winxp are really very huge.

Of course, with all that security checking..then file connecting is VERY
SLOW. The solution (9 out of 10 times) is simply to KEEP a connection opened
to the database. That means the front end needs to open any table on the
back end..and KEEP it open. (this thus keeps the file open..and thus all the
extra huge security stuff does not occur when you open a table).

Give the above trick a try..and report back here.

Also, check out the above trick..and few other pointers to get your speed
back up to normal at the following link..it is real gem:

http://www.granite.ab.ca/access/performancefaq.htm:
--
Albert D. Kallal (Acess MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #2
"Albert D. Kallal" <ka****@msn.com> wrote in message news:<eOemc.360670$Pk3.316967@pd7tw1no>...
First, of course windows xp is a complete different operating system..one
that attaches security settings to every file on the system (win98 had no
such system). So, from a "difference" point of view the difference in
systems is huge.

I remember walking up to a server, copying a file to the desktop on the
server, and then copying the file to a shard folder for everyone on the
network. Guess what, that shared folder had complete open permissions..but
that silly little file I copied to the folder could NOT be accessed by
anyone. Of course, the problem here was that when I copied the file to the
server's desktop..it inherited the security settings that the server had.

Even more strange is was when I went home and ftp'ed the file to the same
directory..everyone could use the file!

My only point here is that the difference the file systems from win98 to
winxp are really very huge.

Of course, with all that security checking..then file connecting is VERY
SLOW. The solution (9 out of 10 times) is simply to KEEP a connection opened
to the database. That means the front end needs to open any table on the
back end..and KEEP it open. (this thus keeps the file open..and thus all the
extra huge security stuff does not occur when you open a table).

Give the above trick a try..and report back here.

Also, check out the above trick..and few other pointers to get your speed
back up to normal at the following link..it is real gem:

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

Thanks Albert. Preliminary indications are that this works
(Experience tells me not to get too excited too soon). Also thanks
for the link - lots of value there. Ain't progress wonderful!!!
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: sleepyant | last post by:
Hi, I'm using VB .NET 2003. I have a form which only has a CrystalReportViewer to view a report on screen. But every time I run then project, the form is shown but the Report itself is very slow to...
16
by: David Lauberts | last post by:
Hi Wonder if someone has some words of wisdom. I have a access 2002 form that contains 2 graph objects that overlay each other and would like to export them as a JPEG to use in a presentation....
3
by: Ranman | last post by:
Hi all, I have a simple problem that hopefully has a simple solution, but I have yet to figure it out. In a patient database, I have a physician test order form that populates a report that is...
5
by: DFS | last post by:
Situation: Access 2003 front-end, containing links to Access 2003, SQL Server 2000, and DB2 tables. None of these tables are local. Hardware: IBM ThinkCentre, 10/100 Ethernet LAN Problem:...
2
by: Smriti Dev | last post by:
Hi, I am creating a form that allows users' to enter dates and times staff are available for work. They are 2-3 different types of staff. For example, permanent staff that work M-F 9-5 pm...
6
by: Salad | last post by:
Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just...
4
by: jonceramic | last post by:
Hi all, I have a situation I can't find any old messages or web-help on. I have a split database with a bizarre quirk. When I open up the front-end file, the main form opens up fairly quickly...
6
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
13
by: eighthman11 | last post by:
using Access 2003 and sql server version 8.0 Hey everyone. Created a text box where the user types in an Inventory number and it takes them to that inventory number on the contimuous form. The...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.