Contact Us
Site Map

Search

• you are using named constants (e.g. adUseClient) but forgot to include ADOVBS.INC (see Article #2102 and Article #2112)
• you tried to use the NextRecordset() method to process multiple resultsets from an Access provider (see KB #202433)
• you tried to combine server-side recordset properties, e.g. cachesize, with a client-side (adUseClient) recordset - make sure the properties you are using make sense for the type of recordset you've opened
• you tried to use advanced methods or properties such as bookmark, MovePrevious, or AbsolutePage on default recordset objects - make sure you set the correct lockType and/or cursorLocation (depending on what you are doing, see Article #2120, Article #2193 or Article #2243)
• you tried to retrieve the primary key using ADOX (see KB #294157)
• you are trying to use an ADODB.Recordset object with an improper lock type to handle an update or addnew - use an UPDATE or INSERT statement instead of a Recordset object (see Article #2191 and KB #255707).
• you are using an ADOX.Catalog object (or one of several other potential objects), and tried to close it. All you have to do is set a catalog object to nothing... it does not have a close() method.