Jürgen Welz
jwelz at hotmail.com
Wed Dec 7 14:57:32 CST 2005
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