Variable Type "Database"

[dbrooks]

I would like to do a recordset, however everytime I use the variable database it says user defined type. I am using this within a form, do I have to create a module to use this within Access 2000? The following code is how I have it set up....

Dim objDB as Database
Dim objRS as Recordset
Set objDB=CurrentDb()
.
.
.


I appreciate any help you can give me! Thanks

 

[Mile-O]

It looks like you might have to set your DAO library.

Open a module and goto Tools -> References

Ensure that the DAO library is above the ADO library and then

Dim objDB as DAO.Database
Dim objRS as DAO.Recordset
Set objDB = CurrentDB

 

[dbrooks]

I want to make sure that I add the correct DAO object because I have 3 choices. Also this database will be used by 5-10 people using Windows 95 and Windows 2000. Can you tell me if after adding a reference they will not have problems?

Thanks -db

 

[WayneRyan]

db,

Try this thread:

http://www.access-programmers.co.uk/forums/showthread.php?threadid=41905

References are a common problem with Access.

Wayne

btw,

How's Bangor (I used to live there ...)?