Access file errors (1 Viewer)

[amir0914]

Hello everyone,
I have an access file with some forms and tables in it, I was entring data for monthes until it fialed some days ago and no forms and tables comes up. it only shows a table which its name is "MSysCompactError" and it contains some erros :

What exactly should I do ?
Unfortunally I have only backup for 3 month ago.
Thanks in advance.

 

[arnelgp]

it is not clear what is the ErrorDescription Column says.

try Opening the main program, Ms Access first.
then open your database Using "Browse".
Use the "arrow" key on the Open command button and select "Open Exclusive".
try to compact and repair.

 

[amir0914]

Thank you arnelgp, I forgot to mention that my file is ACCDE. I did your recommendations anyway and now the file has two errors after "compact and repair." :

 

[arnelgp]

i am not sure whether you can compact and repair an .accde

 

[oleronesoftwares]

hi
you might need a commercial file extension that can convert from accde to accdb
or use the old backup and re-enter data of the last 3 months.

 

[amir0914]

hi
you might need a commercial file extension that can convert from accde to accdb
or use the old backup and re-enter data of the last 3 months.

What's commercial file extension ?

 

[CJ_London]

the f_ and ~ prefixes indicate these are temporary objects - ones you have created then deleted or created and then not saved. Other than tables and queries which can be created/deleted in a .accde you should not get any errors.

Looks like you are using attachment and/or multi value lookup fields in your app which use deep hidden (i.e. you won't see in the navigation window and cannot access with a query) system tables to manage these types of fields.

You might find this link helpful

Purpose Of System Tables 2 - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

Although keeping tables and forms etc in the same db is fine for temporary apps/demonstrations, strongly recommend you use the recommended basis of keeping tables in a separate back end for any 'production' application.

 

[oleronesoftwares]

What's commercial file extension ?

e.g https://www.file-extensions.org/convert-accde-to-accdb, but am not recommending any, since i have not used any in a few years, this link is just an example. You can read about it

 

[The_Doc_Man]

Just as a point of curiosity that might be relevant... how big is this file?

 

[Pat Hartman]

Do you have the original .accdb? You can recreate the .accde from the .accdb. However, if you have used embedded tables, you have bigger problems. Can you create a new database and try to link to the tables in the .accde. You might be able to import the data from them. Otherwise, you will need to pay someone to get the data out for you. And you STILL need the original .accdb to recreate the .accde.

I would suggest a product like Carbonite. It silently backs up changed files. When you set up, you just pick the folders you want backed up. The annual price is < $100 and the other nice feature is that your cloud backup is available from any computer. If you have to recover all your files at once, you can download them to a new computer but that could take a week if you have a lot of files or for an extra cost, Carbonite will overnight a disk with all the files loaded on it and you can be up and running the next day.

 

[isladogs]

The 2 system tables that are listed in MSysCompactErrors are 'connected'
MSysResources is a visible system table that holds records which contain the Office theme used and any images you have attached to the image library.
The f_..._Data table is a deep hidden table attached to MSysResources that holds essentially the same info but as normalised data.
Both are standard system tables and are created automatically by Access.

You should be able to repair this ACCDE file as follows
1. Make a backup just in case
2. Look in the image library and make a note of any images you have linked to the database
3. In navigation options, tick Show hidden objects and Show system objects
4. Delete the MSysResources table. The f_..._Data table will also be deleted by Access
5. Compact the database. Clean copies of both tables will automatically be re-created but your image library will be empty
6. Add your linked images back to the library
7. Compact again

 

[isladogs]

e.g https://www.file-extensions.org/convert-accde-to-accdb, but am not recommending any, since i have not used any in a few years, this link is just an example. You can read about it

There is nothing to recommend!
If you read the article, it clearly and correctly states that there is no software available to convert ACCDE back to ACCDB.
That reverse engineering can only be done by specialised data recovery companies such as EverythingAccess.com and even then, not if the ACCDE file is badly corrupted

 

[amir0914]

the f_ and ~ prefixes indicate these are temporary objects - ones you have created then deleted or created and then not saved. Other than tables and queries which can be created/deleted in a .accde you should not get any errors.

Looks like you are using attachment and/or multi value lookup fields in your app which use deep hidden (i.e. you won't see in the navigation window and cannot access with a query) system tables to manage these types of fields.

You might find this link helpful

Purpose Of System Tables 2 - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

Although keeping tables and forms etc in the same db is fine for temporary apps/demonstrations, strongly recommend you use the recommended basis of keeping tables in a separate back end for any 'production' application.

Thank you for replying and helping, but I couldn't use the System Tables guidance. I think my case is error and not deep hidden.

 

[amir0914]

Just as a point of curiosity that might be relevant... how big is this file?

The file was 2.5 Megabyte before failure and now is 1.16 Megabyte (after failure)
Actually I don't need to restore all of the objects (query, forms or data) , I only need a table that is stored my customers information.

 

[The_Doc_Man]

OK, I was worried about file size - but 2.5 MB is nowhere near the size limits, so that didn't cause a failure during compaction. You've got others helping you so I'll step away.

 

[arnelgp]

can you upload your db on dropbox/onedrive and share the link? or share it here.

 

[amir0914]

Do you have the original .accdb? You can recreate the .accde from the .accdb. However, if you have used embedded tables, you have bigger problems. Can you create a new database and try to link to the tables in the .accde. You might be able to import the data from them. Otherwise, you will need to pay someone to get the data out for you. And you STILL need the original .accdb to recreate the .accde.

I would suggest a product like Carbonite. It silently backs up changed files. When you set up, you just pick the folders you want backed up. The annual price is < $100 and the other nice feature is that your cloud backup is available from any computer. If you have to recover all your files at once, you can download them to a new computer but that could take a week if you have a lot of files or for an extra cost, Carbonite will overnight a disk with all the files loaded on it and you can be up and running the next day.

Yes of coures, I have the original ACCDB, but it is empty, I mean there is not any data in the tables of the ACCDB !! my data is in ACCDE.
I haven't used any hidden tables in my file, actually I don't know anything about hidden tables. I just made a simple forms and tables in access and compiled to ACCDE and then started to data entry !!

 

[amir0914]

can you upload your db on dropbox/onedrive and share the link? or share it here.

Yes sure,
https://www.dropbox.com/s/4qvkbceum3zyzwn/MyDatabase.accde?dl=0
I need only "tbl_scala", if you extract my table plz send it in private.

 

[oleronesoftwares]

On this link https://social.msdn.microsoft.com/F.../restore-and-accdb-from-accde?forum=accessdev

There is a mention of a commercial tool that can convert accde to accdb, read the article, the link below is that of the commercial tool

MDE to MDB Conversion - Retrieve VBA code from your MDE/ADE Databases

Convert your MDE applications back to MDB form, including VBA source code.

www.everythingaccess.com

 

[isladogs]

On this link https://social.msdn.microsoft.com/F.../restore-and-accdb-from-accde?forum=accessdev

There is a mention of a commercial tool that can convert accde to accdb, read the article, the link below is that of the commercial tool

MDE to MDB Conversion - Retrieve VBA code from your MDE/ADE Databases

Convert your MDE applications back to MDB form, including VBA source code.

www.everythingaccess.com

The link you provided confirms both of the points I was making