Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1526
  • Last Modified:

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

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
jimmy1829
Asked:
jimmy1829
  • 3
  • 3
  • 2
1 Solution
 
slam69Commented:
take a backup of teh access database and try compact and repairing it

0
 
jimmy1829Author Commented:
thanks guys that is something i am going to try first
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
slam69Commented:
any update
0
 
jimmy1829Author Commented:
sorry not yet
I have not got a chance to try it
I will let you know
thanks
0
 
jimmy1829Author Commented:
Thanks Slam69
Compact and repair solved the problem
0
 
crowen3Commented:
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
 
crowen3Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now