i already set the form's property maxrecord property to 1
still it takes about 10 secs. i looked at the thread Thread702-206410 but i think the name auto correct option is only applicable to MDB and not in ADP(which im using). i can't find the options where to set the name autocorrect in ADP...
Hi,
Im using Access 2002 for front-end with SQL2000 back-end.
I have an "Orders" table with 60,000 records/orders and EACH order has 20 "item details" so for "order details" table I have 1,200,000 records in it.
Then I have an Order form, that is bounded to a query based on ORDERS table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.