Solved

Error:Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.

Posted on 2008-10-02
8
1,494 Views
Last Modified: 2012-08-03
Hello Experts
I am new to Access, so I am sure what exactly the problem is
We have an image database, and recently we start to have this problem
it says:Cannot open database". It may not be a database that your application recognizes, or the file may be corrupt.  while we are trying to put into ship to ID in a invoice.
sorry for not providing enough information. I will try to put some more later
I just need an idea to work around with it
Thanks
0
Comment
Question by:jimmy1829
  • 3
  • 3
  • 2
8 Comments
 
LVL 25

Accepted Solution

by:
slam69 earned 500 total points
ID: 22623972
take a backup of teh access database and try compact and repairing it

0
 
LVL 25

Expert Comment

by:slam69
ID: 22623979
0
 

Author Comment

by:jimmy1829
ID: 22624020
thanks guys that is something i am going to try first
0
 
LVL 25

Expert Comment

by:slam69
ID: 22658577
any update
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:jimmy1829
ID: 22663957
sorry not yet
I have not got a chance to try it
I will let you know
thanks
0
 

Author Comment

by:jimmy1829
ID: 22776815
Thanks Slam69
Compact and repair solved the problem
0
 

Expert Comment

by:crowen3
ID: 38255492
This doesn't solve the problem when working with SQL ODBC in a win64 environ.  Trying to upgrade my ODBC connector from Standard MS SQL SERVER with the SQL 2008 R2 Admin and Connectivity Services, given I am connecting to 2008 R2 and the Access 2010 gives a standard driver.
0
 

Expert Comment

by:crowen3
ID: 38256780
The problem ended up being copying very large table from SQL to Access (NOT a LINK), that had no primary key/s.  If you cannot add a primary key to the SQL database, you can build a link, build unique identifiers in the Access link, and then run a make-table query to copy the data to an actual table in Access from the Access link.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Direct Mail software 4 46
Unrecognized Database Format 8 94
Set focus on next field when character count = 5 9 12
Access Excel export not behaving 2 27
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now