Manage form yourself or use bound form

[suntisuk]

Hello expert, I'm using Access2002.

If I create a Project that link to MS SQL database,
create bound form and query. When Access need to retreive
data, its command is run on client. I know It's not
efficient and a lot of load on network will happen. If I
decide to use ADO to access data, I have to do a lot of
job to control record navigation and to create many basic
functions found on bound form. For example, sort, search,
filter,... Bound form is an easy and enough powerfull
tools (in my idea) to create an application. By weighing
between easy to create an application and accessing
performance, What is traditional method you use ? Or you
combine these 2 methods ?

TIA

 

[suntisuk]

Sorry, What I understand is incorrect.

I just got reply from some MVPs that with .ADP project,
query is executed on SQL Server site, not on client. So,
I can continue to use Access without worry about network
loading anymore.

Cheers...