Access2003 is killing databases

  • Thread starter Thread starter Col
  • Start date Start date
C

Col

Hi all,

I have 2 databases built with Access2K.
Opening with Access 2003 sometimes results in the database becoming
inaccessable, no error mesages, no tables.. no nothing.
Repairing does not work.
Creating a new database and importing does not work.
The only solution is to use a backup.

Should I dump Access 2003 and return to a previous version or is there a fix
for the problem.

Regards
Col
 
I use different versions of ACCESS all the time. So no need to dump ACCESS
2003.

What I assume is happening is that you have a database that has been
created/opened in ACCESS 2000, and then you open it in ACCESS 2003, then you
want to open it in ACCESS 2000 again... and that this is when you get the
"failure".

This usually results from a change in the References in the database file.
ACCESS 2003 will change the references for the ACCESS library to Access
11.0. ACCESS 2000 uses Access 9.0 library, though, so it cannot work when it
sees the 11.0 library.

When this happens to a database, open the Visual Basic Editor, click on
Tools | References, and see if 11.0 library is showing in the list. You'll
need to change that reference to the 9.0 library and unselect the 11.0
library.
 
The same set-up works fine for me.

Have you tried to open the 2 A2000-file-format databases with *another*
installation of A2003 software?
 
Thanks for you replies,

I tried with another installation with the same result. I get the Access
window and thats all... no database window or anything. I cannot chect the
references as there is nothing there.
I have tried a database recovery tool (Recovery for Access) but that failed
with

ERROR | [MDB] extract_sys_storage failed: storage not found
INFO | [MDB] end extract_sys_storage


as well as an access violation error:



ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp [36]:
FileRecover
INFO | [CMN] end or_stack_tracer::log_stack_trace
INFO | [CMN]
ERROR | [JTW] msjet40 error [-1525 = 3700]: Invalid precision for decimal
data type.
ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [CMN]================ se_trans start ======================
ERROR | [CMN] exception address : 100a05fe
ERROR | [CMN] exception code : c0000005(EXCEPTION_ACCESS_VIOLATION (The
thread tried to read from or write to a virtual address for which it does
not have the appropriate access.))
ERROR | [CMN] exception flags : 00000000(continuable)
ERROR | [CMN] Read the inaccessible data, address: 0xFFFFFCAC
ERROR | [CMN]---------------- dump_context start ----------------------
ERROR | [CMN] Eax : 0xFFFFFCAC Ebx : 0x0236FC73
ERROR | [CMN] Ecx : 0xFFFFFCAC Edx : 0x7FFFFFFF
ERROR | [CMN] Esi : 0x7FFFFFFE Edi : 0x00000800
ERROR | [CMN] Esp : 0x0236ED8C Ebp : 0x0236EFE4
ERROR | [CMN] Eip : 0x100A05FE EFLAG: 0x00010206
ERROR | [CMN] SegSs: 0x00000023 SegCs: 0x0000001B
ERROR | [CMN] SegDs: 0x00000023 SegEs: 0x00000023
ERROR | [CMN] SegFs: 0x0000003B SegGs: 0x00000000
ERROR | [CMN]---------------- dump_context end ------------------------
INFO | [CMN]
INFO | [CMN] start or_stack_tracer::log_stack_trace
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp [36]:
FileRecover


I only open with Access 2003 now as I have just reinstalled everything and
only Access97 (which I haven't used yet), along with the complete Office
2003 and all patches.

Regards

Col
 
I have never seen the result that you're getting; very unusual. You may want
to contact Microsoft's Product Support group about this one.
--

Ken Snell
<MS ACCESS MVP>


Col said:
Thanks for you replies,

I tried with another installation with the same result. I get the Access
window and thats all... no database window or anything. I cannot chect the
references as there is nothing there.
I have tried a database recovery tool (Recovery for Access) but that
failed with

ERROR | [MDB] extract_sys_storage failed: storage not found
INFO | [MDB] end extract_sys_storage


as well as an access violation error:



ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp
[36]: FileRecover
INFO | [CMN] end or_stack_tracer::log_stack_trace
INFO | [CMN]
ERROR | [JTW] msjet40 error [-1525 = 3700]: Invalid precision for decimal
data type.
ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [CMN]================ se_trans start ======================
ERROR | [CMN] exception address : 100a05fe
ERROR | [CMN] exception code : c0000005(EXCEPTION_ACCESS_VIOLATION
(The thread tried to read from or write to a virtual address for which it
does not have the appropriate access.))
ERROR | [CMN] exception flags : 00000000(continuable)
ERROR | [CMN] Read the inaccessible data, address: 0xFFFFFCAC
ERROR | [CMN]---------------- dump_context start ----------------------
ERROR | [CMN] Eax : 0xFFFFFCAC Ebx : 0x0236FC73
ERROR | [CMN] Ecx : 0xFFFFFCAC Edx : 0x7FFFFFFF
ERROR | [CMN] Esi : 0x7FFFFFFE Edi : 0x00000800
ERROR | [CMN] Esp : 0x0236ED8C Ebp : 0x0236EFE4
ERROR | [CMN] Eip : 0x100A05FE EFLAG: 0x00010206
ERROR | [CMN] SegSs: 0x00000023 SegCs: 0x0000001B
ERROR | [CMN] SegDs: 0x00000023 SegEs: 0x00000023
ERROR | [CMN] SegFs: 0x0000003B SegGs: 0x00000000
ERROR | [CMN]---------------- dump_context end ------------------------
INFO | [CMN]
INFO | [CMN] start or_stack_tracer::log_stack_trace
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp
[36]: FileRecover


I only open with Access 2003 now as I have just reinstalled everything and
only Access97 (which I haven't used yet), along with the complete Office
2003 and all patches.

Regards

Col

Van T. Dinh said:
The same set-up works fine for me.

Have you tried to open the 2 A2000-file-format databases with *another*
installation of A2003 software?
Click to expand...
Click to expand...
 
It looks to me that these errors are from the recovery tools you used rather
than from Access or the database. The file extns ".h" and ".cpp" look like
C++ being used to write the recovery tool.

Try opening the database with Access 2000 or Access 2002 and see if the
database is OK.

--
HTH
Van T. Dinh
MVP (Access)




Col said:
Thanks for you replies,

I tried with another installation with the same result. I get the Access
window and thats all... no database window or anything. I cannot chect the
references as there is nothing there.
I have tried a database recovery tool (Recovery for Access) but that
failed with

ERROR | [MDB] extract_sys_storage failed: storage not found
INFO | [MDB] end extract_sys_storage


as well as an access violation error:



ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp
[36]: FileRecover
INFO | [CMN] end or_stack_tracer::log_stack_trace
INFO | [CMN]
ERROR | [JTW] msjet40 error [-1525 = 3700]: Invalid precision for decimal
data type.
ERROR | [MDB] T: 7. C:\Projects.svn\source\mdbdll\src\msjet.h [358]:
<unk_func>
ERROR | [MDB] T: 6. C:\Projects.svn\source\mdbdll\src\msjet.h [283]:
add_column
ERROR | [MDB] T: 5.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [114]: <unk_func>
ERROR | [CMN]================ se_trans start ======================
ERROR | [CMN] exception address : 100a05fe
ERROR | [CMN] exception code : c0000005(EXCEPTION_ACCESS_VIOLATION
(The thread tried to read from or write to a virtual address for which it
does not have the appropriate access.))
ERROR | [CMN] exception flags : 00000000(continuable)
ERROR | [CMN] Read the inaccessible data, address: 0xFFFFFCAC
ERROR | [CMN]---------------- dump_context start ----------------------
ERROR | [CMN] Eax : 0xFFFFFCAC Ebx : 0x0236FC73
ERROR | [CMN] Ecx : 0xFFFFFCAC Edx : 0x7FFFFFFF
ERROR | [CMN] Esi : 0x7FFFFFFE Edi : 0x00000800
ERROR | [CMN] Esp : 0x0236ED8C Ebp : 0x0236EFE4
ERROR | [CMN] Eip : 0x100A05FE EFLAG: 0x00010206
ERROR | [CMN] SegSs: 0x00000023 SegCs: 0x0000001B
ERROR | [CMN] SegDs: 0x00000023 SegEs: 0x00000023
ERROR | [CMN] SegFs: 0x0000003B SegGs: 0x00000000
ERROR | [CMN]---------------- dump_context end ------------------------
INFO | [CMN]
INFO | [CMN] start or_stack_tracer::log_stack_trace
ERROR | [MDB] T: 4.
C:\Projects.svn\source\mdbdll\src\mdb_creator_impl.cpp [97]: <unk_func>
ERROR | [MDB] T: 3. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[90]: recovery_tables
ERROR | [MDB] T: 2. C:\Projects.svn\source\mdbdll\src\mdb_recover.cpp
[31]: operator()
ERROR | [MDB] T: 1. C:\Projects.svn\source\mdbdll\src\mdb_dll.cpp
[36]: FileRecover


I only open with Access 2003 now as I have just reinstalled everything and
only Access97 (which I haven't used yet), along with the complete Office
2003 and all patches.

Regards

Col
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't open in Access2003 4
"no current record" error in acces 2007 0
Access 2002 vs Access 2003 4
error during loading dll 4
Database gone?! 1
Issue with Access 2003 database 2
Converting Access 97 to Acees 2003 & get conversion Errors 1
Strange Compact and Repair Database Behaviour 1

Back
Top