Access database runs on one PC but not on another.

Question

I have a number of Access database programs I have written with VBC code & splitting the data into a 'backend' database.  I keep the 'backend' database files on my desktop computer and have a copy of the 'program' database files of the the desktop and the laptop.   All but one of my Access programs run just fine.  But the one that doesn't is a real mystery.  It runs just fine from the laptop but when run from the desktop it does not respond to clicked events!  After entering the database password the first form, a sign-in form that is used to control permissions, opens.  It is a simple form, with code written for the 'Continue' button and the 'Exit' button.  But the click event for either of these buttons is never trigger!  I have three other Access database programs that I wrote that run just fine on the same computer.  Both computers have Windows 10 Pro,  I have Microsoft Office 2010.  Please suggest something.

Answer 1

Hi,

Are you storing the database files in a Trusted Location? Do you see a yellow bar with a button labeled "Enable Content?" If so, have you tried clicking it?

Just a thought...

Answer 2

All the files are available on my LAN and the locations are trusted.  But that would only be an issue if the problem was on the laptop.  Where I am having the problem is on the computer that contains the files locally. No yellow bar, no "Enable Content".  It appears that the clicked event for the Buttons is not being detected.

Answer 3

Hi,

To make sure the content is enabled, try the following steps:

1. Hit Ctrl + G

2. Enter

?Date()

What did you get as a result, if any?

Answer 4

Thanks for your suggestion, and although it was not answer my problem it did lead to a solution. When I opened the database program with the shift-enter and followed the above steps VBA opened and I did get the current date.  I did this with all four of my Access applications. But it got me to reading more about macro permissions (not sure why) and I compared these permissions on my two computers.  This lead me to change the Trust Center Macro Setting from 'Disable all macros except digitally signed macros' to 'Disable all macro with notification'.  Once I did this and opened the problem Access database the yellow bar and 'Enable Content' appeared and I was then able to proceed.

Thanks for responding to my problem.

Answer 5

Hi,

Congratulations! Glad to hear you got it sorted out. Good luck with your project.