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:

More topics


Compressing mdb file

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

Corrupt Database: Possible solution?

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

No access to MDB

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 ?

Not have the necessary permissions to use the object

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.

error message when opening the database

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

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

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?

converting mdb to accdb format

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

Network DB path has changed, unable to find users/passwords file

Due to a change to our network infrastructure, the network path to our database now has an extra level - from J:\blah\database.mdb to J:\shared\blah\database.mdb

We've updated the shortcuts that point to the database itself, but when we attempt to log in to the database, it gives the error "Runtime error "-2147467259 (8000 4005)" and then says"J:\blah\database backend\database.mdb" is not a valid path" - is there anyway to update where the passwords file should be?

How to convert an MDE to an MDB

If you have written an MDB database file and you want other users to preform applications with it, then you can convert it into an MDE file. But now you want to convert it it back into an MDB file and you don't want to change any codes. This process is simple, keep reading to find out more.

How to change embedded file name

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.