I'm having a tough time with new budgeting software that our Accounting Department just purchased. It's supposed to run locally on their workstations and laptops. The issue arises when they try to open a .MDB "setup" file that links to additional MDB files stored on a Windows Server 2016 DC Edition file server. Every time they attempt this, they're hit with the dreaded "Run-time error '91': Object variable or With block variable not set." Unfortunately, the software vendor isn't providing much assistance, and the software lacks any logging features. I've already made users local admins, confirmed they have full access to the relevant folders, and eliminated any interference from antivirus and DLP/FRP software. I also tried using ProcMon, but I'm not an expert with it. It seems like there might be a permission issue, since copying the MDB files to a local PC allows the setup file to open correctly. I even tested with a newer Windows Server 2019, but results were inconsistent. Does anyone know of a third-party app that could help diagnose what's causing this error?
4 Answers
It sounds like the actual issue may be with the MDB files or the database itself, not just file-level permissions. If you provide the name of the software, that could help in figuring this out.
Honestly, if the vendor isn't providing support and you're dealing with errors like this, it might be time to look for a different software solution. Also, just to double-check, have you tried mapping the network share to a local drive instead of using UNC paths? Some apps don't play well with UNC.
This sounds like a classic case of a vendor issue. If the software refuses to work properly and support is lacking, escalating this to your management might be the best move. They can push the vendor for a resolution or look for alternatives.
From what you've described, it seems the software can open the files locally but struggles when trying to access them over the network, which is typical for many applications. Consider syncing the files to a local folder instead of using the network share. That might solve the issue.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures