Hi all,
Name's Chris. How much do I know about Access of ANY version? Nothing. Zero. Zip. Zilch. Gotta be honest up front. So here's the scenario, and I'll try to explain as best I can...
We still have an old application called GEO TMS running on an old Windows Server 2003 box. Evidently, it's little more than an Access database. Best I can tell, it's "Office XP" or Access 2003. It's an old permitting system.
Basically, we had a few dozen users and what they would do is simply use RDP from their client PCs to connect to the server. When the RDP session opened, they were automatically taken to the GEO TMS application/database. We had the paths to the MDB, etc files set as a program to open automatically. So they would go in, do whatever, then close which would also end the RDP session.
NO ONE is using this system anymore, and hasn't for a few years, EXCEPT one guy. He used it up until last month. January 2021 is the last time he used it. Now, he's trying, but can't. Further explanation is required... He used to login to the server as "domain\username". Since last time he used it, he and I had a verbal chat about this username and we decided to DELETE it from Active Directory because it "wasn't being used anymore". Well, it was. For this. And he just didn't realize it and I had no idea. Now, I recreated the username and reinstated all the same permissions it had hoping it would all just start working again. No dice.
So on the server itself is a list of folders, corresponding to users, at E:\GeoTMS\Users\
E:\GeoTMS\Users\Dept1
E:\GeoTMS\Users\Dept2
Etc etc etc
The overwhelming amount of folders in here correspond to users that haven't existed on our network for years. But I do see his folder, and inside it, I do see all the necessary files he used to access up until last month. There are 3 MDE files. Whether I am logged in to the server as him, DOMAIN admin, or local admin, I get the same error if I simply double-click to try to open any of them. This:
So I set out on a permissions path to troubleshoot and there is NO WAY any kind of typical Windows permissions are the issue. Then I stumbled upon a bunch of things I don't understand about it being an "MDW" issue. Totally lost now. There IS an MDW file located at E:\GeoTMS\Data and it is 1.9MB in size with a date last modified of 8/15/2017. I double-clicked it, for fun, and get this:
Again, I get that error no matter who I am logged in as. I then searched for all MDW files on the C Drive and see these guys in the results:
I have NOT tried to open or do anything with those.
I'm sorry to be so long-winded, but I wanted to provide as much detail as possible. Can someone help me, please? It is very, very important that we get back into this, even if it's only for a short time. THANK YOU IN ADVANCE!
Chris