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,500 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 25

Expert Comment

by:slam69
ID: 22658577
any update
0
 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

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…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 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