Query, how make it more fast

[Guest]

Hi All.

I have a Data Base Located in the Network drive, It has been working fine
but we are having a problem, the Query is very slow to open, I put a
criteria in the Query filtering only Datas with -30 day, but it's still slow,
we have two company where both are conected to the Network drive,

the drive where is located the Data Base is S:drive and it is in the Other
company, we have in our company an Local Network drive named W: where the
operation is more fast, the question:

How could I have two Data Bases with the same Datas, For example if the Data
Entry Use the S:drive but I want to have the same datas in our local drive
(W, please help.

or if there is another way to have more fast my query access I will
appreciate so much.

Thanks

 

[Jeff Boyce]

Lorenzo

Is the slowness a change from how it used to work, or has it always been
slow for the one drive?

The speed of a query depends on many factors, including:
* the network speed
* the network card
* the server speed
* the server RAM
* whether an antivirus program runs on the LAN
* whether the data is indexed correctly

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,
what I want is if possible to create a Data Base replica in our local Drive,
and when we want access, we access to the W: (it's more fast),,could I do
that?

Thanks

--
Lorenzo Díaz
Cad Technician

Lorenzo

Is the slowness a change from how it used to work, or has it always been
slow for the one drive?

The speed of a query depends on many factors, including:
* the network speed
* the network card
* the server speed
* the server RAM
* whether an antivirus program runs on the LAN
* whether the data is indexed correctly

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Make sure that the Date field in question is indexed. Also index any other
fields that have criteria in your query. Sometimes indexing the fields sorted
can also help.

If the query is used in a report, do not sort on it. Do the sorting and
grouping in the report.

Posting the SQL might also help up to help you.