[AccessD] Getting around old workgroup security

John Clark John.Clark at niagaracounty.com
Thu Jul 11 14:20:41 CDT 2013


Yes, Jim...and I was going to reply personally...that was an immensely generous offer, and I very much appreciated it. I just got into working on this today...had an intern watching over my shoulder on it too. And, I had to go w/my son today...he asked that I tag along, while he and his girlfriend singed the lease on their first apartment. But, I was going to write later, when I got home. 
 
I also had the issue of data in this thing. I would imagine I'd take some major heat if I sent this personal info out. There is this whole process that I'd never ask someone doing me a favor to do. If it came to that, I'd simply strip the data though...not a big deal. 
 
We did make some major headway on this though. I found two old laptops that were just removed from departments. One had Win XP on it, so I figured to load Access 97 and be one my way. The other was actually a Win 95 machine...didn't even think any remained around here. 
 
On the XP machine, I had some issues. First I had a problem w/the Hatten font and an OCX wouldn't register. I moved the font and reinstalled w/out HTML...that was the OCX that was offended...and it loaded fine. Then when I went to run it, I got the "Out of Memory" notice. I know from the past, that this means I needed to load up the new JET, but in the mean time the intern was loading the W95 machine and Access 97 loaded right up on that w/no issues.
 
The only problem is, it has no CD Rom, no USB, and we had problems connecting it to the network cleanly. So, I used the XP to connect to it via IP address for file transfer purposes. Did the work on the W95 machine. And, I had my PC sitting in the middle connected and can share via network w/the XP machine. 
 
The programmer really tried tightening this up, so there was no "admin" rights...he created and gave all rights to "MyAdmin" instead. I had to...intern did it...grant admin rights for each and every object to "admin." Then I created a new DB and imported all objects. I then got the file over to my PC and went right into opening it...and hopefully updating...in Access 2010. I didn't know if this would work, but I thought I'd try...I have a safe copy. 
 
It didn't appear to work, but I had to leave for a while. I'm back now, but I probably won't get to it until morning now. 
 
I'll give an update tomorrow...

>>> "Jim Dettman" <jimdettman at verizon.net> 7/11/2013 1:21 PM >>>
John,

  Not sure if you saw my off-line e-mail or not yesterday, but it's sounds
like your on your way.

  To de-secure a DB, you need the workgroup file it was secured with.

  Login as admin, open the DB, and then assign all rights to the users group
for all objects (which is the same in every workgroup file).

  If your going to continue to use the same workgroup file with it, you can
then set the admin user to a blank password.

  To strip out any remaining security, you'll need to start Access normally
using the standard workgroup file, create a new db container, and then
import all objects from the old DB.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, July 11, 2013 11:18 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Getting around old workgroup security

No...tried that...doesn't work. 

But, what I did do is setup an old laptop that had Win 95 on it...yes, Win
95...and it also had A97. We just got this relic back from a department last
week...good timing.

I'm in the program, so now I just have to remove security...or so I am told.
If any of y'all have any tips or instructions for this, I'm all ears...or in
our case, I guess it is eyes ;o)

I'm going to be googling now, but I'll look for your input.

>>> "Rocky Smolin" <rockysmolin at bchacc.com> 7/10/2013 12:40 PM >>>
Can you open a blank db in A2003 or later and import all the objects from
the A97 db?

Or save the A97 db in 2003 format or later and get around it that way?

R

Notice: This electronic transmission is intended for the sole use of the
individual or entity to which it is addressed and may contain confidential,
privileged or otherwise legally protected information. If you are not the
intended recipient, or if you believe you are not the intended recipient,
you are hereby notified that any use, disclosure, copying, distribution, or
the taking of any action in reliance on the contents of this information, is
strictly prohibited. Niagara County is not responsible for the content of
any external hyperlink referenced in this email or any email. 
IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER
IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR
ELECTRONIC COPIES. 
Thank you for your cooperation.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


Notice: This electronic transmission is intended for the sole use of the individual or entity to which it is addressed and may contain confidential, privileged or otherwise legally protected information. If you are not the intended recipient, or if you believe you are not the intended recipient, you are hereby notified that any use, disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information, is strictly prohibited. Niagara County is not responsible for the content of any external hyperlink referenced in this email or any email. 
IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER OR ELECTRONIC COPIES. 
Thank you for your cooperation.


More information about the AccessD mailing list