"As Database"

[JimCowan]

Using ACCESS and VBA in Office 2000, I get an error message which says "As Database" does not exist as a type. Yet most of the sample code uses it in '97 and '95; ie. "Dim dbs As Database".
Is there something new in '00, or am I missing something in the Module or elsewhere?

 

[Databaseguy]

New object model:

Used to be

Dim dbs as Database
Set dbs = currentDb()

Is

Dimm cnn as ADODB.Connection
Set cnn = CurrentProject.Connection

I'll be posting a FAQ that outlines 97 vs 2000 later this week