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,508 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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.

 
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

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.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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