473,399 Members | 4,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

Unrecognized database format

I'm having trouble opening a database a client has sent me. I keep
getting an "unrecognized database format" error.

The database was created in Access 2003. I'm trying to open it with
Access 2003. The client can open it on her computer with no problem,
and she was able to compact and repair it, and resend it with no
problem. Yet I still get the error.

If the database is corrupt, I would suspect that she'd be getting
errors on her end, too, but she's not. Nonetheless, I'm going to ask
her import all of the objects into a new database and resend.

Other than corruption, what else could contribute to this error? It's
not a version issue.

Kurt

Jun 18 '07 #1
4 11276
Update: I had her import all the objects into a new database and
resend - I'm still getting the same error when I try to open it.

The only version difference we have is she created the database in
Access 2003 SP1, and I'm trying to open it in Access 2003 SP2. But
this has never caused a problem.

Confused.

Jun 18 '07 #2
Hi.
Update: I had her import all the objects into a new database and
resend - I'm still getting the same error when I try to open it.
Does the file have, or did it ever have, a digital signature? Does the file
have, or did it ever have a VBA password assigned? If the answer is yes to
either question, then have her create a new Access 2000 database format
database and import all of the objects into it, then compile the code and
compact it. Have her zip the file and send it to you, without adding a
digital signature or VBA password. When you receive the file, scan the file
with your up-to-date antivirus software to determine whether or not it
contains any viruses. If it doesn't contain any viruses, unzip the file,
set your Macro Security setting to low (if it isn't already) and attempt to
open the database file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Jun 18 '07 #3
The file never had a digital signature or VBA password assigned.

But I think I found the problem - the user sent the database to me via
an online file transfer "sendit" link designed to transfer large
files. (A legitimate one that our organization hosts.) It seems that
databases sent through this link produce the error on the receiving
end.

But the error doesn't occur every time. I had some other people send
me some databases with the sendit link, and I got the error when I
tried to open the database. They got the error if I sent a database to
them. But if I send a database to myself through the send it link, no
error. Very weird.

The file transfer thing shouldn't cause this problem, because with the
link you simply upload a file (any kind up to 75 MB), put in the email
address, and click send.

Very strage!

On Jun 18, 2:23 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:
Hi.
Update: I had her import all the objects into a new database and
resend - I'm still getting the same error when I try to open it.

Does the file have, or did it ever have, a digital signature? Does the file
have, or did it ever have a VBA password assigned? If the answer is yes to
either question, then have her create a new Access 2000 database format
database and import all of the objects into it, then compile the code and
compact it. Have her zip the file and send it to you, without adding a
digital signature or VBA password. When you receive the file, scan the file
with your up-to-date antivirus software to determine whether or not it
contains any viruses. If it doesn't contain any viruses, unzip the file,
set your Macro Security setting to low (if it isn't already) and attempt to
open the database file.

HTH.
Gunny

Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
info.

Jun 20 '07 #4
Hi.
But I think I found the problem - the user sent the database to me via
an online file transfer "sendit" link designed to transfer large
files.
Ah. That can happen when FTP transfers between different OS platforms are
made and the default Windows setting is used. Ensure that it's a binary
transfer when uploaded and a binary transfer when downloaded, not "default"
and not "ASCII," either.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Jun 21 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: qbsu21th | last post by:
Dear Sir/Madam, I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecognized database format 'xxx/xx/*.mdb' " error....
14
by: L Mehl | last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE...
7
by: timmso | last post by:
I'm using Ado.net in an asp.net project with an Access backend. Whenever I try to do a simple Select or Update, I inevitably see the error "Unrecognized database format". I'm using Access 2000. ...
1
by: Trygve Lorentzen | last post by:
Hi, my webservice is running on Win2000 SP4, IIS 5.0 fully patched, connecting to a MySQL database and mainly returning Typed DataSet's from webmethods. After running for a while, generally a...
1
by: Rabbit | last post by:
Can anyone tell me why my web developed in .net 2.0, using Access database (.mdb). working fine at my development machines, but when I deploy it onto new Windows Server 2003, the web returns...
6
by: James12345 | last post by:
i have created a database for our advisors to log their call types. It is being run on about 10 different machines. Every couple of weeks, when someone tries to open it, the error Unrecognized...
1
by: syed_razi | last post by:
I have a VB 6.0 application using Access as backend. It is being used on a local area network. The backend database is password protected. The problem is that the database gives me a run time...
4
by: Hepburn08 | last post by:
Hi, I need some help opening a corrupt Microsoft Access database file. I get an error message that says "unrecognized database format". Since I can't open it, I can't export the data to another new...
6
by: MISASIA | last post by:
I really hope someone can help me... My office is using a Menu which running VB. There got many button in that Menu and one of the button which name as "GMR" hit error. Its prompt a message box...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.