Access 2000 Lunacy
-
I think I'm going mad. I created a db, made a form for the primary data entry functions, then tried to create a new recordset in a module associated with the form. The form is for entering a timestamp when a valid user checks in, and part of the challenge is to verify that the user has entered a valid name and password (from a separate table) before allowing the update to the primary table. After days of trying to make it work I finally got an intelligible error message informing me that the Database and Recordset types are not recognized. The code is essentially straight out of the online reference manual, to wit: Dim db As Database Set db = CurrentDb() Dim rst As Recordset Set rst = db.OpenRecordset.... Searching through Help for this problem leads me to the statement that the Data Access Objects are not installed; Add them to your Visual Basic Project References. This isn't a VB Project, just a simple Access 2000 application. There are no project references to set, and it's inconceivable that a database product would not install the type definitions required to work with databases! I've reinstalled Access 2000 three times so far, and applied SP3 to the installation. I haven't a clue what to try next. Any suggestions? "Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
-
I think I'm going mad. I created a db, made a form for the primary data entry functions, then tried to create a new recordset in a module associated with the form. The form is for entering a timestamp when a valid user checks in, and part of the challenge is to verify that the user has entered a valid name and password (from a separate table) before allowing the update to the primary table. After days of trying to make it work I finally got an intelligible error message informing me that the Database and Recordset types are not recognized. The code is essentially straight out of the online reference manual, to wit: Dim db As Database Set db = CurrentDb() Dim rst As Recordset Set rst = db.OpenRecordset.... Searching through Help for this problem leads me to the statement that the Data Access Objects are not installed; Add them to your Visual Basic Project References. This isn't a VB Project, just a simple Access 2000 application. There are no project references to set, and it's inconceivable that a database product would not install the type definitions required to work with databases! I've reinstalled Access 2000 three times so far, and applied SP3 to the installation. I haven't a clue what to try next. Any suggestions? "Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
If I recall correctly, you should still have a menu option for References under Tools in the VB editor that appears when you are editing your module. Go in there and make sure the reference to ActiveX Data Objects and DAO have not gotten unchecked somehow. Datagrid Girl
-
If I recall correctly, you should still have a menu option for References under Tools in the VB editor that appears when you are editing your module. Go in there and make sure the reference to ActiveX Data Objects and DAO have not gotten unchecked somehow. Datagrid Girl
Good call - they have been unchecked. Along with a few hundred others, and not a one of them has any descriptive information. Multiple versions of ActiveX, and DAO... What a farce. Thanks for the clue - I got the Database and Recordset objects initialized. Now I need to figure out what it's telling me with a popup that says "Too Few Arguments - 4 Expected" without in any way identifying where the error occurred. Another day of single-stepping is ahead, I suppose.... Thanks!:-D "Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.