473,320 Members | 1,930 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,320 software developers and data experts.

slow to open forms

This is my first posting so please be gentle

I've been writing access programs for only about a year and may have
bit off more than I can chew but.......

I've written an operations program for work that encompasses simple
workorder entry, purchase orders, vendors and customer lists. My data
is kept in a database on our network and the programs are linked and
sitting seperatly on each workers desktop (about 6 people). When I was
developing the program the different forms would open rather quickly
(even with the database holding the raw data sitting on the network
server in it's current position and the program was sitting on my
desktop) I copied the program into the file on the server to
distribute it to the other workstations. Now the forms are loading
real slow (as much a 2-5 minutes), even the main program that I'm
working on from my desktop. I've broken the main program up into
smaller ones for purchasing and vendor maintanence and such and placed
a main menu offering the different forms at the startup. If you open
one of the smaller programs before the larger Job Specs form, they
open faster (but still very slow) and then the larger program will
open a bit faster. Once you open it the first time, you can close it
down and reopen fairly quickly.

Unfortunately my background is more in the application programming end
and not in the network / server / application arena. The program
itself works great and the people I work with are anxious to use it
but this is a major pain.

I'm sure I haven't begun to give enough information to help you figure
this out (and even if I did, I can only hope you will use simple
enough language that I can figure out how to apply any solutions you
come up with). What else can I fill you in on that might help you help
me.

Rocky
Nov 12 '05 #1
2 2793
Rocky A wrote:
This is my first posting so please be gentle

I've been writing access programs for only about a year and may have
bit off more than I can chew but.......

I've written an operations program for work that encompasses simple
workorder entry, purchase orders, vendors and customer lists. My data
is kept in a database on our network and the programs are linked and
sitting seperatly on each workers desktop (about 6 people). When I was
developing the program the different forms would open rather quickly
(even with the database holding the raw data sitting on the network
server in it's current position and the program was sitting on my
desktop) I copied the program into the file on the server to
distribute it to the other workstations. Now the forms are loading
real slow (as much a 2-5 minutes), even the main program that I'm
working on from my desktop. I've broken the main program up into
smaller ones for purchasing and vendor maintanence and such and placed
a main menu offering the different forms at the startup. If you open
one of the smaller programs before the larger Job Specs form, they
open faster (but still very slow) and then the larger program will
open a bit faster. Once you open it the first time, you can close it
down and reopen fairly quickly.

Unfortunately my background is more in the application programming end
and not in the network / server / application arena. The program
itself works great and the people I work with are anxious to use it
but this is a major pain.

I'm sure I haven't begun to give enough information to help you figure
this out (and even if I did, I can only hope you will use simple
enough language that I can figure out how to apply any solutions you
come up with). What else can I fill you in on that might help you help
me.

Rocky


Is your db properly split ie.e front/end on the workstations and back-end on
the server? If so have you compacted the back-end? You could try
decompiling as well.

It would be smart to check out http://www.granite.ab.ca/access/tipsindex.htm
as well and run through the excellent advice there.
Nov 12 '05 #2
"Deano" <de*********@hotmail.com> wrote in message news:<Su*********************@wards.force9.net>...
Rocky A wrote:
This is my first posting so please be gentle

I've been writing access programs for only about a year and may have
bit off more than I can chew but.......

I've written an operations program for work that encompasses simple
workorder entry, purchase orders, vendors and customer lists. My data
is kept in a database on our network and the programs are linked and
sitting seperatly on each workers desktop (about 6 people). When I was
developing the program the different forms would open rather quickly
(even with the database holding the raw data sitting on the network
server in it's current position and the program was sitting on my
desktop) I copied the program into the file on the server to
distribute it to the other workstations. Now the forms are loading
real slow (as much a 2-5 minutes), even the main program that I'm
working on from my desktop. I've broken the main program up into
smaller ones for purchasing and vendor maintanence and such and placed
a main menu offering the different forms at the startup. If you open
one of the smaller programs before the larger Job Specs form, they
open faster (but still very slow) and then the larger program will
open a bit faster. Once you open it the first time, you can close it
down and reopen fairly quickly.

Unfortunately my background is more in the application programming end
and not in the network / server / application arena. The program
itself works great and the people I work with are anxious to use it
but this is a major pain.

I'm sure I haven't begun to give enough information to help you figure
this out (and even if I did, I can only hope you will use simple
enough language that I can figure out how to apply any solutions you
come up with). What else can I fill you in on that might help you help
me.

Rocky


Is your db properly split ie.e front/end on the workstations and back-end on
the server? If so have you compacted the back-end? You could try
decompiling as well.

It would be smart to check out http://www.granite.ab.ca/access/tipsindex.htm
as well and run through the excellent advice there.


Thanx Deano for your help.

I went to the article you recommended and as they recommended placed
my back end database into a shared file instead of where it was and
the program is opening on the client computers much faster. I'll be
watching as everybody starts opening them up and using them to see if
they start to slow down WHILE their being used (we've only had a
problem with slow opening, then they seemed to work fine), but for now
it seems to have helped.
Nov 12 '05 #3

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

Similar topics

12
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC...
2
by: Rocky A | last post by:
This is my first posting so please be gentle I've been writing access programs for only about a year and may have bit off more than I can chew but....... I've written an operations program for...
3
by: Bob C. | last post by:
When I migrated my tables to SQL Server I needed a way to overcome the slow performance of the Find method on my recordsets. Although this can be done by accessing the table directly using dao and...
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:...
3
by: Tim Marshall | last post by:
I'm having a vexing problem with using filecopy and compactdatabase on a Jet back end I'm sure I did not have with A97. It seems to me that A2003 is much slower in shutting down the back end ldb...
7
by: ddsvi78 | last post by:
I am a complete idiot when it comes to access. Now that said, I work for a computer security company and one of our customers came to us with an access problem. They had been running fine for a...
0
by: Andrew Dowding | last post by:
Hi Everybody, I have been looking at problems with my Windows Forms C# application and it's little Jet 4 (Access) database for the last few days. The Windows Forms app implements a facade and...
3
by: Shawn | last post by:
I am working on an app where the main page uses tabs and then within each tab there are radio buttons on the top to open MDI children forms. The issue is that these MDI Child forms open kind of...
3
jamjar
by: jamjar | last post by:
Hi, I recently set up a fairly simple database, though one table has dozens of text and date fields and 2000+ records. It resides on a file server at my company HQ. It is being used at another...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.