[AccessD] Is This A Problem?

Wed Dec 7 16:00:35 CST 2005

"It's all coming back to me now." Jurgen

...hope you got enough moola to make living under the Nazis worth while ...I 
flat can't imagine working in an environment where I couldn't read the file 
extension ...its simply nuts to me :(

...I change Access file extensions all the time without problems, mostly to 
make it easier to id which files go with which apps ...but I've also found 
it helps to get my apps by the security/av scanners without disabling 
security on user created mdbs ...Access doesn't care what you name the 
extension as long as you manage the OS file association problems.

William

----- Original Message ----- 
From: "J?rgen Welz" <jwelz at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, December 07, 2005 3:57 PM
Subject: Re: [AccessD] Is This A Problem?

>I too change extensions as required without problems.  However, rename an
> .xls or .doc file to .xlt or .dot, or the reverse, and the file is in fact
> treated differently by its application.  Switching .mdb for .mde seems to 
> be
> an exception in regard to MSOffice files.
>
> Hotmail blocks mdb files without recourse so I routinely change the
> extension to .txt and then zip the file before emailing.  I recall having
> problems opening a file that was switched to .txt and emailed without
> zipping.  I assume that somewhere in the mail process, some software 
> checked
> the file and destroyed it.
>
> I have noticed that Win XP home tracks some kind of meta data about files
> resulting in persistent warnings about opening certain files that I have
> received via email.  I usually get a generic warning about opening
> downloaded files even after I've opened the file several times from any
> folder to which I've saved the file.
>
> I have a brother who reports that newer versions of Windows remove
> information from Canon digital photo jpg files.  He still runs photoshop 
> in
> Win 95 because he knows it is benign with file extensions.
>
> I have concerns that there will be versions of Windows that will cause
> problems with changing extensions.
>
> As an aside, Nazi IT allows us to show the following attributes of a file:
>
> Name
> Size
> Type
> DateModified
> DateCreated
> DateAccessed
> Attributes
> Status
> Owner
> Author
> Title
> Subject
> Category
> Pages
> Comments
> Copyright
> Artist
> AlbumTitle
> Year
> TrackNumber
> Genre
> Duration
> BitRate
> Protected
> CameraModel
> DatePictureTaken
> Dimensions
> Company
> Description
> FileVersion
> ProductName
> ProductVersion
> Keywords
>
> Users cannot see the file extension and are absolutely barred from 
> changing
> an extension through the Windows interface, and there is no Run menu or
> access to the Command line interface where one might accomplish a change.
> We have users who don't have the sense to distinguish between .ldb and 
> .mde
> files by the size and the icon is identical in our environment.  There is 
> no
> right click option that allows you to see the file extension in properties
> either.
>
> I can shell cmd or use Name ---- As --- syntax to control extensions.  If 
> a
> user adds an extension to a file, it becomes part of the name so you can
> have a richt text file that appears to have an xls extension showing with 
> a
> Word icon and which of course, opens in Word.  Users are able to 'Save As'
> to switch between doc and template extensions from the Office applicaitons
> I've tried, but the default template locatoin is in a place they have no
> rights to save files.
>
> It's all coming back to me now.
>
> Ciao
> Jürgen Welz
> Edmonton, Alberta
> jwelz at hotmail.com
>
>
>
>
>
>>From: "Gustav Brock" <Gustav at cactus.dk>
>>Reply-To: Access Developers discussion and problem
>>solving<accessd at databaseadvisors.com>
>>To: <accessd at databaseadvisors.com>
>>Subject: Re: [AccessD] Is This A Problem?
>>Date: Wed, 07 Dec 2005 20:54:25 +0100
>>MIME-Version: 1.0
>>Received: from databaseadvisors.com ([209.135.140.44]) by
>>bay0-mc12-f8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Wed, 7
>>Dec 2005 11:55:28 -0800
>>Received: from databaseadvisors.com (databaseadvisors.com
>>[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id
>>jB7Jt7J26987;Wed, 7 Dec 2005 13:55:07 -0600
>>Received: from smtp.webpartner.dk (smtp.webpartner.dk [195.184.96.12])by
>>databaseadvisors.com (8.11.6/8.11.6) with ESMTP id jB7Jt4J26973for
>><accessd at databaseadvisors.com>; Wed, 7 Dec 2005 13:55:04 -0600
>>Received: from cactus.dk (unknown [213.150.48.58])by smtp.webpartner.dk
>>(Postfix) with ESMTP id 55D6F93895Afor <accessd at databaseadvisors.com>;Wed,
>>7 Dec 2005 20:52:54 +0100 (CET)
>>Received: from gwdom-MTA by cactus.dkwith Novell_GroupWise; Wed, 07 Dec
>>2005 20:55:04 +0100
>>X-Message-Info: tUj+E00hCsOFValUSR7Tlw6AhqYW3HkVuS7lSLaNOP4=
>>X-Mailer: Novell GroupWise Internet Agent 6.5.4 X-MIME-Autoconverted: from
>>quoted-printable to 8bit by databaseadvisors.com idjB7Jt4J26973
>>X-BeenThere: accessd at databaseadvisors.com
>>X-Mailman-Version: 2.1.6
>>Precedence: list
>>List-Id: Access Developers discussion and problem
>>solving<accessd.databaseadvisors.com>
>>List-Unsubscribe:
>><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=unsubscribe>
>>List-Archive: <http://databaseadvisors.com/pipermail/accessd>
>>List-Post: <mailto:accessd at databaseadvisors.com>
>>List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help>
>>List-Subscribe:
>><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=subscribe>
>>Errors-To: accessd-bounces at databaseadvisors.com
>>Return-Path: accessd-bounces at databaseadvisors.com
>>X-OriginalArrivalTime: 07 Dec 2005 19:55:28.0072 (UTC)
>>FILETIME=[2BD8B480:01C5FB68]
>>
>>Hi Rocky
>>
>>We often create temp database files as .mdm and install front ends
>>("program") as .mdp. You could even name a backend .mdd.
>>This simple trick saves a lot of trouble for double-clicking maniacs and
>>"hides" those Access files for all normal users.
>>
>>/gustav
>>
>> >>> martyconnelly at shaw.ca 07-12-2005 20:23:53 >>>
>>You could call it .rat as long as you are running Access from a command
>>line shortcut
>>I have seen this done to hide mdb files on an IIS webserver.
>>It will possibly mess up windows file associations though if you double
>>click from windows explorer.
>>
>>
>>Charlotte Foust wrote:
>>
>> >I think the extension is more of a UI flag to let you know what kind of
>> >a database file it is.  It doesn't change the essential nature of the
>> >mde to call it an mdb.
>> >
>> >Charlotte Foust
>> >
>> >
>> >-----Original Message-----
>> >From: accessd-bounces at databaseadvisors.com
>> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
>> >- Beach Access Software
>> >Sent: Wednesday, December 07, 2005 10:51 AM
>> >To: AccessD at databaseadvisors.com
>> >Subject: [AccessD] Is This A Problem?
>> >
>> >
>> >Users...you never know what they're going to do...
>> >
>> >I sent an .mde to a client but had to name it .bob to get it past his
>> >network sentries.  Told the user to rename .bob to .mde.  He renamed it
>> >.mdb instead.  Says it runs OK.  Seems to here as well.
>> >
>> >Is it really OK?
>> >
>> >MTIA,
>> >
>> >Rocky Smolin
>> >Beach Access Software
>> >http://www.e-z-mrp.com
>> >858-259-4334
>>
>>
>>--
>>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
> 