Error: Unrecognised Database format !!!

[PACALA_BA]

Error: Unrecognised Database format !!!
Hi,...ACCESS 2003 , SINGEL -USER MDB/MDE, ACCESS 2003 file format

One Action <SOMETIMES/ NOT ALLWAYS> generates this error
In the Debugger ALLWAYS=OK
Question: How to catch this error ?
How to FIND-OUT the REASON for this error from the MDB-file.
How i can GENERATE this error ?
thank

(e-mail address removed)
(e-mail address removed)

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9a7b-bbc50aef28d0&dg=microsoft.public.access

 

[PACALA_BA]

Unrecognized database format <filename>. (Error 3343)
Possible causes:
The specified file name is not a Microsoft Jet database.
The specified file name is a device name, for example, a printer or a
console.
The .mdb file has invalid header information or an unknown sort order.
A commit is pending from another user but the lock file cannot be found.
During a commit, you are attempting to write a Long value larger than the 2K
maximum page size.
The database is damaged. Compact the database and then try opening it again.

TMP_DFT_1.MDB
TMP_DFT_1.LDB...CONTENT after ERROR
******************************************
VWSKBACBACMD pacadm VWSKBACBACMD
pacadm VWSKBACBACMD
pacadm
******************************************

 

[Roger Carlson]

Every time I've gotten this error, the database has been corrupted beyond
repair. I don't know that's your problem, of course, but that's been my
experience.

These links might have a solution:
a.. Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm
a.. Recovering from corruption
http://allenbrowne.com/ser-47.html
a.. Fix Corrupt Access Database v4.5
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=25

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[PACALA_BA]

Hi
After REPAIR is my DB O.K.
But i CAN NOT CATCH in my Code
where is the BUG.

 

[Tony Toews [MVP]]

After REPAIR is my DB O.K.
But i CAN NOT CATCH in my Code
where is the BUG.

It is very, very unlikely that the error is in your code.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[PACALA_BA]

Hi, i (SINGEL-USER) am using ONLY ACCESS 2003 MDBs.
*****************************************
My CODE is running, and SOMETIMES interrupted because
of this ERROR
Error: Unrecognised Database format !!!
after Compact @Repair it is FULLY O.K.

 

[PACALA_BA]

How i can GENERATE this error ?
MyDB1
SUB Unrecognised_ERR
dim cnn1 as new adodb.connection
dim cnn2 as new adodb.connection
cnn1.open str1_to_MyDB2
cnn2.open str1_to_MyDB2

' clean-up(close,set to nothing) , currently off
stop
quit ' no-error......
Task manager, and kill Access..is the right way
***********************************
In MyDB2.ldb is
MyPCName,Current User...First connection
MyPCName,Current User...Second connection

END SUB

But in my programm it happens by running an Program in Access
(There is NONE quit or KILL)

 

[PACALA_BA]

Task manager, and kill Access..is the right way

***********************************

but only for LOCK-FILE
MyDB2 is NOT in UNRECOGNISED DATABASE FORMAT !!!

WHAT is the source for this ERROR in MyDB2
*********************************
some table, some file-header,....?????

------------------------------------------------------------------

 

[PACALA_BA]

last expierience (MS-ACCESS-2003 SP3)

myBase.MDB
SaveAsText to... myBase_TEXT.MDB
and make MDE...myBase_TEXT.MDE
myBase_TEXT.MDE...start
Err: Not a valid bookmark(Jet Engine) and than
Err: Unrecognised Database format !!!
dele all damaged databases...
myBase_TEXT.MDB..start
and the SAME WITHOUT errors !!!
**************************
myBase_TEXT.MDE it works OK with ~50%(builds) succes-rate
~50% of builds are wrong ,with small code (un-related) changes....
Bye

 

[Tony Toews [MVP]]

last expierience (MS-ACCESS-2003 SP3)

myBase.MDB
SaveAsText to... myBase_TEXT.MDB
and make MDE...myBase_TEXT.MDE
myBase_TEXT.MDE...start
Err: Not a valid bookmark(Jet Engine) and than
Err: Unrecognised Database format !!!
dele all damaged databases...
myBase_TEXT.MDB..start
and the SAME WITHOUT errors !!!
**************************
myBase_TEXT.MDE it works OK with ~50%(builds) succes-rate
~50% of builds are wrong ,with small code (un-related) changes....

I have no idea what you are trying to tell me.

Did you try importing the MDB into a new MDB?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[PACALA_BA]

Did you try importing the MDB into a new MDB?
YES, (but in Access 2003 is Missing tool Import-all-objects...)
When i build new MDE, i allways make new MDB.
*** All MDBs the same code, but different results ***
myBase.MDB....old
myBase_TEXT.MDB...new-MDB (OK)
myBase_TEXT.MDE...new-MDE
-Err: Unrecognised Database format, **NOT** allways, ONLY sometimes !!!

 

[±èµµÇö]

last expierience (MS-ACCESS-2003 SP3)

myBase.MDB
SaveAsText to... myBase_TEXT.MDB
and make MDE...myBase_TEXT.MDE
myBase_TEXT.MDE...start
Err: Not a valid bookmark(Jet Engine) and than
Err: Unrecognised Database format !!!
dele all damaged databases...
myBase_TEXT.MDB..start
and the SAME WITHOUT errors !!!
**************************
myBase_TEXT.MDE it works OK with ~50%(builds) succes-rate
~50% of builds are wrong ,with small code (un-related) changes....
Bye

 

[Tony Toews [MVP]]

Did you try importing the MDB into a new MDB?
YES, (but in Access 2003 is Missing tool Import-all-objects...)

<shrug> copying each set of objects in isn't a big deal. Hint -
Minimize the database window before starting the process so Access
doesn't waste all that time refreshing the window.

When i build new MDE, i allways make new MDB.
*** All MDBs the same code, but different results ***
myBase.MDB....old
myBase_TEXT.MDB...new-MDB (OK)
myBase_TEXT.MDE...new-MDE
-Err: Unrecognised Database format, **NOT** allways, ONLY sometimes !!!

But I don't understand what the problem is.

Is your native language something other then English? If that is the
case let's see if there is an Access newsgroup in your language in
which you can get some help.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[PACALA_BA]

Hi
I have **ONLY** SPLIT my Code lines to LENGHT = 80 char
and i see THE CHANGE:
- NO MORE Error: Unrecognised Database format !!!
***************************************
-really fewer CRASHES
- but from time to time are Compiler problems present
************************************
New Access Crashes reported to microsoft, but it seems that
LONG code lines are NOT FULLY supported in Access XP/2003
.....my opinion

 

[Clif McIrvin]

Hi
I have **ONLY** SPLIT my Code lines to LENGHT = 80 char
and i see THE CHANGE:
- NO MORE Error: Unrecognised Database format !!!
***************************************
-really fewer CRASHES
- but from time to time are Compiler problems present
************************************

<snip>

thanks for the update

it's good to hear that you're not having so many problems any more.

 

[pacala_ba]

This is a Problem :
VBE6.DLL(6.05.1024) , crashes, compiler errors, vba string
bugs,.....!!!!!!!!!!

 

[Douglas J. Steele]

Check the Corrupt Microsoft Access MDBs FAQ that Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm

I don't believe, though, that's there anyway you can deliberately force the
error.

And please stop making your posts as "Suggestions for Microsoft" when you're
not making any suggestion.