Forum Discussion
RSLibrary
Feb 28, 2024Copper Contributor
Errors Transferring MS Access Database from 2016 to 365 (Separate Hard-Drives)
Hello, We are a library and our database is currently on Microsoft Access 2016. We recently upgraded our PC, including cloning our HDD (Microsoft Office 2016) to a new SSD (Microsoft 365). Every...
Tom_van_Stiphout
Feb 28, 2024Steel Contributor
> Review your Trust Center settings
That means in Access > File > Options > Trust Center > Trust Center Settings > Trusted Locations: add the folder where the app is located (presumably on your C-drive).
That means in Access > File > Options > Trust Center > Trust Center Settings > Trusted Locations: add the folder where the app is located (presumably on your C-drive).
- RSLibraryMar 14, 2024Copper ContributorThank you.
Now i am able to open the database without the error popup.
However, I do have another issue now. On the old HDD, there were 2 shortcuts that opened MS Access for a particular workgroup (administrator, librarian) and then you enter a logon and a password. Now on the new SSD, the shortcuts are not available and when I open the access database, I am not prompted to log on to a particular workgroup.
Is there a way to log on to a particular workgroup from within Access? I am used to double clicking a shortcut and having the logon and password window greet me. I have a list of the logon usernames and passwords, yet I just need to find a way to log on. Thanks!- George_HepworthMar 18, 2024Silver ContributorSomeone, possibly the developer who created the original Access relational databae application, also s created those shortcuts for you on the original computer. They should still be there. Find and copy them to the new location.