Re: Open Connection fails with an "Unspecified Error"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


<harald.deischinger@xxxxxxxxxx> wrote in message
news:f9880eaa-17ce-4265-8db5-a6ed05368998@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<snipped>

The MDB is a simple Access MDB file.


Exactly.


Maybe I should also add that the code above is only to provoke the
error. In the real application it happens at most once a day of
continuous usage.


See if this helps...
How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/kb/303528/

-ralph




.

Relevant Pages

  • Re: Revolution 1309
    ... Still it could be permissions issues on resources other than the Access MDB file. ... Since the client app is wholly contained within a VB6 app, and all data access is being performed via ADO, there would be no need to have Access installed anywhere (except, maybe, the server, if the server has been used to run Access as a database maintenance tool). ... MS WSUS Website: http://www.microsoft.com/wsus ...
    (microsoft.public.cert.exam.mcse)
  • Re: Multi-user Database Set Up
    ... I wonder if this might be my problem, I have one access mdb file, that is on ... a network server and when two or more people are opened on the file, ... linked to a front-end to prevent this from happening. ... the database into a front-end (containing the queries, forms, reports, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sure this is a simple problem...but....
    ... The OLEDB provider for JET (or Access mdb file) doesn't work over the ... Internet; only on LAN. ... The Database sits on a Windows 2000/IIs server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Where Should The Front End Live?
    ... I have my database configured and split it, ... one for my employees and one for my fellow supervisors and myself. ... Repair to repair your Access MDB file. ...
    (microsoft.public.access.gettingstarted)
  • Re: Not coding, a question I always wanted to know
    ... The limit is not dependent on the NUMBER of records, it is dependent on the size of the data that is stored. ... Plus any other objects you have in the database - forms, reports, queries, VBA code all consume space if you have not split the application into a front-end and back-end configuration. ... Access MDB file reach the 2.1 Gb... ...
    (microsoft.public.access.modulesdaovba)