[AccessD] Access Workgroup Security [WAS: A97 and Win 7]

Stuart McLachlan stuart at lexacorp.com.pg
Tue Mar 19 17:07:17 CDT 2013


It seems that your only problem now is the absence of a .mdw file.

There is no difference between the security model of A97 and A2000/2003.   The all rely on a 
.mdw.

One  way to remove security is to open the application on a machine where it works and just 
export all objects to a new  unsecured mdb file.



On 19 Mar 2013 at 12:09, John Clark wrote:

> I still have not tried this. It has been hard finding a suitable
> guinea pig...I don't want to harm a PC that is working. 

> Basically, I'm beginning to think, it just cannot be done. I have run
> into so many road-blocks...unless someone can give me some sort of
> "proof" that this works, I'm thinking I'm just going to announce that
> it cannot be done. Yes, people claim to have run A97 on Win 7, but was
> that a 32-bit box? I am working on 64-bit, and it ain't budging. I
> have instructions, but I cannot run them...the pieces of these
> instructions just aren't applicable. 

> My approach now is to somehow see if I cannot update this DB instead.
> The problem here though is that this particular access program has
> Workgroup security setup with it. I never liked Access' version of
> security myself, so I never got around to learning it. It won't let me
> update w/the security...not even an option...but I don't think I can
> remove the security w/out A97 running. The only machine I have A97
> working...actually there are two...is a live machine, and I'm leery of
> messing w/those machines that are working. 

> A question...to remove Access workgroup security, is it as simple as
> opening this up, on an A97 machine that works, and removing security?
> Is there any fallout to watch out for? 

> I've been at this now for more than 3 full days...I just have to move on...
> 
> >>> "Jim Dettman" <jimdettman at verizon.net> 3/15/2013 3:47 PM >>>
> <<
> Ah...that is a thought...something that I did think of earlier, but had
> forgotten...uninstalling all, and then going in "older-first" order. Maybe
> I'll try that Monday...I'm tapped...been at this for two whole days w/zip
> for results. 
> >>
> 
> Make sure you use separate directories as well...
> 
> Jim.
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
> Sent: Friday, March 15, 2013 03:09 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A97 and Win 7
> 
> Ah...that is a thought...something that I did think of earlier, but had
> forgotten...uninstalling all, and then going in "older-first" order. Maybe
> I'll try that Monday...I'm tapped...been at this for two whole days w/zip
> for results. 
> 
> And, now I'm wondering if it is even possible for 64-bit. Any instructions
> that I have been given prove to not work. 
> 
> The biggest holdup actually, seems to be a font...Tahoma. I follow the
> directions right along, and all is alright...UNTIL...I get to the part where
> I have to update A97 to SR2. To do this, it says you MUST remove 4 font
> files...Comic and Tahomas...but the Tahoma will not go, says it is a
> "Windows System Font." I cannot remove, move, or change the name of this
> file. So, I try to run SR2 anyhow, and it bombs. The log points to the
> Tahoma font. 
> 
> Now, if I do a version check on the Jet 3.5, it says it is Service pack 3
> (SP3) w/enhanced security ...3.51.3328.0 
> 
> I don't know...back to the drawing board on Monday I guess.
> 
> >>> Stephen Hait <shait at stephenhait.com> 3/15/2013 7:40 AM >>>
> On Wed, Mar 13, 2013 at 2:20 PM, John Clark
> <John.Clark at niagaracounty.com>wrote:
> 
> > OK, I am confused. I've been told...definitively...that Access 97 will not
> > run on Win 7...and that it can. So, what is the answer from this group?
> >
> 
> I run A97 on Win 7 32 bit all the time along with various later versions. I
> don't have a version installed on 64 bit Win 7. I think I installed them in
> the order of earlier versions before later.
> -- 
> 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.
> 
> -- 
> 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