• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1523
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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