Optimizing Access queries

[sasasasa]

Hi,
I have a very large table in access database. I have to usea normal select statement to access every record (SELECT * FROM Mytable). The speed of loading the form in the application is very slow. Can you help me by telling me how to increase the speed. It is taking very long time.
Sa

[jimatqsi]

You haven't given us much to go on, so we can only speak in general terms.

Do you really need all the columns in the table? Select * can be expensive if there are a lot of columns and a lot of rows. Try limiting your select to only the columns you need.

What is the purpose of the form? How many people use it at once? Try launching the form with a filter that limits the recordset to only 1 record, and then after the user selects a given customer/order/dept/ or whatever it is, automatically filter your recordset to match only the selection made by the user.

Jim