Dim as Database in A2K 1

[LarryDeLaruelle]

Is there an A2K version of Dim dbTemp as Database?

I'm just converting myself (reluctantly) to A2K and bumped into this. I know that if I set the DAO 3.5 Object reference I can use the DAO.Database.

Just wondering if there is a comparable A2K version without using the DAO reference.

Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[dynamictiger]

A2K requires you to set the reference DAO 3.6.

 

[cmmrfrds]

Microsoft recommends using ADO for data objects instead of DAO. You can still continue to use DAO if you want, but Microsoft's effort is going into expanding ADO.

Here are a couple of reference libraries.
ADOX
'- Microsoft ADO Ext. 2.6 for DDL and Security
ADODB
'-- Microsoft ActiveX data objects 2.6 library

ADOX is used to maintain tables and security. For instance, if you want to add user permissions to a table or create a new table. ADO handles the recordset objects and connections.

examples
Dim rst as ADODB.Recordset
Dim cn as ADODB.Connection
Dim cg as ADOX.Catalog

 

[LarryDeLaruelle]

cmmrfrds:

Sounds like what I was looking for. Thanks.

Given this, is it no longer necessary to set the currentdb when using recordsets? Just dim the recordset suing the ADODB?

Thanks again. Larry De Laruelle
ldelaruelle@familychildrenscenter.org