PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?dGVyZXNh?=
Guest
Posts: n/a
 
      18th Aug 2005
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.
 
Reply With Quote
 
 
 
 
Scott McDaniel
Guest
Posts: n/a
 
      18th Aug 2005
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?

--
Scott McDaniel
InfoTrakker Software
"teresa" <(E-Mail Removed)> wrote in message
news:F0F49583-0668-4D13-8830-(E-Mail Removed)...
>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.



 
Reply With Quote
 
=?Utf-8?B?dGVyZXNh?=
Guest
Posts: n/a
 
      19th Aug 2005
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" wrote:

> 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?
>
> --
> Scott McDaniel
> InfoTrakker Software
> "teresa" <(E-Mail Removed)> wrote in message
> news:F0F49583-0668-4D13-8830-(E-Mail Removed)...
> >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.

>
>
>

 
Reply With Quote
 
Scott McDaniel
Guest
Posts: n/a
 
      19th Aug 2005
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.

--
Scott McDaniel
InfoTrakker Software
"teresa" <(E-Mail Removed)> wrote in message
news:5F57DF3D-0B31-4799-A4DB-(E-Mail Removed)...
>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" wrote:
>
>> 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?
>>
>> --
>> Scott McDaniel
>> InfoTrakker Software
>> "teresa" <(E-Mail Removed)> wrote in message
>> news:F0F49583-0668-4D13-8830-(E-Mail Removed)...
>> >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.

>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?dGVyZXNh?=
Guest
Posts: n/a
 
      19th Aug 2005
For some reason, when I went back into it just now, it worked. Thank you for
your response and help. It's working now.

"Scott McDaniel" wrote:

> 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.
>
> --
> Scott McDaniel
> InfoTrakker Software
> "teresa" <(E-Mail Removed)> wrote in message
> news:5F57DF3D-0B31-4799-A4DB-(E-Mail Removed)...
> >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" wrote:
> >
> >> 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?
> >>
> >> --
> >> Scott McDaniel
> >> InfoTrakker Software
> >> "teresa" <(E-Mail Removed)> wrote in message
> >> news:F0F49583-0668-4D13-8830-(E-Mail Removed)...
> >> >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.
> >>
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Should I seperate my database? =?Utf-8?B?R3JhY2U=?= Microsoft Access Database Table Design 1 8th Oct 2007 06:16 PM
Seperate Database and Data shadow.demon@gmail.com Microsoft C# .NET 9 2nd Aug 2005 11:56 PM
create a seperate database =?Utf-8?B?aG5nbw==?= Microsoft Access VBA Modules 1 25th Jul 2005 06:19 PM
Creating a seperate database in VBA Ryan Microsoft Access 2 19th May 2004 05:55 PM
Open a seperate database Lauren Microsoft Access VBA Modules 1 10th Jul 2003 01:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:59 PM.