Re: Open Connection fails with an "Unspecified Error"


<harald.deischinger@xxxxxxxxxx> wrote in message
news:5570639e-cada-4693-bea2-80ffedaf3373@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
When opening a mdb database from two processes, each using two threads
on many systems I catch sometimes an "unexpected error".

The error only shows up when using at least two processes with two
threads each, or using three processes one thread each. Strangely the
problem does not show on some systems. Most times the error shows up
just after one second of running the test application in two
processes, but sometimes several minutes of waiting are needed.

The example program below is only opening an closing a "devices.mdb"
database continuously.

<snipped>

I'm probably missing something, but a MDB file is just a file. With multiple
processes in a tight loop, IMHO, the only thing that would be "unexpected"
would be if there were NO errors. It is probably ADO Connection pooling that
keeps it error-free for those times it lasted "several minutes". <g>

-ralph


.

Relevant Pages

  • Re: question about forked processes writing to the same file
    ... >> still, i have the code written in such a way that i'm opening, locking, ... it is hard to believe that opening and closing a file ... # process missing files ...
    (comp.lang.perl.misc)
  • Re: Problem with modal/popup form
    ... opening the database. ... This combination means that I can no longer get to design mode for the ... Is there any way that I can patch the .mdb file to remove ... Hold the shift key while opening the file. ...
    (microsoft.public.access.modulesdaovba)
  • Re: MAJOR ISSUE - coursework deadline on friday
    ... i dint have access on the computer so proceeded to install it. ... gone through all the neccesary things to do i tried opening it and got ... Microsoft Access will not open the file due to potential security ... See if you can open the new version of Access on your home PC - don't click on any access MDB file, just try to open the software. ...
    (comp.databases.ms-access)
  • Project 2000. Text Column
    ... Saved and closed project. ... Saved project as .mdb file and opened it in access. ... table is showing both the original (missing) text and the newly typed text. ...
    (microsoft.public.project)
  • Re: Opening mdb from file link
    ... The .mdb file has an associated .ldb file which is not located on the ... can't access an .mdb file from a sharepoint site. ... > this would stop the file from opening from Sharepoint? ... > else inherent in opening an Access database from sharepoint? ...
    (microsoft.public.sharepoint.portalserver)