DBF linked on ACCESS Query

Q

Q

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 tables 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!
 
J

Jim

You can sometimes get better response time if you run the query in parts so
that the selected records you want to report on are filtered and read into a
temporary table first. Then run the report against the temp table.
Another thought for a long term solution is to convert to a SQL database and
link to it using ODBC.

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 tables 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top