OpenDatabase(something)/open recordset and Data1.DatabaseName 1

[lesina]

Hi guys,

i have this question i would like to know.Maybe it's a stupid question, but still, can anyone help me on this?
When should i open a database like:

(
dim dbclients as databasename
dim rsclients as recordset
)

set dbclients =open databasename(App.path &"something.mdb&quot
set rsclients=open recordset("one_recordset&quot



and when should i use a data control and do something like:

data1.databasename =App.path & "something.mdb"
data1.recordset="select * from clients "

....
what's the difference?

thanks in advance,

===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
CPC_TA- Braga
-------------------
Portugal
===================

 

[polash]

Without using Data control you should use the First way. The first onr is faster than Data Control. So when you handle large database the first one is much more preferable.

Thank You

 

[lesina]

Hi polash,

thanks a lot for your answer and sharing your knowledge with me.

my start to you, you've been helpfull


Good work, see you next time

===================
* Marta Oliveira *
===================
marta100@aeiou.pt
-------------------
CPC_TA- Braga
-------------------
Portugal
===================