kermit said:
If I may give an instance of why.
I have been in the habit of having my developers change the .mdb
extention to .txt when then neede to e-mail a database to another
developer. Worked fine until we went to Outlook 2003 and let it
apply the most current security enhancements. Now after you save the
database attachment out of the e-mail (database.txt) to database.mdb
and try to open it, it prompts for a password. Even though no
password was ever applied.! I gather that Access percieves that
Outlook opened or tried to open it as a txt file.
AGRUGGGGHHHHHH!!!!!!! There are ligmiate reasons to e-mail an .mdb
file, even though Microsoft dosen't seem to think so.
So I guess I will have to look for one of the above apps. to be able
to do this.
Asking for a password when none was ever applied is a form of corruption
(non-recoverable AFAIK). One known way for this to happen is to open the
file in another program (Word, Excel, etc.,) and make a change and then
save. My guess is that the equivelant of this is happening to your file
when you change the extension to txt and then Email it.
I do something similar when Emailing these files but I choose a nonsense
extension rather than one that will be a recognized file-type. I have had
no problems with that strategy.