Access 2010 Runtime Error 7874
Contents |
Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 07-09-2012, 08:21
The Microsoft Access Database Engine Cannot Find The Input Table Or Query
AM #1 BLeslie88 B Leslie Join Date: May 2002 Location: Montreal, the microsoft access database engine cannot find the object Que, Canada Posts: 228 Thanks: 1 Thanked 0 Times in 0 Posts Run-time error '7874' Doing a loop to remove error import the microsoft jet database engine cannot find the input table or query table: Example: "CONTACTS1_ImportErrors" DoCmd.DeleteObject acTable, "CONTACTS" & myNum & "_ImportErrors" This has been working well - now today - suddenly there is no error with one table import... So I get title error message. "Run-time
Microsoft Access The Record Source Specified On This Form Does Not Exist
error '7874'" Is there anyway to bypass this exception when it occurs without removing the line of code? I did search forums - there was no obvious answer though similar errors. Thanks, Brian __________________ Brian K Leslie BLeslie88 View Public Profile Find More Posts by BLeslie88 07-09-2012, 08:26 AM #2 MikeLeBen Still struggling Join Date: Feb 2011 Location: Rome, Italy Posts: 186 Thanks: 5 Thanked
The Microsoft Jet Database Engine Could Not Find The Object
20 Times in 20 Posts Re: Run-time error '7874' Well yes, you could bypass it although I would look into the matter to fix your code so it's error free. Anyway, you'd use an error handler like this to bypass it: Code: '....code On Error GoTo errHandler '...more code Exit Sub errHandler: if err.number = 7874 then resume next Else msgbox Err.Number & " - " & err.description End if End Sub The Following User Says Thank You to MikeLeBen For This Useful Post: BLeslie88(07-09-2012) MikeLeBen View Public Profile Find More Posts by MikeLeBen 07-09-2012, 08:33 AM #3 vbaInet AWF VIP Join Date: Jan 2010 Location: U.K. Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: Run-time error '7874' There's really no point in deleting the table to be honest. Best delete the data instead. But it worries why you're needing to do this in the first place? What exactly is the error message? There are hundreds of error codes out there and we don't know it all. vbaInet View Public Profile Find More Posts by vbaInet 07-09-2012, 09:02 AM #4 BLeslie88 B Leslie Join Date: May 2002 Location: Montreal, Que, Canada Posts: 228 Than
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a the microsoft jet database engine cannot find the input table or query 'active users' Freelance Project Hire for a Full Time Job Ways to Get
The Microsoft Jet Database Engine Cannot Find The Object
Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website microsoft jet database engine error 2147467259 Testing Store Headlines Experts Exchange > Questions > How to resolve a Runtime Error '7874' Microsoft Access can't find the object 'tblBrEmailRout' and should I use a temporary table http://www.access-programmers.co.uk/forums/showthread.php?t=229522 ? Want to Advertise Here? Solved How to resolve a Runtime Error '7874' Microsoft Access can't find the object 'tblBrEmailRout' and should I use a temporary table ? Posted on 2005-08-19 MS SQL Server 2 Verified Solutions 2 Comments 1,697 Views Last Modified: 2010-05-18 I am using Access as the front end and SQL Server as the back end https://www.experts-exchange.com/questions/21533555/How-to-resolve-a-Runtime-Error-'7874'-Microsoft-Access-can't-find-the-object-'tblBrEmailRout'-and-should-I-use-a-temporary-table.html database for my application. I execute a stored procedure named procBrEmailRecon which creates a table. I then use DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" to send the table to Excel. I run my application and the table tblBrEmailROut is out there. I see it in Enterpise Manager. However, I get a message: Runtime Error '7874' Microsoft Access can't find the object 'tblBrEmailRout' Do you know why this error occurs despite the table being created and how I can resolve this error ? DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" <-------------highlighted line when error occurs Set com = New ADODB.Command With com .CommandType = adCmdStoredProc .CommandText = "dbo.procBrEmailRecon" .ActiveConnection = cn Set rstQueryFS = .Execute End With ExportedFile = "C:\UDL\DONTESCHEAT" & "_" & intYearSP & "_" & Format(Now, "mmddhhnnss") & ".XLS" DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" Beep MsgBox "Do Not Escheat reconciliation records have be
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive https://www.experts-exchange.com/questions/21533526/How-to-resolve-the-error-Runtime-Error-'7874'-Microsoft-Access-can't-find-the-object-'tblBrEmailRout'.html Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs http://www.office-forums.com/threads/runtime-error-7874.642467/ Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How to resolve the error Runtime Error '7874' Microsoft Access can't find the object database engine 'tblBrEmailRout' ? Want to Advertise Here? Solved How to resolve the error Runtime Error '7874' Microsoft Access can't find the object 'tblBrEmailRout' ? Posted on 2005-08-19 MS Access 1 Verified Solution 4 Comments 2,634 Views Last Modified: 2008-01-09 I am using Access as the front end and SQL Server as the back end database for not find the my application. I execute a storoed procedure named procBrEmailRecon which creates a table. I then use DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" to send the table to Excel. I run my application and the table tblBrEmailROut is out there. I see it in Enterpise Manager. However, I get a message: Runtime Error '7874' Microsoft Access can't find the object 'tblBrEmailRout' Do you know why this error occurs despite the table being created and how I can resolve this error ? DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" <-------------highlighted line when error occurs Set com = New ADODB.Command With com .CommandType = adCmdStoredProc .CommandText = "dbo.procBrEmailRecon" .ActiveConnection = cn Set rstQueryFS = .Execute End With ExportedFile = "C:\UDL\DONTESCHEAT" & "_" & intYearSP & "_" & Format(Now, "mmddhhnnss") & ".XLS" DoCmd.TransferSpreadsheet acExport, 8, "tblBrEmailROut", ExportedFile, True, "" B
works fine. SELECT cdd.[DeviceCode],cdd.[DeviceConfig] FROM cdd WHERE cdd." "[DeviceCode]='Module 01'; But from VBA, the following returns "runtime error '7874" Public Sub SeekCfg() Dim strSQL As String strSQL = "SELECT cdd.[DeviceCode],cdd.[DeviceConfig] FROM cdd WHERE cdd." & _ "[DeviceCode]='Module 01';" DoCmd.OpenQuery strSQL Could some please square me away Robert H, Mar 20, 2007 #1 Advertisements Douglas J. Steele Guest You can't use SQL with the OpenQuery method: it's looking for the name of a stored query. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Robert H" <> wrote in message news:... > In the query the following works fine. > SELECT cdd.[DeviceCode],cdd.[DeviceConfig] FROM cdd WHERE cdd." > "[DeviceCode]='Module 01'; > > But from VBA, the following returns "runtime error '7874" > > Public Sub SeekCfg() > > Dim strSQL As String > > strSQL = "SELECT cdd.[DeviceCode],cdd.[DeviceConfig] FROM cdd WHERE > cdd." & _ > "[DeviceCode]='Module 01';" > > DoCmd.OpenQuery strSQL > > Could some please square me away > Douglas J. Steele, Mar 20, 2007 #2 Advertisements Robert H Guest Ahh, thanks. The is there a way to run that SQL as a query from VBA? On Mar 20, 5:02 pm, "Douglas J. Steele"