• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Open a Recordset

If i want to open a recordset,  which way works better in terms of performance, maintenance, accuracy and ease of programming

method 1
1. use data control

method 2
1.  open the recordset manually;for example
Dim MyRS as recordset
set MyRS = mydb.openrecordset("Table1")

the recordset record will be updated by user operation.

Thanks

chee
0
chee68
Asked:
chee68
1 Solution
 
Edward98Commented:
Use method 2 it gives you more control when you use DAO.

0
 
alokanantCommented:
hi edward98,
just to know why, can u please give more details, of why this is so.

alok.
0
 
chee68Author Commented:
Yes, i would like to know the reason behind as well.
Thanks

chee

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
PfucciCommented:
you can buy commercial performance tools.  NuMega and Rational both make them, though rational's only works on NT.
0
 
bja1Commented:
Personal preference would be through code it gives you a lot more options to manipulate data at a later date ie: you can bind data better through the code, execute SQL code through the coed using MyBD.Execute Sql (Sql=string)  But If you are using say a dbgrid then through simplicity I would go for the data control as you can edit any cell within the grid with automatic updates. simplicity=Data Control, Better performance=DAO
0
 
chee68Author Commented:
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now