I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
I want to improve speed.
So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. I also clear them on exit. Both of these improved speed. The most common form uses about 30 fields and the other form uses about 30. Some fields overlap.
As a separate issue, but which I think is related:
Lets say there are 5 clients and each client has 6 fields that are associated with it. Every line of the database therefore has 30 fields that are associated with the 5 clients. Not every line will have all client fields filled out, actually on a form, there is a program that I wrote that determines which clients will be used for each line. The problem arises when I want to create a report by clients. So far, I have one query that selects a line if any one of the clients has one field filled out(the field is the first in the sequence of the 6). Then I create separate reports that filter for each client, then I create one report with all the subreports because otherwise, I would have to include a report with 30 variables.
Is this the most efficient way, if not, will breaking up the tables help this situation. Thanks
2 2258
Does anyone have any advice?
I have a table with about 80 fields and 400 lines. I separated the tables into a database that sits on a server and all people have a copy of the access program with forms, tables, and reports on their desktop. The remote access connects to the server, it's pretty simple.
I want to improve speed.
So far, I have included onload events in a form that define the record source and set for the main source and combo boxes. I also clear them on exit. Both of these improved speed. The most common form uses about 30 fields and the other form uses about 30. Some fields overlap.
As a separate issue, but which I think is related:
Lets say there are 5 clients and each client has 6 fields that are associated with it. Every line of the database therefore has 30 fields that are associated with the 5 clients. Not every line will have all client fields filled out, actually on a form, there is a program that I wrote that determines which clients will be used for each line. The problem arises when I want to create a report by clients. So far, I have one query that selects a line if any one of the clients has one field filled out(the field is the first in the sequence of the 6). Then I create separate reports that filter for each client, then I create one report with all the subreports because otherwise, I would have to include a report with 30 variables.
Is this the most efficient way, if not, will breaking up the tables help this situation. Thanks
Have a look at the following tutorial. Database Normalisation and Table structures
Remeber you can break up tables in a one to one relationship.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Anshul Seth |
last post by:
I have been dealing with the page-break problem for long, and have not
been able to come to a solution.
I am using XSL:FO to generate PDF report for my XML, generating it in
tables.
I want that...
|
by: Rary |
last post by:
I am using XSL:FO to generate PDF report for my XML, generating it in
tables, i want that tables should completely be at one place, if there
is a page break , all the contents of the table should...
|
by: Michael A. Drawbaugh |
last post by:
We have several webforms that represent Online Reports. When printed, we
would like to be able to control the pagination based upon a line count. We
have been trying to use the PAGE-BREAK-AFTER...
|
by: mark |
last post by:
im trying to split prints out by using
<STYLE>P { PAGE-BREAK-AFTER: always }</STYLE>
in the <HEAD> </HEAD> section
however its not page breaking like i would like - i want it to page break...
|
by: Abraham Luna |
last post by:
how do i stop the dynamic validators from breaking explorer
if i use a dynamic validator and move to a different control it breaks
explorer and i can type in the page when i'm not supposed to....
|
by: CJM |
last post by:
What is the best way to force a page break when printing from a browser?
A page in my application generates a series of tables which are usually less
than will fit on a page of A4. Ideally I want...
|
by: matt |
last post by:
hello,
ive been trying to figure something out, largely thru trial & error.
thought perhaps someone else may have knowledge.
i have an html table that consists of blocks of related data --...
|
by: =?Utf-8?B?U3VyeWEgUHJhYmhh?= |
last post by:
I am using <div style =page-break-before:always</divfor page break while
printing a layout designed using <table>, <tr>, <td>. It is working fine in
IE 6.0. But this is not working properly in...
|
by: =?Utf-8?B?aXdlYg==?= |
last post by:
Can we set page breaks in ASP Pages dynamically based on the data being
populated?
Akshay.
|
by: krokador |
last post by:
I've been looking over the net and there doesn't seem to be any other people around who's had that problem (or my googling skills are off this morning) so here I am asking this question:
I have an...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |