Opening MDE Application using File Associations.

[David Allison]

I am looking to open my MDE Application using the DB files associated
with the application I have created. My application is using a non
descript three digit extension that is related to the application
name. I would like to be able to lauch my app and open the file that
is being clicked. Any ideas?

[MGFoster]

Re: Opening MDE Application using File Associations.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the application file is an .MDE then it's extension should be .mde.
That extension should be associated w/ Access.exe. You open the
application that uses the db files not the other way around 'cuz many
applications may be able to use the same db files.

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDWzDoechKq OuFEgEQItlgCgh3 1uwLG7WUHFDlLRO HT6u1mEGzsAoICt
o7nYf9Z3wGya6xC CZV+yOKli
=0HBe
-----END PGP SIGNATURE-----


David Allison wrote:
[color=blue]
> I am looking to open my MDE Application using the DB files associated
> with the application I have created. My application is using a non
> descript three digit extension that is related to the application
> name. I would like to be able to lauch my app and open the file that
> is being clicked. Any ideas?[/color]

[David Allison]

Re: Opening MDE Application using File Associations.

MGFoster <me@privacy.com > wrote in message news:<jqiZb.108 3$yZ1.53@newsre ad2.news.pas.ea rthlink.net>...[color=blue]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> If the application file is an .MDE then it's extension should be .mde.
> That extension should be associated w/ Access.exe. You open the
> application that uses the db files not the other way around 'cuz many
> applications may be able to use the same db files.
>
> MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>[/color]

Thanks for the advice but I don't know if I communicated clearly
enough. What I am looking for is the ability to use alternate
extensions for my backend .mdb files so that the application .mde file
will be launched when the alternate extension (.mdb) file is double
clicked. I hope that makes more sense. Still looking for ideas.

[MGFoster]

Re: Opening MDE Application using File Associations.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When the application is split into 2 files (front-end & back-end) you
can't open the front-end by opening the back-end. This would imply
there is something in the back-end (code) that will open the front
end. You could make an AutoExec macro in the back-end that opens the
front-end. This would be kinda crazy. What if there are more apps
that use the data - which app to open?

I believe Access needs to see an extension of .mde or .mdb on the back
end (data) file before it will use it as a JET (Access) data source.

You can go into the File Types & create an extension that will open
Access:

1. Open Windows Explorer
2. Under Tools menu select Folder Options
3. Click tab File Types
4. Click the New button
5. Follow the directions on creating the new extension & the
associated file.

I really don't recommend this. But, hey, its your computer. Of
course you realize that this change will only affect your computer.
If you want this file association to be available by other
users/computers you'll have to change their PC's File Type
associations.

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDZggIechKq OuFEgEQIWxACeIV cU/0AEIqzJ7XWmZEbH HZMdmXMAoJZu
r+3jl7qW93iQOXY w1DRQceKc
=Wnq3
-----END PGP SIGNATURE-----


David Allison wrote:
[color=blue]
> Thanks for the advice but I don't know if I communicated clearly
> enough. What I am looking for is the ability to use alternate
> extensions for my backend .mdb files so that the application .mde file
> will be launched when the alternate extension (.mdb) file is double
> clicked. I hope that makes more sense. Still looking for ideas.[/color]

[Tony Toews]

Re: Opening MDE Application using File Associations.

MGFoster <me@privacy.com > wrote:
[color=blue]
>I believe Access needs to see an extension of .mde or .mdb on the back
>end (data) file before it will use it as a JET (Access) data source.[/color]

There have been a number of postings from folks who hide the fact that they are using
Access MDB/MDEs by putting a non MDB/MDE extension on the files. And that it works
just fine. This includes linking from the FE to the BE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm