Topics Search

How to fix the error from .mdb file?

How to fix the error from .mdb file?
Views: 12
I use MS Access 2003 with Windows 7. From last 3-4 days I have dealing with an error. Whenever I try to open my database file (.mdb) I stop myself with this "Microsoft Access has detected corruption in this file." How to fix this error? I'm in need.
Sponsored Links:

Similar posts...


Compressing mdb file

Compressing mdb file Icon
The mdb file is automatically compressed when the mdb file is closed. How to make the file size even more smaller? Can we add in some function in the VBA code for archive purpose

No access to MDB

No access to MDB Icon
I need to migrate a MDB file from a third-part program to a SQL Server database in my application. My customer have provided the MDB file but when I try to read any table, I get an error telling me I don't have permission to do it. I can open the DB and even see the tables, but can't do anything more. I don't have further experience with Access as I always use SQL Server or Firebird. How can I have access to the MDB data ?

Corrupt Database: Possible solution?

Corrupt Database:  Possible solution? Icon
I have a corrupt ms-Access mdb which contains many hours of development work. Arrgghh!

In the past I have been able to use the "/decompile" switch, followed by a repair and compact in order to get into the file. Indeed, even when I couldn't fix the corruption, I found that I was able to copy the components out of the file into an empty mdb.

But this time none of that seems to work and I keep getting messages like "The database 'c:\xxx.mdb' can't be repaired or isn't a Microsoft Access database file". A message which also appears when I try to import into an new, empty MS-Access mdb.

I really hope that someone out there has a suggestion for me (or a helpful link

getting data from a Microsoft Access DB (.mdb file)

getting data from a Microsoft Access DB (.mdb file) Icon
I need to write a script that queries a MS Access database (in a .mdb file). The file itself is sitting on the Linux box which this script will be running from. The program that uses the DB runs on a Windows box and accesses the .mdb file via a samba share.
What are my options for accessing this DB from the Linux side? Can I read from the .mdb file directly with some module? Can I use DBD::ODBC to access the DB across the network?

Not have the necessary permissions to use the object

Not have the necessary permissions to use the object Icon
I am getting the above error when I try and open an Access 2003 database. nothing I do seems to work. There is only a MDB file and no other files that I can see. I have seen posts that refer to other files that need to be associated with the mdb file but there are none.

This is a Very old database system which suddenly my company wants to revive. Is there a way I can get into the database and see the objects and tables? I have tried importing the database into SQL and no luck, same error.

converting mdb to accdb format

converting mdb to accdb format Icon
I've been developing a DB within Access2010 in the mdb format. I'm trying to convert it to a accdb format. Per the Microsoft instructions, I have the mdb opened, then select save as, make sure the file type is Access2007 and enter a new file name. After doing this, when I open the new file, it shows its in the mdb format. I've tried creating a new accdb file, then importing the objects, but I'm having problems here also

How protecting a mdb database ?

How protecting a mdb database ? Icon
I've looked in the previous post but I did not found what I am looking for.

The issue is: how can I protect a mdb database from password recovery devices ?

In shorts: I have to send this mdb file to somebody, but I don't want him to open this mdb but only to send it some queries.
At the moment, he can open this mdb file with a password recovery device

error message when opening the database

error message when opening the database Icon
after double clicking on the myDBname.mdb file, the following error message pops up:

The Microsoft jet database engines stopped the process because you and the other user are attempting to change the same data at the same time.

I was not able to go into the database. Is there any way to fix this corrupted database? I had tried the compact and repair, but it didn't

Automatically createing Backup.mdb file

Automatically createing Backup.mdb file Icon
We have created a ms access application for our testing purpose, there is a enhancement to our application under test , so to add corresponding changes to ms access application we are making necessary changes to the .mdb file but when we are saving the file automatically "Back up.mdb" file is created .

Could some one help me on this one how to make necessary changes to the existing .mdb file with out creating the "Back up" one

How to change embedded file name

How to change embedded file name Icon
I know nothing about Access, but have an issue a church with an .mdb file someone previously created.

A Excel file( .xls ) is created by another program and that file's absolute location is embedded in an .mdb file. The data from the Excel file is used to generate attendance sheets using the .mdb file and a "trial" version of Access.

The software that creates the Excel file was upgraded and the new software is in a different location that previously. The reportthat creates the Excel file works in the new location, but the location where the file is saved is under the new software's directory.

I would like to modify the location of the Excel file that is in the .mdb file to point to the new location.

How do I do this?

It appears that the computer this .mdb file is on only has a "trial" version of Access. However, I can use Access on another machine to modify the file location in the .mdb file if necessary.

Between this is running on Windows XP. Other machine with Access is running Windows 7.