Home > Unspecified Error > Unspecified Error Connecting To An Access Database

Unspecified Error Connecting To An Access Database


Code: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim retVal As Boolean Dim strSQL As String retVal = False On Error GoTo CatchError Set cn = New ADODB.Connection With cn I have checked security permission on the application folder and on database also. The problem seems to happen more frequently at times the website is getting a lot of use though the times it breaks do not seem to necessarily be times of peak How to draw a clock-diagram? his comment is here

Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Posts: 16,832 Thanks: 79 Thanked 1,536 Times in 1,513 Posts Hi there, 80004005 are *(almost) always security errors; you can read ways to solve them here: http://imar.spaanjaars.com/263/how-d...0004005-errors Cheers, Imar __________________ Imar I thought it is a driver issue and installed Access 2007 Database engine in the user's PC and replaced Provider with "Microsoft.ACE.OLEDB.12.0" but it doesn't work. Every few days or so (or sometimes multiple times in a day), the site goes "down" in the sense that all pages that try to connect to the database return a

Unspecified Error While Connecting To Access Database

When the DLL is trying to open the connection to MS Access database, Msjet40.dll could have been ran out of memory. 'OutOfMemoryException' could have been the appropriate one. Is this one PC somehow specific? Did this post help you? Nothing else done, and the function works again.

  1. Before I leave my company, should I delete software I wrote during my free time?
  2. I get the following message: "Unspecified error".
  3. See Article #2154 and KB #315456 for more information.
  4. Why does Deep Space Nine spin?
  5. Two Perl scripts will load this same DLL and read same data.
  6. I have also Visual Studio 2005 installed on the same machine.
  7. Do not open or edit or move/replace the database file while your website is in use.Doing so can corrupt the server's temporary database files and cause this error.Be sure to never

Please help me resolve this. #2 (permalink) March 16th, 2014, 12:18 PM Imar Wrox Author Points: 70,508, Level: 100 Activity: 100% Join Date: Jun 2003 Location: Utrecht, Netherlands. The event viewer shows no problems -- you woudn't know the site is having any problems based on this. Why were Navajo code talkers used during WW2? Error 0x80004005 rarity?

visual-c++ oledb ms-jet-ace share|improve this question asked Oct 17 '13 at 18:19 InnovWelt 137217 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted I have Thank you visual-studio-2010 ms-access share|improve this question asked Dec 28 '10 at 14:10 Luiz 11 Migrate your Access database to SQL 2008 R2 Express if feasible. Reply qbernard 7037 Posts MVPModerator Re: Intermittent '80004005' unspecified error Sep 04, 2011 10:11 PM|qbernard|LINK Nice! I too need to connect to an Access database (tactical solution, migration not possible) and in VS2010 I get the "unspecified error".

So, It does not exceed the memory limit (2 GB) of Windows 32-bit process. Reply Lloydz 2318 Posts Re: Intermittent '80004005' unspecified error Aug 22, 2011 03:17 AM|Lloydz|LINK Hi, Please check the Access and Classic ASP part and follow the steps in the following blog Report abuse Reply 10 years ago by Rollershade Colin Harman MACITP West Sussex, England, Australia Joined 14 years ago do you dispose of the objects aswell as close them , also The problem really seems related to traffic -- nothing else seems to have changed -- which is why I am thinking that maybe JET is just not up to it.

Unspecified Error Connecting Ms Access Database\

I have gone through MS documentation saying that if a process creates more than 64 connections to the MS Access DB, this error can occur. Faulting application name: perl.exe, version:, time stamp: 0x4bed097d Faulting module name: msjet40.dll, version: 4.0.9756.0, time stamp: 0x49246e48 Exception code: 0xc0000005 Fault offset: 0x0007128f Faulting process id: 0x1634 Faulting application start Unspecified Error While Connecting To Access Database However saving the file through Application.SendKeys "^s" and then running the file through another thread could replicate the outcome of the manual save. Unspecified Error While Opening Oledb Connection Toolbox.com is not affiliated with or endorsed by any company listed at this site.

share|improve this answer answered Dec 28 '10 at 23:26 JeffO 6,22522948 add a comment| up vote 0 down vote Not sure this counts as an answer but, the issue is with this content Thanks. http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B830133 Now, I have ensured that I close all the connections immediately whenever i open them. Browse other questions tagged visual-c++ oledb ms-jet-ace or ask your own question. Adodb.connection Open Unspecified Error

Cheers, Bernard Cheah Reply dave1357 6 Posts Re: Intermittent '80004005' unspecified error Sep 08, 2011 07:49 AM|dave1357|LINK Just to be clear (since lots of people suggested this might be permissions related): If you are trying to access a network drive, see Article #2168 for information on setting up IUSR_ to connect to an Access database via a UNC share. My current solution is to create my class library in VS2008 and reference the compiled DLL in my VS2010 project. weblink So....

There I saw that Enormous amount of memory was allocation in Heap. Just a suggestion. If this still not work, could you please check event viewer to see if can find any clues?

And it works without any problems.

William Thompson replied to What is the name of the Win... I have also checked out the local settings temp folder and winnt temp folder for permissions. This is a list of MS XML Versions http://support.microsoft.com/kb/269238and links for installers and security updates. For Access questions not specific to ASP, please use the Access forum.

let me know, if you need any additional details. Best regards William Zhou -------------------------------------------------------------------------------- Please remember to mark the replies as answers if they help and unmark them if they provide no help. Anybody got any idea on this I would really appriciate the help. check over here I have looked at the permissions several times andtheylook correct (and if they weren't, wouldn't I get this error every time and not just occasionally?).

Based on my experience, 80004005 is more like a permission issue, could youplease check the following that quote from the aspfaq link again, including the linked articles: Again, IUSR_ must have I wrote some test macros, in the same file which has the original macros, that open DB connection to local DB file and remote DB file. Not the answer you're looking for? Best Shopping Cart Award Testimonials Support User Guides Help Articles Contact Us Technical Support My Account My Downloads My Licenses Become a Reseller Reseller Info Referral Program Built for Web Designers

Join us Sign in United States Username Password Cancel "There are 10 types of people in the world, those who can read binary, and those who can't." Send feedback Blog About It would probably save lots of time and heartache into the future. –JcMaltaDev Dec 28 '10 at 14:28 Hello. Thanks to everyone for their suggestions and help. asked 3 years ago viewed 2383 times active 2 months ago Linked 59 How much memory can a 32 bit process access on a 64 bit operating system?

Join them; it only takes a minute: Sign up Unspecified error when trying to connect to an MS Access database on Visual Studio 2010 up vote 0 down vote favorite I've Thus located the root cause.