Dim As Database

[momoko]

Hi,

In Access 97, I'm able to use Database but Access 2000 is giving me problem. Please advise.

Dim MyDB As Database, MySet As Recordset
Set MyDB = DBEngine.Workspaces(0).Databases(0)
Set MySet = MyDB.OpenRecordset("Sorts", DB_OPEN_DYNASET) ' Create dynaset.

Regards,

 

[WayneRyan]

Mo,

Get your code in design view and specify DAO.Database & DAO.Recordset.
Then go to Tools --> References, select MicroSoft DAO & promote it higher
than the ADO Reference. Use the Search Facility Here - "References".

Wayne