Sql server data read

  • Thread starter Thread starter Guoqi Zheng
  • Start date Start date
G

Guoqi Zheng

Dear Sir,

I have an Access project connected to a remote Ms Sql 2000 server. I have an
form inside Access which enable people to edit order information.

This is an online shop application, the records of order table keep
increasing. Each time, when I open the Access form to edit order
information, it take Access project application some time to get all the
order information into local disk. It seems that Access project get all the
order table information into local disk because it is always calculating
when I am opening the form.

Now, I am afraid that when I have 100000 records on that order table, it
will take Access project application a long time to get the data and open
the form.

Do I make myself clear here? Any suggestion for this problem or this is not
a problem???

Thanks in advanced.
 
Back
Top