Help with moving Access database (3 Viewers)

[Technics]

The reg file I am merging has been in use since 2016, before moving to 365 and 64 bit.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0]
"Path"="C:\\YourPath\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="3/24/16 3:34 PM"

I have tried all of this with no progress. My database is on D drive of server 2019 and I have tried no mapped drive as most things I find say don't use mapped drives. Server is \\SERVER-PC. I tried using it mapped anyhow T:\TimeClock.accde but did not work. Is your database on the same PC where you're using the program? I can't do that because it is going to be used by several so all changes have to go back to same database. The above does not really portray a real registry key. Can you maybe do a screen shot of that part of your registry?

 

[RonPaii]

I have tried all of this with no progress. My database is on D drive of server 2019 and I have tried no mapped drive as most things I find say don't use mapped drives. Server is \\SERVER-PC. I tried using it mapped anyhow T:\TimeClock.accde but did not work. Is your database on the same PC where you're using the program? I can't do that because it is going to be used by several so all changes have to go back to same database. The above does not really portray a real registry key. Can you maybe do a screen shot of that part of your registry?

You don't need to worry about safe locations for the BE database on the server, only the FE on the workstations. The security prompt is about running code and macros not access data on the server.

 

[Technics]

I am doing all the registry edits on the FE workstation using an .accde file on the FE. I have no problems actually accessing the database on the server.