 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / August 2005Cannot Set recordset in A2003
On one workstation, Access won't get past certain lines in an app, like Set dbs = CurrentDB Or If Me. RecordsetClone.Recordset = 0 then I just installed A2003 on my PC and have no problems. My Client's PC is ok also. The libraries are ok and I set Access on Sandbox mode (and off). Any ideas? Thanks and God Bless, Mark A. Sam You don't mention which libraries you have a reference to. You need DAO 3.6. It sounds like you may have a reference to ADO instead...or maybe neither. Press Ctrl-G, select Tools|References....make sure DAO 3.6 is checked and doesn't say MISSING.  SignaturePaul Overway Logico Solutions, LLC www.logico-solutions.com > On one workstation, Access won't get past certain lines in an app, like > [quoted text clipped - 15 lines] > > Mark A. Sam Hello Paul, The references are: Visual Basic for Applications Microsoft Access 11.0 Object Library Microsoft Office 11.0 Object Library Microsoft DAO 3.6 Library Microsoft ActiveX Data Objects 2.5 Library I turned off the ActiveX on the offending machine, but that didn't correct the problem. God Bless, Mark > You don't mention which libraries you have a reference to. You need DAO > 3.6. It sounds like you may have a reference to ADO instead...or maybe [quoted text clipped - 20 lines] > > > > Mark A. Sam Probably having a problem with ambiguity. 1. Try disambiguating the syntax by being Explicit: Dim rst As DAO.Recordset Dim db As DAO.Recordset 2. Make sure that the Microsoft ActiveX Data Objects 2.5 Library is positioned below the DAO library or that it is turned off. 3. Try saving, compiling, then saving again after turning it off. Build a new empty database with only the DAO reference, and importing everything afterwards. Then compile and save it. SignatureArvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access > Hello Paul, > [quoted text clipped - 37 lines] > > > > > > Mark A. Sam > Probably having a problem with ambiguity. Hello Arvin, > 1. Try disambiguating the syntax by being Explicit: > > Dim rst As DAO.Recordset > Dim db As DAO.Recordset I tried it. It didn't help > 2. Make sure that the Microsoft ActiveX Data Objects 2.5 Library is > positioned below the DAO library or that it is turned off. It is. I even tried turning off the ActiveX Objects > 3. Try saving, compiling, then saving again after turning it off. Build a > new empty database with only the DAO reference, and importing everything > afterwards. Then compile and save it. I'll try that. If it works, I'll give the user her own copy of the Front End. God Bless, Mark > Arvin Meyer, MCP, MVP > Microsoft Access [quoted text clipped - 45 lines] > > > > > > > > Mark A. Sam See http://support.microsoft.com/default.aspx?scid=kb;en-us;319841 Particulary cause 1. SignaturePaul Overway Logico Solutions, LLC www.logico-solutions.com >> Probably having a problem with ambiguity. > [quoted text clipped - 79 lines] >> > > > >> > > > Mark A. Sam Thank you Paul. It was Cause 1 and the user is a happy camper (which is important, becuase she writes my check) ;) God Bless, Mark > See http://support.microsoft.com/default.aspx?scid=kb;en-us;319841 > [quoted text clipped - 83 lines] > >> > > > > >> > > > Mark A. Sam |
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.