[AccessD] Getting around old workgroup security

Rocky Smolin rockysmolin at bchacc.com
Wed Jul 10 11:40:37 CDT 2013


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
 

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

Y'all might remember me picking your brains on this one before...but now it
has become a bit more of a must do issue...
 
One of our departments went behind my back a few years back and had an
outside programmer come in and write a program for them. The program has
been a thorn in my side, and has been nothing but problems since its
inception. 
 
The biggest problem is that this guy used workgroup security. I am NOT a fan
of Access' security...I think there are, in a network environment anyhow,
better ways to do this and access just gets in the way.  I had worked w/this
programmer on a past project, and I stressed this to him at that time. But,
since I was unaware of this one even taking place, I could not steer this
one. 
 
The current issue is that the program, which was written in A97, does not
work properly in our updated environment. Windows 7 does not like Access
97...I know you CAN get it to work, and I HAVE...but it a pain to do so, and
it never seems to be quite right. I want to update this program, but I
cannot seem to do it...roadblocks at every turn. 
 
My initial plan was to open it up in A97, and then get rid of the security.
But this did not work. There must be something w/the libraries because on
two different installs, pieces of A97 just wouldn't work. 
 
This also shut down plan B, because that plan was to create a new DB and
import the pieces. But, I cannot even create a new DB...Access 97 shuts down
when I try. 
 
Is there ANY way to get rid of workgroups w/out opening this thing in A97? 
 

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