access database blocked

One thing to try that hasn't been mentioned yet is to open Access first, and then manually open the database from inside Access. Start Microsoft Access by itself, then go to File > Open and browse to the .accdb file. Sometimes when you double-click a database in Windows, Access doesn't actually receive the filename correctly and it just opens the default template instead.

You can also try holding down the SHIFT key while opening the database. Keep SHIFT held down until Access finishes loading. This bypasses any startup form or AutoExec macro that might be crashing or preventing the database from loading properly.

Another quick test is to try opening the file explicitly from the Run dialog. Press Windows+R and run something like this (adjusting the path as needed):

"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\Path\To\YourDatabase.accdb"

That forces Access to open that specific file and can help rule out a Windows file association problem.

One other thing to keep in mind is that the size change you mentioned is a red flag. If the original file is about 900KB and the repaired version is only about 500KB with no data, that often indicates the database itself may be corrupted. If the above steps don't work, the next thing to try would be creating a brand new blank database and using External Data > Import to see if you can import any tables or other objects from the damaged file.

Richard Rost, MVP
LLAP

I have tried the recommendations, with no success. I can not find "backstage view" when I try to open a file. Whatever I try to open the desired file, it opens "Contacts". I have tried Stellar Repair for Access but it does not work. The database has almost 900KB shown as size. Another Database opens properly. The repaired database from Stellar opens but has no data available- the size of the repaired database from Stellar is less than 500KB. I can not open the desired database on my notebook. Both machines have the latest Windows 11 Downloaded and installed.

Next??

Bill Geier

Please be more specific in describing the circumstances.

"Access Data Base is blocked. Access opens a new contacts database"

Which version and build of Access do you have installed?

Are you trying to open one or more different existing accdbs? Are these located in Trusted Locations?

What does it mean to say, "Access opens a new contacts database"? Are you saying Access creates a new instance of a Contacts database from the Contacts Template each time? Or something else?

Do you get any error messages, warnings or other messages? If so, please share that with us.

Hi @William Geier

Based on the information you described, I understand that your Access database file appears to be blocked. When you attempt to open your specific database, Microsoft Access fails to load your data and instead opens a new default contacts.

After researching this behavior, we have seen similar reports from other users in comparable environments. This behavior can sometimes occur under certain conditions, particularly related to Windows security configurations. For example, if the .accdb or .mdb file was downloaded from the internet, OneDrive, or extracted from a ZIP file, Windows might automatically restrict its "active content." When this happens, double-clicking the file may fail to launch the correct database, causing Access to open a default template instead. This may also be related to configuration or synchronization behavior where macros or startup forms are restricted by your local Trust Center settings.

Let's walk through several checks that often help resolve this type of situation:

-Unblock the File: This step checks if the Windows operating system has applied a security lock to the downloaded file. First, please close Microsoft Access completely > Navigate to the folder where your database file is saved > Right-click the file and select Properties > Look at the bottom of the General tab, if you see a security warning with an Unblock checkbox, check that box, click Apply, and then try opening the file again.

-Move the File to a Local Drive: In some scenarios, this behavior may appear depending on how the service is interacting with cloud or network storage. If the file is currently being opened directly from a network location or a synchronized OneDrive folder, please copy and save the file directly to a local folder on your computer's hard drive (such as your Desktop or Documents) and try opening it from there.

-Add a Trusted Location: This step checks if internal Access security is preventing startup forms from loading. Open the Microsoft Access application (just the blank app, do not open the file yet) > Go to File > Options > Trust Center, and click Trust Center Settings > Select Trusted Locations on the left, click Add new location, and browse to select the local folder where you saved your database. Click OK to apply and then try opening your database.

If you have already saved the file locally to your machine instead of OneDrive, and the behavior continues after trying the steps above, we will need to examine the environment more closely to see what might be restricting the file.

Please try these troubleshooting steps and let me know the outcome. If you still cannot access your data, could you please reply with the exact wording of any specific error messages you see on the screen? Thank you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

When Access opens a different database (for example, a new Contacts template) instead of the expected one, open the correct database explicitly and, if needed, enable its content.

1. Start Access.
2. Go to the File tab to open Backstage view.
3. Click Open.
4. In the Open dialog, browse to the folder that contains the original database file (for example, .accdb or .mdb).
5. Select the file and choose how to open it:
   • Double-click it, or click Open to open it normally.
   • If the file is shared and others need to edit it, click the arrow next to Open and choose Open (shared mode).
   • If the file should be read-only, choose Open Read-Only.
6. If a Security Warning appears in the message bar and the database is from a trusted source, click Enable Content so that all features and data are available.

If Access keeps opening the Contacts template, close that database, then use File → Open to select the correct file as above. After opening it once, it should appear under Recent in Backstage view for easier access next time.

References:

• Access 2010: database tasks
• Create a new database