Microsoft Jet Database Engine Error 3078 Fix
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 14:18:07 GMT by s_wx1085 (squid/3.5.20)
Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search
Microsoft Access The Record Source Specified On This Form Does Not Exist
Advanced Search Find All Thanked Posts Go to Page...
The Microsoft Jet Database Engine Cannot Find The Object
Thread Tools Rating: Display Modes 06-05-2011, 10:56 AM #1 Inspired Newly Registered User Join Date: Jan the microsoft jet database engine cannot find the input table or query 'active users' 2011 Posts: 23 Thanks: 0 Thanked 0 Times in 0 Posts Run-time error '3078': can’t find table when it does exist! "Run-time error '3078': The Microsoft Jet database engine can't http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/how-to-repair-an-error-of-the-microsoft-jet/8c5f410d-6ff9-495c-bb7d-7cca81f0b890 find the input table or query TableName" After linking to a table in an external db, I am attempting to open a recordset using the simple code shown below: Code: Set rst = currentdb.openrecordset("SELECT * FROM TableName") When executing this statement I get the error message as shown above, even though the table DOES exist. I simply press F5 etc http://www.access-programmers.co.uk/forums/showthread.php?t=210829 and then the code continues running, bizarrely! The module (subroutine) where this problem occurs is part of a larger process (several subroutines), and when ran as part of this larger process, the error occurs. However, if I run the sub separately, it works perfectly. In the preceding sub, the table in question is being linked to, updated and then the link is being deleted as my code moves on to the next table. The problem must be caused by something in this preceding subroutine but I just can't figure out what, as all this preceding sub is doing is linking to tables, updating them and deleting the links. Any ideas? This is slightly similar to my last query in that I'm encountering some weird and inexplicable issues, which is rather irritating to say the least! Inspired View Public Profile Find More Posts by Inspired 06-05-2011, 11:45 AM #2 spikepl Eledittingent Beliped Join Date: Nov 2010 Location: San Serriffe Posts: 6,143 Thanks: 77 Thanked 976 Times in 955 Posts Re: Run-time
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://stackoverflow.com/questions/3114967/vb6-what-is-the-likely-cause-of-error-3078-jet-database-engine-cannot-fin Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up VB6: what is the likely cause of Error 3078 “ … Jet database engine cannot find the input table or query … database engine ” up vote 1 down vote favorite VB6: what is the likely cause of Error 3078 " ... Jet database engine cannot find the input table or query ... " vb6 jet share|improve this question asked Jun 25 '10 at 1:18 CJ7 4,99232114220 Do you ever create queries as strings, so that you might encounter accidental SQL-injection type errors? Where the data contains ' or " characters which cause the Jet engine not find the to misinterpret your SQL? –MarkJ Jun 25 '10 at 10:40 Is the database on the local machine or server based? All machines or just one? Trying to rule out network card/traffic/connectivity as an issue. I've seen that happen at times. –jasonk Jun 25 '10 at 13:00 It is server based. And in this case it is being accessed from a Virtual Machine on the same machine as the database. –CJ7 Jun 26 '10 at 3:10 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Try checking the connection and checking the database for corruption, that is, back up and then compact and repair. You might also like to read this article on corruption share|improve this answer answered Jun 25 '10 at 7:01 Fionnuala 77.2k665110 add a comment| up vote 2 down vote A typo in the table name. share|improve this answer answered Jun 25 '10 at 1:26 SLaks 541k9513471516 or someone was in your jet, eating your lap-tables –user166390 Jun 25 '10 at 3:01 problem is intermittent - not consistent with a typo in any SQL. –CJ7 Jun 25 '10 at 4:18 I've seen this in programs that cobble SQL together on the fly in several parts of the program. Some code paths will resu