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
Highlighted
New Contributor

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)