ERROR 3049: CANNOT OPEN DATABASE

Question

Dears,

I am getting following error while using Access, kindly help me to figure it out.

Answer 1

Hi

Thank you for posting the thread on our forum.

Based on your description, It seems that you gor the error message while using Access, ( If there have any misunderstanding, please feel free to post back.)

Please try the following steps to check if they can help you solve the problem:

1. Check if the database has reached or exceeded the 2 GB limit. If so, running MS Access built-in ‘compact and repair’ utility may help.

• Open MS Access application.
• In the window that pops-up, double-click Blank desktop database.
• Go to File, and then click Close.
• In the window that appears, click Database Tools, and then choose Compact and Repair Database on Tools menu.
• 
• In Database to Compact From dialog box, find and select the database you want to compact and repair
• Open copy of the compacted and repaired database. The copy will be saved in the same location as your previously saved original database.

2. Attempt to import and restore data from the corrupt db into a new Access database. To do so, follow these steps:

• Create a new database file, by clicking Blank desktop database (refer to Figure 2).
• Click the External Datatab, and select Access on Import & Link menu.

• ****In Get External Data – Access Database dialog box, browse the source (i.e. corrupt) db.>Click OK.
• 
• Step 5: In Import Objects dialog box, click the tab depending on the objects you want to restore. For instance, choose ‘Forms’ to import forms from the source db into the new one.

NOTE: Click the ‘Select All’ button if you wish to restore all the objects.

• Click OK to finish importing the selected objects into the new database.

Hope the information can help you.  And if there have any unclear or misunderstanding, please feel free to post back and we’ll continue to help you all the time!

Your understanding and patience will be highly appreciated! Hope you have a good day and keep safe!

Best regards,

Stacey

Answer 2

Sometimes accdbs are corrupted. There are different ways this can happen. The way to recover is to use the most recent back up copy you made before this happened.

Answer 3

Dear Stacey Feng MSFT,

Thanks for the support..