database variables problem

[Sunnyrain]

When I tried to declare object variables below in Access, the compiler
couldn't find its type. It showed me a compile error: user-defined
type not defined.

Sub aTest()
' Declare variables.
Dim dbs As Database
End Sub

I think perhaps I lost a DLL file or the compile couldn't find the
location of the file. But I don't know how to fix it. The Access
version is 2000.

Thank you in advance.

[Tom van Stiphout]

On 8 Dec 2005 17:44:19 -0800, "Sunnyrain" <so******@hotmail.com>
wrote:

Try this:
Code window > Tools > References
Check Microsoft DAO 3.6

-Tom.

When I tried to declare object variables below in Access, the compiler
couldn't find its type. It showed me a compile error: user-defined
type not defined.

Sub aTest()
' Declare variables.
Dim dbs As Database
End Sub

I think perhaps I lost a DLL file or the compile couldn't find the
location of the file. But I don't know how to fix it. The Access
version is 2000.

Thank you in advance.

[Sunnyrain]

Thank you Tom. It's working now after I selected DAO 3.6 in that
opition.