Home > Microsoft Access > Run-time Error 3078. The Microsoft Access Database Engine Cannot Find The Input Table Or Query'|'

Run-time Error 3078. The Microsoft Access Database Engine Cannot Find The Input Table Or Query'|'

Contents

Disk Cleanup will begin calculating how much occupied disk space you can reclaim. While holding CTRL-Shift on your keyboard, hit ENTER. Type "command" in the search box... Try Set MyQD = MyDB.CreateQueryDef("", "SELECT [Period] FROM tblJobsites WHERE [Period]='M';") or Set MyQD = MyDB.CreateQueryDef("TempQuery1", "SELECT [Period] FROM tblJobsites WHERE [Period]='M';") Remember this will add a new query under the his comment is here

Tell me how you make out ... –CRAFTY DBA Feb 28 '14 at 15:30 Unfortunately, I don't have access to SSMS. Query input must contain at least one table or query. Yes, my password is: Forgot your password? In the Registry Editor, select the Error 3078-related key (eg. recommended you read

Run-time Error 3078. The Microsoft Access Database Engine Cannot Find The Input Table Or Query'|'

Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud User Name Remember Me? The Microsoft Jt database engine can not find tblJobSites, error #3078. Set MyRecSet = .OpenRecordset() What have I done wrong here? (frmProgrammerOnly, Command1 button click, deadpest.mdb) -- regards, Bradley A Christian Response http://www.pastornet.net.au/response Nov 13 '05 #3 P: n/a Douglas J.

To run System File Checker (Windows XP, Vista, 7, 8, and 10): Click the Start button. scotty718, Jul 26, 2011 #9 scotty718 Thread Starter Joined: Nov 19, 2010 Messages: 185 Issue solved. Re-Update: Nevermind. Notice if I slightly change the SQL assignment to this...

If the table is linked, then you can but it has to be linked properly to work. __________________ Free tools, code and samples here: To view links or images in signatures If my assessment of what you are saying is wrong, I am more than happy to be enlightened by your idea. Windows XPhttp://www.theeldergeek.com/windows_xp_registry.htm Windows 7http://www.theeldergeek.com/windows_7/registry_edits_for_win7.htm Windows Vistahttp://support.microsoft.com/kb/2688326 - LetMeFixItMyselfAlways Step 2: Conduct a Full Malware Scan of Your PC There is a chance that your 3078 error could be related to a https://support.microsoft.com/en-us/kb/287696 Set MyRecSet = .OpenRecordset() MyRecSet.MoveFirst End With Debug reports the problematic line ...

Click on the Microsoft Access-associated entry. He omitted the second argument in the function, Domain, which tells Access which table or query to look at! Browse other questions tagged sql-server-2008 vba access-vba or ask your own question. Then I opened db1 and ran this code again...

The Microsoft Jet Database Engine Cannot Find The Input Table Or Query

Tried using the above as the SQL string in my VBA, and ran into the same issue as above. http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-access/3078-the-microsoft-office-access-database-engine-cannot-find-the-input-table-or-query/ Advertisements do not imply our endorsement of that product or service. 419,086 Members | 2,202 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members Run-time Error 3078. The Microsoft Access Database Engine Cannot Find The Input Table Or Query'|' The three things I need to confirm are the fields in my form called [BU_Selected_Add], [Qtr_Add] and [Year_Add] in the SQL table "tTbl_ADMIN_RxREBATE" within thier respective fields: [GL_BU], [Year], and [Quarter]. The Microsoft Access Database Engine Cannot Find The Object Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More...

If you're justgoing to loop through the records, try using a recordset instead. http://goglospex.com/microsoft-access/access-database-manager.html Tip: If you are positive that your 3078 error is related to a specific Microsoft Corporation program, uninstalling and reinstalling your Error 3078-related program will likely be the solution to your Are you looking for the solution to your computer problem? table or Query does not Exist Kira Macros 4 07-15-2008 09:33 AM runtime error '3078' sbooth Forms 3 03-30-2008 11:06 AM Catch Error 3078 and use custom message rainman89 Forms 9 Vba Run Time Error 3078

Join them; it only takes a minute: Sign up Error 3078 “cannot find table” using DLookup() in MS Access up vote 0 down vote favorite Within my Access 2010 form I Generated Tue, 20 Dec 2016 13:57:05 GMT by s_hp94 (squid/3.5.20) Developer Network Developer Network Developer :CreateViewProfileText: Sign in MSDN subscriptions Get tools Downloads Visual Studio Subscription access SDKs Trial software Free E.g. http://goglospex.com/microsoft-access/microsoft-access-query-run-time.html Forgot your password?

Also, the other queries I run from different databases (all in the loop) all work fine as well. How can the Set MyQD line fail??? Didn't let anyone know you were trying to connect with a database that was NOT the one you had the code in.

The system returned: (22) Invalid argument The remote host or network may be down.

Also what are you trying to do with the newly created query? Cut and paste the query into SSMS. Join over 733,556 other people just like you! 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.

more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation DriverDoc's proprietary One-Click Update™ technology not only ensures that you have correct driver versions for your hardware, but it also creates a backup of your current drivers before making any changes. All rights reserved. check over here You currently have 0 posts.

Theorems demoted back to conjectures What type of bike I should buy if I need to ride with a toddler What would an optimal robot look like intended to replace military Yes, it has 604 records in it. Recommendation: Scan your PC for computer errors. why not?

+ Ask a Question Need help?

Similar Threads - Solved Access 2007 Solved Sending Email from Access 2007 thru Outlook 2007 nylex40, Dec 6, 2016, in forum: Business Applications Replies: 7 Views: 189 draceplace Dec 8, 2016 Same err rtnd either way. If it does, then at least you know where to look. Please try the request again.

Type "update" into the search box and hit ENTER. I woould start commenting out code in your preceding routine, or short-circuit the logic and bypass some code, until the error goes away. Even when I reboot the PC, launch Access 97, open the database and run the code for the first time in the new instance of Access. Make sure it exists and that its name is spelled correctly.

However, if I run the sub separately, it works perfectly. While holding CTRL-Shift on your keyboard, hit ENTER. Good point - __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater. Other programs that you frequently use such Microsoft Office, Firefox, Chrome, Live Messenger, and hundreds of other programs are not cleaned up with Disk Cleanup (including some Microsoft Corporation programs).

MyRecSet.MoveFirst End With Runtime error 3067... Click here to join today! In fact, one misplaced comma can prevent your PC from booting entirely! Code: set Externaldb = opendatabase(strExternalDBPath) set rst = Externaldb.openrecordset(strSQL) I might also try opening the recordsets with ADO as another alternative.

Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find So, while you talked about linking of tables, it was not clear exactly what you were doing and the code you talked about would have been good to provide. 2.