Manage form yourself or use bound form ?

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
 
M

MacDermott

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top