K
Khairun
Hi,
We have FoxBASE program that would still have helping to run the information
in our company as we bought the software in 1998 and we don’t have access to
it source programming either the programmer.
For the last 5 years we have been try to expand the information on the
database to full fill today information needs using Microsoft Access table.
We linked the DBF table in to the new environments on Ms Access XP (2002).
In averages we would have 3-5 user accessing the same DBF files and there
would 2 user would work from direct FoxBASE programs which is would really
fast upon the data entry or query and the rest would work using Microsoft
access program that we design specifically to covering and expand the up to
date information.
The only problem that we have now is the speed when Ms Access query is
trying to locate the records.
Let say, that we have two DBF tables linked in to the access environment, we
create query for customers that would contains 12000 records and also at the
same time we have orders tbales would also contain 20000 record as we kept
the ex-orders since years 2000 at the same DBF files.
We created a form to help user to do easy data entry, changes and
modification directly into the DBF on access form.
The problem is
When we develop this form and the machine that we are using is on the same
hub (20 feet’s for the cable length) the data query should take less than 5
second to preserve the data to the user while for several users that would
50feets away and passing for about 3 hubs the data query would takes 3 time
longer (15 seconds).
I know if we design fully on access tables it would help us to speed up the
process but we would need more time to redesign the whole process and
programming for the data migration. Right now the goal is to speed up the
data query for the DBF tables that linked on the Ms Access environments.
Thanks for your help!
We have FoxBASE program that would still have helping to run the information
in our company as we bought the software in 1998 and we don’t have access to
it source programming either the programmer.
For the last 5 years we have been try to expand the information on the
database to full fill today information needs using Microsoft Access table.
We linked the DBF table in to the new environments on Ms Access XP (2002).
In averages we would have 3-5 user accessing the same DBF files and there
would 2 user would work from direct FoxBASE programs which is would really
fast upon the data entry or query and the rest would work using Microsoft
access program that we design specifically to covering and expand the up to
date information.
The only problem that we have now is the speed when Ms Access query is
trying to locate the records.
Let say, that we have two DBF tables linked in to the access environment, we
create query for customers that would contains 12000 records and also at the
same time we have orders tbales would also contain 20000 record as we kept
the ex-orders since years 2000 at the same DBF files.
We created a form to help user to do easy data entry, changes and
modification directly into the DBF on access form.
The problem is
When we develop this form and the machine that we are using is on the same
hub (20 feet’s for the cable length) the data query should take less than 5
second to preserve the data to the user while for several users that would
50feets away and passing for about 3 hubs the data query would takes 3 time
longer (15 seconds).
I know if we design fully on access tables it would help us to speed up the
process but we would need more time to redesign the whole process and
programming for the data migration. Right now the goal is to speed up the
data query for the DBF tables that linked on the Ms Access environments.
Thanks for your help!