[AccessD] OT: Zip files (was Logic issue)

Charlotte Foust cfoust at infostatsystems.com
Thu Aug 25 16:59:30 CDT 2005


But then you have to know that you are receiving a renamed zip file and
should do something with it.  An unopened zip file just sits there,
regardless of the extension, so what's the point?

Charlotte Foust


-----Original Message-----
From: Elam, Debbie [mailto:DElam at jenkens.com] 
Sent: Thursday, August 25, 2005 9:09 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] OT: Zip files (was Logic issue)


I know we temporarily block these files and several others.  It gives
the admins some time to scan before the file is delivered, but it does
get delivered.  Are you sure these are not getting through at all?

If they are never getting through, I have received some files with a
differently named extension.  Text.zip is renamed to Text.zi and gets
through.  I must rename it back before I can open it, but it works.

Debbie

-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com] 
Sent: Thursday, August 25, 2005 10:58 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] OT: Zip files (was Logic issue)


IMHO it's caused by IT people who are too paranoid by far. They invest
thousands on virus scanning software, keep updating the sig files every
24 hours, but in the end they don't trust it to weed out the viruses
coming at them via ZIP files. Rather than scanning the contents of ZIP
files they blindly block them. Also, don't the realize that most (All?)
antivirus programs can be set to scan files when they are opened and or
written to disk? So even if a zip file does have a virus, the anti-virus
package should kill it.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Thursday, August 25, 2005 11:21 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: Zip files (was Logic issue)


Does anyone know what the logic is for blocking zip files?  I run into
this occasionally and it drives me nuts!  You zip files to avoid the
filters that won't accept an mdb, etc., and then you run into filters
that won't accept the zip files.  Oops, Catch-22.  That drumming you
hear is my head pounding against the wall ....

Charlotte Foust


-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Thursday, August 25, 2005 5:08 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Logic issue


Yes Frank, I always like to checkout someone's ideas...I learn so much
more than any book can teach. My address is john.clark at niagaracounty.com


If this is a zip file, change the extention to something like .zp,
because we block .zip files.

John W. Clark
Computer Programmer
Niagara County
Central Data Processing

>>> frank at fhsservices.co.uk 8/24/2005 5:21 PM >>>
Here's a different solution!
If you have a checkbox for each title or position that can be applicable
to each person represented through the database then, on the client form
of any of people the list the checkboxes will indicate positives for the
applicable option. So, Jack Jones can have the boxes ticked for Defence
attorney, prosecuting attorney, Judge etc. etc. The final checkbox (no 9
on my sample) can be set to "Other" and have an associated textbox in
the table which will only be displayed it no 9 is ticked and the text
will be entered into the open, blank textbox for storage and later
retrieval. The trick here is to combine the bit value of each checkbox
to obtain a unique value for the combination of boxes ticked. I have a
small database of the principle as a working example which I can forward
to anybody who would like to see it. The AccessD list is limited to a
30K unit size and will not allow me to attach the sample to this text

Kind regards,
 
Frank Hill

Kind regards,
 
Frank Hill

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: 24 August 2005 18:36
To: accessd at databaseadvisors.com 
Subject: [AccessD] Logic issue

Hi all

I am having trouble working out how I want to go about something, and I
am hoping somebody here can give me a nudge. It doesn't sound difficult,
but I'm running into dead-ends. I am starting to think that I will just
have to go ahead and finish up with "whatever" and work around things.

I am doing a project for a district attorney's office, and it will
basically just keep tabs on everybody that passes through the system.
The problem is though that there are "Defendants", defense lawyers,
prosecuting lawyers, judges, and victims, and it isn't rare for a single
person to cross into multiple lists. And, theoretically, it is possible
to be in all lists. For instance there are many prosecuting lawyers that
become defense attorneys, and it is not unlikely that one of these
attorneys could be a judge in the future. That scenario is very
possible, and you can add it that a lawyer is very able to be a victim,
and hell, we all know they can be criminals ;) Another scenario that
happens very frequently, is that a person is both a defendant and a
victim. 

I don't want the person entering data to scroll through hundreds, and
eventually thousands, of names to pick an attorney's name from among the
list of everybody else in the system.

The idea I am working on presently is to add logical fields for each
designation to the table of names. For instances:

kNameID
txtLastName
txtFirstName
txtMI
txtSuffix
logAttorney
logADA
logJudge
logVictim
logDefendant

If I do this, I will have removed some fields that are currently there,
such
as:

txtAddress1
txtAddress2
txtCity
txtSt
txtZip
txtPhone

And, I will put these in another linked table. There may be a need to
have multiple addresses for the defendants, so this would be best I
think.

The problem that I am foreseeing here...I'm not at that point, so my
fears could be unfounded...is setting these fields to true and/or false,
as needed.  Basically, thinking of victims for a minute here, the
defendant screen, which will actually be an "Indictment" screen, will
have a subform to hold potentially many victims for the indictment. If a
victim IS already in the system as something else, I will need to tag
that name as a victim and I'm wondering if this will present
difficulties.

Well, I hope I am being clear enough. If anyone out there has any tips
for me, I would greatly appreciate it if you would pass them along.

Thank you!

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1)
subject to the Attorney-Client Privilege, (2) an attorney work product,
or (3) strictly confidential. If you are not the intended recipient of
this message, you may not disclose, print, copy or disseminate this
information. If you have received this in error, please reply and notify
the sender
(only) and delete the message. Unauthorized interception of this e-mail
is a violation of federal criminal law. 
This communication does not reflect an intention by the sender or the
sender's client or principal to conduct a transaction or make any
agreement by electronic means.  Nothing contained in this message or in
any attachment shall satisfy the requirements for a writing, and nothing
contained herein shall constitute a contract or electronic signature
under the Electronic Signatures in Global and National Commerce Act, any
version of the Uniform Electronic Transactions Act or any other statute
governing electronic transactions.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list