08-04-2004, 08:46 AM #6 Maritza Information ***** Join Date: Nov 2002 Location: Virginia Posts: 54 Thanks: SQL3 = "SELECT Notice_Tracking.Loan, Notice_Tracking.Branch, Notice_Tracking.[Last_notice_sent_for_(days)], Notice_Tracking.Date_Last_Notice " & _ "FROM Notice_Tracking " & _ "WHERE (((Notice_Tracking.Loan)='" & MyLoan & "'));" Set RS3 = DB.OpenRecordset(SQL3) 'Record exists in Notice_Tracking, so update Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

Reply With Quote Nov 14th, 2013,01:08 PM #9 The_Kurgan Board Regular Join Date Jan 2006 Location Dallas, TX Posts 225 Re: Run time error 7867: database already open It's a bit I was attempting to launch an Access >> > Macro from Excel [Office 2003]. >> >> > I observed an error462every ODD launch of my code; it ran >> > successfully How to Completely Erase Superelevation? Please ( LoginorRegister )

Custom Search UtterAccess Forums>Microsoft® Access>Access Modules Option Compare Database + Opencurrentdatabase = You Already Have The Database Openerror 7867, Access 2010 Forum HomeSearchHelpUA Messages|-- UtterAccess.com

The second time I run the code it works > > > fine. So, it is difficult for me to understand when I am making a mistake. Error 53 when trying to open Access database (sometimes) 3. Ath that point I close the only other instance in task manager.Sub is called using:CODEPrivate Sub Command2_Click() CopyReferences ("D:\Desktop\db\APCDB.accdb")End Sub champagne_charlyView Member Profile Aug 9 2012, 10:05 AM Post#5Posts: 477Joined: 31-January

It doesn't even get that far. see here It is like the error > Message is actually performing some kind of operation that effects how > the code is run the second time around. > > Thanks again, > It is like the error >> Message is actually performing some kind of operation that effects how >> the code is run the second time around. >> >> Thanks again, >> Operating System Information 7867 error messages can occur in any of the following Microsoft Windows operating systems: Windows 10 Windows 8 Windows 7 Windows Vista Windows XP Windows ME Windows 2000

Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! File Extensions Device Drivers File Troubleshooting Directory File Analysis Tool Errors Troubleshooting Directory Malware Troubleshooting Windows 8 Troubleshooting Guide Windows 10 Troubleshooting Guide Multipurpose Internet Mail Extensions (MIME) Encyclopedia Windows Performance Where is the Update Cross Section Command? http://axisnice.com/access-error/access-error.php Maritza View Public Profile Find More Posts by Maritza « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes

Just click the sign up button to choose a username and then you can ask your own questions on the forum. Error 53 when trying to open Access database (sometimes) 4. Please Note: Using System Restore will not affect your documents, pictures, or other data.

It does sound like you are seeing different behavior than I did, and in fact I never knew what made the behavior I was seeing change.

Microsoft Access) you want to back up. View Horizontal Annotation: XML Report is Not Created When Using Tabling View Surface Elevations with Different Colors View Triangles Watershed Delineation What Does "-1" Indicate in XIN File? To resolve this problem: In the InRoads Explorer window, right-click on the geometry project name and select "Details". Click the Remove button on the right side.

Help Using VB4.0 - Trying to open database using Dynaset in Dim Statment 2. It takes just 2 minutes to sign up (and it's free!). I copied the code directly from your post and have the Option Compare Database directive in the module where the code resides. Get More Info You will be prompted with a permission dialog box.

Maintaining a driver backup provides you with the security of knowing that you can rollback any driver to a previous version if necessary.