CRAP! i F-ed up MS Access Perms! what do i do?

[skisteven1]

I'm the IT guy at a small company, and the boss was having trouble getting access to the MS Access database over the network. He'd been having to go over to the server and sit down and work on it. Not a huge deal, but an annoyance. So I tried playing with windows perms to allow full access over the network. No change. So then, I started putzing around with the internal security of the MS Access file. BAD IDEA! I think i changed his user to an administrator of the file, but i find out this morning that now he can't access it at all!!!!!!

help!!!

 

[mechBgon]

Restore from tape backup. You DO have tape backups of your mission-critical database.



...right?

 

[JEDIYoda]

Originally posted by: skisteven1
I'm the IT guy at a small company, and the boss was having trouble getting access to the MS Access database over the network. He'd been having to go over to the server and sit down and work on it. Not a huge deal, but an annoyance. So I tried playing with windows perms to allow full access over the network. No change. So then, I started putzing around with the internal security of the MS Access file. BAD IDEA! I think i changed his user to an administrator of the file, but i find out this morning that now he can't access it at all!!!!!!

help!!!

Hello...I thought you learned about making back Up`s to everything in IT 101 classes??

 

[networkman]

http://www.snidelyworld.com/Humor/ProblemSolve.pdf

 

[Jeff7]

So....change permissions on it so that you can access it again? I don't quite get what the serious problem is here. If someone has administrative access to the server with the files, that person can take ownership of the files in question and mess with the permissions again.


One test, at least for basic functionality. Use add user Everyone, and set to full permissions (briefly), and then make sure the boss can access. If he can, ok, basic connectivity confirmed - then go immediately remove "Everyone" and apply that, and then futz around with the permissions until it works. If he still can't access the files when Everyone is set to full-access, it's some other problem, not file permissions.

 

[mechBgon]

Originally posted by: networkman
http://www.snidelyworld.com/Humor/ProblemSolve.pdf

ROFL!

 

[skisteven1]

OK, got it solved. I would have responded sooner, but for some reason i couldn't get into the forums for several hours. I thought for a while that it was a windows file perms thing.... however, that turned out to not be the case (after playing with "everyone" perms).

After some googling, I figured out that the Administrator/Workgroup file got reset (that SO wasn't me). After trying all of the 15 potential files I found, I figured out which one it was (always the last one), and *poof* everything worked again. First thing I did? made a backup of the file.

So now everything works, and I even fixed another problem we were having which was related (but I didn't know was related). Thanks anyway guys.

 

[mechBgon]

:beer: