Re: Admin problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Thu, 23 Mar 2006 08:02:30 -0800, Andy
<Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello everyone,

My problem is that I setup my security successfully and everything
was fine
unit I tried to transfer my database from my laptop onto my desktop
for
further development. Unfortunately changing the file path name
obviously did
something to the security, i.e made it not work! And I basically I
had no
access rights on the copy I transfered onto my desktop. So in an
attempt to
fix this I proceeded to foolishly play around with security on my
laptop and
managed to give my admin account no rights! At the moment I can log
on fine
as the Admin but I can't modify anything nor can i give myself my
rights! Any
help would be most apreciated.

Did you also transfer the workgroup file you used to secure the db on
the dekstop? YOu would need this file, and you would also need to
"join" this file, or better yet build a shortcut that points to your
workgroup file. To do this, add a desktop shortcut on your laptop and
set the Target as such:

"Full Path to MSAccess.exe" "Full Path to your database" /wrkgrp "Full
path to your workgroup file"

This will open your db with the workgroup file specified.
.

Relevant Pages

  • Re: Where to place the workgroup file
    ... is on their local laptop. ... You clear their passwords in the common workgroup file located on the ... the user is disconnected from the main database and the rest of the users. ...
    (microsoft.public.access.security)
  • Re: Where to place the workgroup file
    ... workgroup file on their laptops. ... Without access to that laptop, ... I do have an app launching program. ... used by remote users. ...
    (microsoft.public.access.security)
  • Re: Security without signon
    ... I am thinking that you didn't create a new workgroup file to secure it with. ... I have changed the owner of the database and the tables to a user ... > this group and removed all table rights from the default Admins group. ...
    (microsoft.public.access.security)
  • Re: How to find the workgoroup Administrator
    ... Although you can change the default workgroup file, ... creating a desktop shortcut to launch it. ... I have security database done in access 2000 format through acess ...
    (microsoft.public.access.security)
  • Re: Admin problems
    ... If you secured a database, then you will have to have the workgroup file you ... My problem is that I setup my security successfully and everything was ... access rights on the copy I transfered onto my desktop. ...
    (microsoft.public.access.security)