Inspired View Public Profile Find More Posts by Inspired 06-07-2011, 07:23 AM #11 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts: John Warner Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... We do not claim any responsibility for the results of the actions taken from the content linked below - complete these tasks at your own risk. To reiterate: the query runs fine when I open the other database and execute it. have a peek at this web-site
And things should be okay. Set MyRecSet = .OpenRecordset() MyRecSet.MoveFirst End With Debug reports the problematic line ... Set MyRecSet = .OpenRecordset Did you bother to check the Access help? Private Sub Command1_Click() Dim MyWS As Workspace Set MyWS = DBEngine.Workspaces(0) Dim MyDB As Database Dim MyQD As QueryDef, MyRecSet As Recordset Dim MyPeriod As String, MyRand As Double Set MyDB http://www.access-programmers.co.uk/forums/showthread.php?t=210829
Debug reports this as the problematic line... Use Registry Editor at your own risk. To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to Error 3078 (eg.
To use System Restore (Windows XP, Vista, 7, 8, and 10): Click the Start button. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... How to run Disk Cleanup (cleanmgr) (Windows XP, Vista, 7, 8, and 10): Click the Start button. Error 3078 Rdp scotty718, Jul 25, 2011 #5 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 Getting the VBA Syntax correct with SQL is pretty hard.
I think the problem lies in the fact that VBA is using the Jet database engine to parse the query. Run Time Error 3078 Access Similar topics microsoft jet database engine cannot open the file MS Jet database engine cannot find the input table or query DLookup "engine cannot find a record" when new record created. The access Gods are apparently teaching me a lesson the hard way with this project @Rockn - of course, I am stepping through code, that is how I found the error. https://social.msdn.microsoft.com/Forums/en-US/38cbd795-ef8b-40ac-bf9e-3dec969323f7/runtime-error-3078-the-microsoft-access-database-engine-cannot-find-the-input-table-or-query?forum=isvvba Installing the wrong driver, or simply an incompatible version of the right driver, can make your problems even worse.
Nov 13 '05 #7 P: n/a MLH Notice if I slightly change the SQL assignment to this... Run-time Error 3078. The Microsoft Access Database Engine Cannot Find The Input Table Or Query'|' As a Gold Certified Independent Software Vendor (ISV), Solvusoft is able to provide the highest level of customer satisfaction through delivering top-level software and service solutions, which have been subject to strSQL = "SELECT * FROM [strQueryName]" & ";" Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... System Restore can return your PC's system files and programs back to a time when everything was working fine.
You can add a watch to the query line to see what is actually being sent to populate your recordset. internet Microsoft Access) under the Name column. Ms Access Error 3078 I am getting this error everytime I runt the code now. Runtime Error 3078 Ms Access MyRecSet.MoveFirst End With This time the error returned was different...
Click Control Panel. Make sure it exists and that its name is spelled correctly. Because of the time and complexity involved in updating drivers, we highly recommend using a driver update tool such as DriverDoc (Developed by Microsoft Gold Partner) to automate the process. Dim DateX As Date Dim Msg Sub test1() On Error GoTo ErrorHandler DateX = DMax("[Date]", "tblWellMaintenanceLogbook", "[Combo34] =" _ & Forms!frmWellMaintenance!Combo34) Msg = DateX ErrorHandlerExit: Exit Sub ErrorHandler: If Err.Number = Error 3078 The Microsoft Jet Database
I have a hunch this'll work. The Microsoft Jt database engine can not find tblJobSites, error #3078. Public Function MSPSTotal(pb As String) As Double Dim dbs As Database Dim qdf As QueryDef Dim rst As Recordset Set dbs = CurrentDb Set qdf = dbs.CreateQueryDef("") qdf.SQL = "SELECT Sum(tbl_MSPB_Pos.quantity) Source table or Query does not Exist Kira Macros 4 07-15-2008 08:33 AM runtime error '3078' sbooth Forms 3 03-30-2008 10:06 AM Catch Error 3078 and use custom message rainman89 Forms 9
CLICK HERE to verify Solvusoft's Microsoft Gold Certified Status on Microsoft Pinpoint >> CLOSE Connect with us: TechRepublic Search GO CXO Cloud Big Data Security Innovation More Software Data Centers Networking The Microsoft Jet Database Engine Cannot Find The Input Table Or Query So eg. What you need to do is to CONCATENATE the name with the literal strings for the rest of the SQL statement: .
It keeps giving me runtime error 3078, saying that "The Microsoft Jet database engine cannot find the input table or query 'SELECT Hist2.DateM ... Note: I THINK I could be so wrong here. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Have you forgotten the ; character at the end of your SQL statement??? The Microsoft Access Database Engine Cannot Find The Object Any suggestions?
Sub GrabLeaseData() 'Clear the data Sheets("PDE").Range("D2:XFD1048576").Clear 'Create links to data sources Dim PWO As DAO.Database Set PWO = Workspaces(0).OpenDatabase("PrdAcct", dbDriverNoPrompt, True, "ODBC;DSN=PrdAcct;DATABASE=PrdAcct") Dim strSQL As String Dim LeaseID As String LeaseID I thought I needed to have a querydef for that in DAO. Stored Query pointing to correct table name (including spelling check). 3. Click Yes.
Michael S. Update: I think I've found the reason the error occurs, the query that is failing in VBA has a linked table in the structure of the underlying query that the make I found a dirty solution to get the appropriate date range I need, by changing the criteria in the underlying query from >DateAdd("m",-6,DMax("[Long Date (calc)]","tblArcherData")) to > Date () - 183 That's the only difference I see amongst the queries that do work and the one that doesn't.
Then I opened db1 and ran this code again... Runtime Errors Knowledgebase Article ID: 130545 Article Author: Jay Geater Last Updated: 18-07-2016 Popularity: star rating here Download NowError Fix Learn More Tweet Recommendation: Scan your PC for computer errors. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... strSQL = strSQL & "FROM [" & strQueryname & "];" .
Should be OilCount.OilCount –DickNixon Feb 28 '14 at 15:12 Go ahead and test it in SSMS. MyRecSet.MoveFirst End With This time the error returned was different... Umm, I think your problem was that you 1. Steele I hate to ask the obvious, but do you have a table named tblJobsites?
A black box will open with a blinking cursor. Change the statement to... . . Kevin Barnes replied Sep 18, 2008 I believe that your SQL statement is flawed. Operating System Information 3078 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
current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Stored Query pointing to correct table name (including spelling check). 3.
© Copyright 2017 downloadcallwave.com. All rights reserved.