How do you seperate security from a database one it is set up?

[Guest]

I originally set up security for my database but now don't want to use it
because something has become corrupt and it isn't working. My database is
still there, but I can't get to it.

 

[Scott McDaniel]

The Access Security FAQ has a section devoted to de-securing your database.

What do you mean by "it isn't working" ... can you not access your database?

 

[Guest]

I can't open the database at all. I have tried to rebuild the workgroup
information file, but it still hasn't worked. I was hoping I could just
sever the tie and still have access to my database. Any suggestions

 

[Scott McDaniel]

Do you get any errors when you try to open it?

To open a correctly secured database, you'd have to (a) join the workgroup
which is associated with the file and (b) have a valid user/pass combo. If
you do those two things, you'll be able to open your database. Note that if
you rebuild your workgroup file you must use EXACTLY the same information or
the SID won't be correct, and Access will think it's the wrong workgroup. If
you used the security wizard, the wizard may have saved a copy of this
information for you (search for any files with a .snp extension - that's an
Access snapshot).

You can try re-joining the default system.mdw file (do a file search for
it). You didn't say which version of Access you're using, but basically you
run the Workgroup Administrator utiltiy to rejoin your workgroup.

 

[Guest]

For some reason, when I went back into it just now, it worked. Thank you for
your response and help. It's working now.