Home

Help with MS Access

%3CLINGO-SUB%20id%3D%22lingo-sub-896279%22%20slang%3D%22en-US%22%3EHelp%20with%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896279%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22contact-container%20with-support-header%22%3E%3CDIV%20class%3D%22virtual-agent-window%22%3E%3CDIV%20class%3D%22va-container%20win-color-bg-0%20vatheme-primary-bgcolor%22%3E%3CDIV%20class%3D%22container-fluid%20container-fluid-with-margin%20text-body%22%3E%3CDIV%20class%3D%22row%20remove-all-margin%22%3E%3CDIV%20class%3D%22col-xs-24%20remove-all-padding%22%3E%3CDIV%20class%3D%22section%20spacer-20-top%20remove-bottom-margin%22%3E%3CDIV%20class%3D%22section-body%22%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EI%20have%20recently%20updated%20my%20Windows%20and%20along%20with%20that%20my%20Office%20got%20updated.%20Ever%20since%20then%20every%20time%20I%20open%20my%20MS%20access%20file%2C%20it%20creates%20a%20new%20file%20and%20saves%20it.%26nbsp%3B%3CSPAN%3ESo%20this%20means%20if%20I%20open%20a%20particular%20MS%20access%20file%2010%20times%2C%20it%20will%20create%2010%20duplicates%20of%20that%20file.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22contact-container%20with-support-header%22%3E%3CDIV%20class%3D%22virtual-agent-window%22%3E%3CDIV%20class%3D%22va-container%20win-color-bg-0%20vatheme-primary-bgcolor%22%3E%3CDIV%20class%3D%22container-fluid%20container-fluid-with-margin%20text-body%22%3E%3CDIV%20class%3D%22row%20remove-all-margin%22%3E%3CDIV%20class%3D%22col-xs-24%20remove-all-padding%22%3E%3CDIV%20class%3D%22section%20spacer-20-top%20remove-bottom-margin%22%3E%3CDIV%20class%3D%22section-body%22%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EFor%20example%20I%20have%20a%20file%20named%20'Inventory%20Database'.%26nbsp%3B%3CSPAN%3EWhen%20I%20open%20that%20file%20it%20opens%20as%20'Inventory%20Database1%22%20and%20saves%20in%20my%20system%20like%20that.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EThe%20when%20I%20open%20'Inventory%20Database1'%20it%20opens%20as%20'Inventory%20Database11'%20and%20saves%20in%20my%20system%20like%20that.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EAgain%20when%20I%20open%20'Inventory%20Database11'%20it%20opens%20as%20'Inventory%20Database111'%20and%20saves%20like%20that.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3ESo%20now%20I%20have%204%20files%20in%20my%20system%20ie.%20'Inventory%20Database'%2C%20'Inventory%20Database1'%2C%20'Inventory%20Database11'%2C%20'Inventory%20Database111'.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%20class%3D%22contact-container%20with-support-header%22%3E%3CDIV%20class%3D%22virtual-agent-window%22%3E%3CDIV%20class%3D%22va-container%20win-color-bg-0%20vatheme-primary-bgcolor%22%3E%3CDIV%20class%3D%22container-fluid%20container-fluid-with-margin%20text-body%22%3E%3CDIV%20class%3D%22row%20remove-all-margin%22%3E%3CDIV%20class%3D%22col-xs-24%20remove-all-padding%22%3E%3CDIV%20class%3D%22section%20spacer-20-top%20remove-bottom-margin%22%3E%3CDIV%20class%3D%22section-body%22%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EAlso%20every%20time%20I%20open%20my%20file%20it%20gives%20me%20a%20security%20warning%20'Some%20active%20content%20has%20been%20disabled.%20Click%20for%20more%20details'.%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%20class%3D%22contact-container%20with-support-header%22%3E%3CDIV%20class%3D%22virtual-agent-window%22%3E%3CDIV%20class%3D%22va-container%20win-color-bg-0%20vatheme-primary-bgcolor%22%3E%3CDIV%20class%3D%22container-fluid%20container-fluid-with-margin%20text-body%22%3E%3CDIV%20class%3D%22row%20remove-all-margin%22%3E%3CDIV%20class%3D%22col-xs-24%20remove-all-padding%22%3E%3CDIV%20class%3D%22section%20spacer-20-top%20remove-bottom-margin%22%3E%3CDIV%20class%3D%22section-body%22%3E%3CDIV%20class%3D%22message%20spacer-32-top%22%3E%3CDIV%3E%3CDIV%20class%3D%22message-content%22%3E%3CDIV%3E%3CDIV%20class%3D%22ac-container%22%3E%3CDIV%20class%3D%22ac-textBlock%22%3E%3CP%3EMoreover%20if%20I%20have%20one%20access%20open%20and%20I%20try%20to%20open%20another%20file%2C%20the%20second%20file%20overrides%20the%20first%20one.%20Meaning%20that%20I%20am%20unable%20to%20open%202%20access%20files%20at%20the%20same%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20this%20has%20happened%20since%20I%20updated%20my%20Windows.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-896279%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-896961%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421112%22%20target%3D%22_blank%22%3E%40rg_9128%3C%2FA%3E%20Try%20compacting%20and%20repairing%20the%20database.%26nbsp%3B%20Also%20try%20clicking%20on%20the%20Enable%20option%20to%20trust%20this%20database%2C%20or%20add%20the%20directory%20that%20this%20database%20is%20in%2C%20to%20your%20Trusted%20Locations%20(from%20File%20-%20Options%20-%20Trust%20Center%20-%26nbsp%3B%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3ETrust%20Center%3C%2FSPAN%3E%20Settings%20-%20Trusted%20Locations.%26nbsp%3B%20Note%20that%20if%20your%20file%20location%20is%20on%20a%20Network%20you%20may%20need%20to%20check%20the%20Allow%20Trusted%20Locations%20on%20my%20network%20box%20first%20(before%20adding%20your%20location)%3C%2FP%3E%3C%2FLINGO-BODY%3E
rg_9128
Occasional Visitor

I have recently updated my Windows and along with that my Office got updated. Ever since then every time I open my MS access file, it creates a new file and saves it. So this means if I open a particular MS access file 10 times, it will create 10 duplicates of that file. 

For example I have a file named 'Inventory Database'. When I open that file it opens as 'Inventory Database1" and saves in my system like that. The when I open 'Inventory Database1' it opens as 'Inventory Database11' and saves in my system like that. Again when I open 'Inventory Database11' it opens as 'Inventory Database111' and saves like that. So now I have 4 files in my system ie. 'Inventory Database', 'Inventory Database1', 'Inventory Database11', 'Inventory Database111'.

Also every time I open my file it gives me a security warning 'Some active content has been disabled. Click for more details'. 

Moreover if I have one access open and I try to open another file, the second file overrides the first one. Meaning that I am unable to open 2 access files at the same time.

 

All of this has happened since I updated my Windows.

 

1 Reply

@rg_9128 Try compacting and repairing the database.  Also try clicking on the Enable option to trust this database, or add the directory that this database is in, to your Trusted Locations (from File - Options - Trust Center - Trust Center Settings - Trusted Locations.  Note that if your file location is on a Network you may need to check the Allow Trusted Locations on my network box first (before adding your location)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies