Hi Julie,
Glad to help. Please do download and install the latest service pack (SP-3) for Office 2000. You
should also get the latest updates for the JET database engine and your operating system as well,
if you don't already have them. These updates will help you to avoid experiencing such headaches
in the future. The article I pointed you to earlier (
http://support.microsoft.com/?id=304548)
includes links for obtaining the service pack(s) needed for Office 2000.
Here is a link that can help you obtain the latest service packs for your operating system and
the JET database engine:
How to keep a Jet 4.0 database in top working condition in Access 2000
http://support.microsoft.com/?id=300216
Tom
_____________________________________
the problem is that I have not the last version of office 2000 and the
version of VBA (vbe6.dll) is 6.3.91.8...The method describe in the article
304548 is working...thanks a lot for your answer that helped me very much.
Julie
_____________________________________
Hi Julie,
The error you mention is caused by not having the latest service pack installed for Access 2000:
http://support.microsoft.com/?id=304548
Try holding down the shift key while you open the database. This should prevent a startup form
opening or autoexec macro from running. I suspect that you have code behind a startup form that
has been corrupted by this bug.
Tom
__________________________________
I certainly hope you have a good backup. Your database is quite possibly
corrupt. It can usually be fixed, but this does point out the need for good
backups. First, always work on a copy of the database. Working on the
original may make it impossible for a repair service to fix it.
Download a copy of JetComp.exe:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
Also have a look at the Microsoft KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
Then have a look at Tony Toews' Access Corruption FAQ at:
http://www.granite.ab.ca/access/corruptmdbs.htm
for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:
http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
__________________________________
"Cormier Julie (new Caledonia)" <Cormier Julie (new
Caledonia)@discussions.microsoft.com> wrote in message
I work on the development of a geological database
Since today I can't open the base and I have a message box from VBA : Error
access file, the connection has been lost
What does it mean, How can I resolve it ?
