 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / June 200597 to 2000 format
I moved all tables/queries/macros/forms from Access97 to Access2000, when I ran the compact repair tool, it gave me a compile error in the line DIM dbs as database What should I do? > I moved all tables/queries/macros/forms from Access97 to Access2000, > when I ran the compact repair tool, it gave me a compile error in the [quoted text clipped - 3 lines] > > What should I do? Add a reference to the DAO 3.6 library. Access 97 has a reference ot DAO by default whereas Access 200 does not. If you had simply used Access 2000 to convert the file this would have been done for you.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com another error Set rst = dbs.OpenRecordset(strSQL) > > I moved all tables/queries/macros/forms from Access97 to Access2000, > > when I ran the compact repair tool, it gave me a compile error in the [quoted text clipped - 7 lines] > default whereas Access 200 does not. If you had simply used Access 2000 to > convert the file this would have been done for you. > another error > > Set rst = dbs.OpenRecordset(strSQL) Both DAO and ADO have a Recordset object so I should have mentioned that in addition to adding the reference for DAO you need to remove the one for ADO. Otherwise you have to disambiguate all objects that exist in both libraries. Instead of... Dim rst as Recordset ...use... Dim rst as DAO.Recordset. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanks Rick > > another error > > [quoted text clipped - 10 lines] > > Dim rst as DAO.Recordset. I am having a similar problem. How would I add a reference to DAO 3.6 library? > > I moved all tables/queries/macros/forms from Access97 to Access2000, > > when I ran the compact repair tool, it gave me a compile error in the [quoted text clipped - 7 lines] > default whereas Access 200 does not. If you had simply used Access 2000 to > convert the file this would have been done for you. With any code module open, select Tools | References from the menu bar, scroll through the list of available references until you find the one for Microsoft DAO 3.6 Object Library, and select it. If you're not going to be using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.1 Library SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >I am having a similar problem. How would I add a reference to DAO 3.6 >library? [quoted text clipped - 12 lines] >> to >> convert the file this would have been done for you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.