Search results

Right, but I'm in a2003 :) With that said, I've fixed it. I'm an idiot. If I had really been paying attention to the code and thought about what it was doing, I would have seen this earlier. When I first hit the issue of non-administrative users not being able to refresh table links, I did...

One small update: I seemed to have a bad reference to the proper syntax for adding permissions to existing permissions. My line: ctr.Permissions = ctr.Permissions And dbSecCreate Should have used an OR instead of an AND: ctr.Permissions = ctr.Permissions Or dbSecCreate After making that...

Thanks for the reply. Maybe I'm overlooking something, but I don't see any code there that addresses the permissions issue. If I use their code, just like mine, it works when logged in under my administrator user, but not if logged in as one of my other users. The issue I'm having is giving...

I have an old Access 2003 database that I'm having some trouble with. I'm trying to create some code that will allow users to toggle some specific linked tables between two Access database (essentially, they are switching between connecting these tables to current data and archived data). I've...