Manage form yourself or use bound form ?

  • Thread starter Thread starter suntisuk
  • Start date Start date
S

suntisuk

Hello expert, I'm start 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
 
Access is made to use bound forms.
It's pretty efficient at it.
In fact, it's my understanding that with an ADP file, the queries will be
run on the server, not the client.

In general, I use bound forms unless there's a really good reason not to.

HTH
- Turtle
 
Back
Top