asked on

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

ASKER CERTIFIED SOLUTION

slam69

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slam69

http://www.databasedev.co.uk/compact_and_repair.html

jimmy1829

ASKER

thanks guys that is something i am going to try first

slam69

any update

jimmy1829

ASKER

sorry not yet
I have not got a chance to try it
I will let you know
thanks

jimmy1829

ASKER

Thanks Slam69
Compact and repair solved the problem

crowen3

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.

crowen3

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.

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

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